Definition and Usage
The DATE_FORMAT() function is used to display date/time data in different formats.
Syntax
DATE_FORMAT(date,format)
Where date is a valid date and format specifies the output format for the date/time.
The formats that can be used are:
Format Description
%a Abbreviated weekday name
%b Abbreviated month name
%c Month, numeric
%D Day of month with English suffix
%d Day of month, numeric (00-31)
%e Day of month, numeric (0-31)
%f Microseconds
%H Hour (00-23)
%h Hour (01-12)
%I Hour (01-12)
%i Minutes, numeric (00-59)
%j Day of year (001-366)
%k Hour (0-23)
%l Hour (1-12)
%M Month name
%m Month, numeric (00-12)
%p AM or PM
%r Time, 12-hour (hh:mm:ss AM or PM)
%S Seconds (00-59)
%s Seconds (00-59)
%T Time, 24-hour (hh:mm:ss)
%U Week (00-53) where Sunday is the first day of week
%u Week (00-53) where Monday is the first day of week
%V Week (01-53) where Sunday is the first day of week, used with %X
%v Week (01-53) where Monday is the first day of week, used with %x
%W Weekday name
%w Day of the week (0=Sunday, 6=Saturday)
%X Year of the week where Sunday is the first day of week, four digits, used with %V
%x Year of the week where Monday is the first day of week, four digits, used with %v
%Y Year, four digits
%y Year, two digits
Example
The following script uses the DATE_FORMAT() function to display different formats. We will use the NOW() function to get the current date/time:
DATE_FORMAT(NOW(),'%b %d %Y %h:%i %p')
DATE_FORMAT(NOW(),'%m-%d-%Y')
DATE_FORMAT(NOW(),'%d %b %y')
DATE_FORMAT(NOW(),'%d %b %Y %T:%f')
The result would look something like this:
The DATE_FORMAT() function is used to display date/time data in different formats.
Syntax
DATE_FORMAT(date,format)
Where date is a valid date and format specifies the output format for the date/time.
The formats that can be used are:
Format Description
%a Abbreviated weekday name
%b Abbreviated month name
%c Month, numeric
%D Day of month with English suffix
%d Day of month, numeric (00-31)
%e Day of month, numeric (0-31)
%f Microseconds
%H Hour (00-23)
%h Hour (01-12)
%I Hour (01-12)
%i Minutes, numeric (00-59)
%j Day of year (001-366)
%k Hour (0-23)
%l Hour (1-12)
%M Month name
%m Month, numeric (00-12)
%p AM or PM
%r Time, 12-hour (hh:mm:ss AM or PM)
%S Seconds (00-59)
%s Seconds (00-59)
%T Time, 24-hour (hh:mm:ss)
%U Week (00-53) where Sunday is the first day of week
%u Week (00-53) where Monday is the first day of week
%V Week (01-53) where Sunday is the first day of week, used with %X
%v Week (01-53) where Monday is the first day of week, used with %x
%W Weekday name
%w Day of the week (0=Sunday, 6=Saturday)
%X Year of the week where Sunday is the first day of week, four digits, used with %V
%x Year of the week where Monday is the first day of week, four digits, used with %v
%Y Year, four digits
%y Year, two digits
Example
The following script uses the DATE_FORMAT() function to display different formats. We will use the NOW() function to get the current date/time:
DATE_FORMAT(NOW(),'%b %d %Y %h:%i %p')
DATE_FORMAT(NOW(),'%m-%d-%Y')
DATE_FORMAT(NOW(),'%d %b %y')
DATE_FORMAT(NOW(),'%d %b %Y %T:%f')
The result would look something like this:
using Microsoft.VisualBasic;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics;
public class Purchases : IControlEvent
{
public long PurchaseOrderID = 0;
public DataTable dt;
public DataSet ds = new DataSet();
private DataView mView;
Theme _theme;
public event ChangedEventHandler Changed;
public delegate void ChangedEventHandler();
private long EnteredBy;
ComboBox cmbProductCode;
private string pCode;
public DataRowView dv;
public int ProductID = 0;
public List<long> ProductIDs = new List<long>();
DataGridViewComboBoxColumn combocolum = new DataGridViewComboBoxColumn();
DataGridViewComboBoxColumn namecombocolum = new DataGridViewComboBoxColumn();
int PurchaseItemID = 0;
public enum CBO_MODE
{
NORMAL = 0,
EDITABLE = 1,
EDITABLE_WITH_NOTIFYCURRENTCELLDIRTY = 2
}
const bool ALLOW_ADDS = true;
private CBO_MODE MODE = CBO_MODE.EDITABLE_WITH_NOTIFYCURRENTCELLDIRTY;
public bool Notify(object obj)
{
try {
PurchaseOrderID = Convert.ToInt32(obj);
FillDetails(PurchaseOrderID);
FillGrid(PurchaseOrderID);
btnDelete.Enabled = true;
} catch (Exception ex) {
Utils.LogHandler.HandleError(ex);
return false;
}
return true;
}
private void FillDetails(long PurchaseOrderID)
{
POSCLayer.Purchaseorders c = new POSCLayer.Purchaseorders();
c = POSBLayer.Purchaseorders.GetValue(PurchaseOrderID);
if (c != null) {
dtpPurchaseDate.Value = c.PurchaseDate;
txtInvoiceNumber.Text = c.InvoiceNumber;
txtOrderDetail.Text = c.OrderDetail;
txtRemarks.Text = c.Remarks;
txtTotalAmount.Text = c.TotalAmount.ToString();
EnteredBy = c.EnteredBy;
btnDelete.Enabled = true;
}
}
public void FillGrid(long PurchaseOrderID)
{
DataTable dtgrid = POSBLayer.Purchaseitems.GetDataAll(PurchaseOrderID);
int j = 0;
dgvPurchaseItems.Rows.Clear();
if (dtgrid.Rows.Count > 0) {
for (j = 0; j <= dtgrid.Rows.Count - 1; j++) {
dgvPurchaseItems.Rows.Add();
//dgvPurchaseItems("Name", j).Value = dtgrid.Rows(j)("Name").ToString()
dgvPurchaseItems("Quantity", j).Value = dtgrid.Rows[j]["Quantity"].ToString();
dgvPurchaseItems("Damaged", j).Value = dtgrid.Rows[j]["Damaged"].ToString();
dgvPurchaseItems("Expired", j).Value = dtgrid.Rows[j]["Expired"].ToString();
dgvPurchaseItems("PurchaseRate", j).Value = dtgrid.Rows[j]["PurchaseRate"].ToString();
dgvPurchaseItems("SellingRate", j).Value = dtgrid.Rows[j]["SellingRate"].ToString();
dgvPurchaseItems("Current", j).Value = dtgrid.Rows[j]["Current"].ToString();
dgvPurchaseItems("Loose", j).Value = dtgrid.Rows[j]["Loose"].ToString();
dgvPurchaseItems("PurchaseItemID", j).Value = dtgrid.Rows[j]["PurchaseItemID"].ToString();
dgvPurchaseItems("ProductID", j).Value = dtgrid.Rows[j]["ProductID"].ToString();
//Dim combo As DataGridViewComboBoxCell = TryCast(dgvPurchaseItems(0, j), DataGridViewComboBoxCell)
//Dim dt As DataTable = POSBLayer.Products.GetDataAll()
//combo.DataSource = dt
dgvPurchaseItems.Rows(j).Cells(combocolum.Name).Value = dtgrid.Rows[j]["pcode"].ToString();
dgvPurchaseItems.Rows(j).Cells(namecombocolum.Name).Value = dtgrid.Rows[j]["Name"].ToString();
ProductIDs.Add(Convert.ToInt64(dtgrid.Rows[j]["ProductID"].ToString()));
}
} else {
dgvPurchaseItems.Rows.Clear();
}
}
private void btnSave_Click(System.Object sender, System.EventArgs e)
{
try {
if (!string.IsNullOrEmpty(txtInvoiceNumber.Text) & !string.IsNullOrEmpty(txtOrderDetail.Text) & !string.IsNullOrEmpty(txtTotalAmount.Text)) {
POSCLayer.Purchaseorders data = new POSCLayer.Purchaseorders();
data.PurchaseOrderID = PurchaseOrderID;
data.PurchaseDate = dtpPurchaseDate.Value;
data.OrderDetail = txtOrderDetail.Text;
data.Remarks = txtRemarks.Text;
data.InvoiceNumber = txtInvoiceNumber.Text;
data.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
if (PurchaseOrderID == 0) {
data.EnteredBy = Config.User.UserID;
EnteredBy = Config.User.UserID;
} else {
data.EnteredBy = EnteredBy;
}
data.ModifiedBy = Config.User.UserID;
long result = POSBLayer.Purchaseorders.Save(data);
PurchaseOrderID = result;
btnNew.Enabled = true;
btnDelete.Enabled = false;
POSCLayer.Purchaseitems data1 = new POSCLayer.Purchaseitems();
int i = 0;
foreach (DataGridViewRow row in dgvPurchaseItems.Rows) {
if (row.Cells("PurchaseItemID").Value != null & row.Cells("ProductID").Value != null & row.Cells("Quantity").Value != null & row.Cells("Damaged").Value != null & row.Cells("Expired").Value != null & row.Cells("PurchaseRate").Value != null & row.Cells("SellingRate").Value != null & row.Cells("Current").Value != null) {
if (row.Cells("PurchaseItemID").Value != null) {
int.TryParse(row.Cells("PurchaseItemID").Value.ToString(), out PurchaseItemID);
}
if (row.Cells("ProductID").Value != null) {
int.TryParse(row.Cells("ProductID").Value.ToString(), out ProductID);
}
data1.PurchaseOrderID = PurchaseOrderID;
data1.ProductID = ProductID;
DataTable dtItems = POSBLayer.Purchaseitems.Get_PurchaseItems_ProductID(PurchaseOrderID, ProductID);
if (dtItems.Rows.Count > 0) {
if (PurchaseItemID == 0) {
data1.PurchaseItemID = POSBLayer.Purchaseitems.Get_PurchaseItemsID(PurchaseOrderID, ProductID);
data1.Quantity = decimal.Parse(row.Cells("Quantity").Value.ToString()) + decimal.Parse(dtItems.Rows[0]["Quantity"].ToString());
data1.DamagedQuantity = decimal.Parse(row.Cells("Damaged").Value.ToString()) + decimal.Parse(dtItems.Rows[0]["DamagedQuantity"].ToString());
data1.ExpiredQuantity = decimal.Parse(row.Cells("Expired").Value.ToString()) + decimal.Parse(dtItems.Rows[0]["ExpiredQuantity"].ToString());
data1.PurchasePrice = decimal.Parse(row.Cells("PurchaseRate").Value.ToString()) + decimal.Parse(dtItems.Rows[0]["PurchasePrice"].ToString());
data1.SellingPrice = decimal.Parse(row.Cells("SellingRate").Value.ToString()) + decimal.Parse(dtItems.Rows[0]["SellingPrice"].ToString());
data1.CurrentQuantity = decimal.Parse(row.Cells("Current").Value.ToString()) + decimal.Parse(dtItems.Rows[0]["CurrentQuantity"].ToString());
data1.CurrentLooseVolume = 0;
data1.LooseQuantity = 0;
} else {
data1.PurchaseItemID = PurchaseItemID;
data1.Quantity = decimal.Parse(row.Cells("Quantity").Value.ToString());
data1.DamagedQuantity = decimal.Parse(row.Cells("Damaged").Value.ToString());
data1.ExpiredQuantity = decimal.Parse(row.Cells("Expired").Value.ToString());
data1.PurchasePrice = decimal.Parse(row.Cells("PurchaseRate").Value.ToString());
data1.SellingPrice = decimal.Parse(row.Cells("SellingRate").Value.ToString());
data1.CurrentQuantity = decimal.Parse(row.Cells("Current").Value.ToString());
data1.CurrentLooseVolume = 0;
data1.LooseQuantity = 0;
}
} else {
data1.PurchaseItemID = PurchaseItemID;
data1.Quantity = decimal.Parse(row.Cells("Quantity").Value.ToString());
data1.DamagedQuantity = decimal.Parse(row.Cells("Damaged").Value.ToString());
data1.ExpiredQuantity = decimal.Parse(row.Cells("Expired").Value.ToString());
data1.PurchasePrice = decimal.Parse(row.Cells("PurchaseRate").Value.ToString());
data1.SellingPrice = decimal.Parse(row.Cells("SellingRate").Value.ToString());
data1.CurrentQuantity = decimal.Parse(row.Cells("Current").Value.ToString());
data1.CurrentLooseVolume = 0;
data1.LooseQuantity = 0;
}
result = POSBLayer.Purchaseitems.Save(data1);
i = i + 1;
}
}
if (Changed != null) {
Changed();
}
MessageBox.Show("Saved successfully.", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
} else {
MessageBox.Show("Please enter required fields", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
} catch (Exception ex) {
Utils.LogHandler.HandleError(ex);
}
}
private void Clear()
{
PurchaseOrderID = 0;
dtpPurchaseDate.Value = Convert.ToDateTime(DateAndTime.Now.ToString("dd-MM-yyyy"));
txtOrderDetail.Text = "";
txtRemarks.Text = "";
txtInvoiceNumber.Text = "";
txtTotalAmount.Text = "";
btnDelete.Enabled = false;
}
private void btnNew_Click(System.Object sender, System.EventArgs e)
{
try {
Clear();
dgvPurchaseItems.Rows.Clear();
} catch (Exception ex) {
Utils.LogHandler.HandleError(ex);
}
}
private void btnDelete_Click(System.Object sender, System.EventArgs e)
{
try {
int checkPurchaseOrderID = 0;
checkPurchaseOrderID = POSBLayer.Purchaseorders.checkPurchaseOrderID(Convert.ToInt32(PurchaseOrderID));
if (checkPurchaseOrderID == 0) {
DialogResult msgResult = DialogResult.No;
msgResult = MessageBox.Show("Are you sure you want to remove the record ?", Config.MsgTitle, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (msgResult == DialogResult.Yes) {
if (!string.IsNullOrEmpty(txtInvoiceNumber.Text) & !string.IsNullOrEmpty(txtOrderDetail.Text) & !string.IsNullOrEmpty(txtTotalAmount.Text)) {
int result = Convert.ToInt32(POSBLayer.Purchaseorders.Delete(PurchaseOrderID));
Clear();
if (Changed != null) {
Changed();
}
} else {
MessageBox.Show("Please enter required fields", Config.MsgTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
} else {
dtpPurchaseDate.Focus();
}
} else {
MessageBox.Show("Cannot delete, this Purchase Order is already assigned to a Purchase Items.", Config.MsgTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
} catch (Exception ex) {
Utils.LogHandler.HandleError(ex);
}
}
private void Purchases_Load(object sender, System.EventArgs e)
{
try {
DataTable dt = POSBLayer.Products.GetDataAll();
combocolum.DefaultCellStyle.Tag = "editable";
// this is the enhance to control if editable or not
combocolum.HeaderText = "Code";
combocolum.DataPropertyName = "ProductID";
combocolum.DataSource = dt;
combocolum.DisplayMember = "pcode";
combocolum.ValueMember = "ProductID";
combocolum.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing;
combocolum.Name = "Product";
combocolum.ValueType = typeof(System.String);
combocolum.Width = 200;
dgvPurchaseItems.Columns.Add(combocolum);
//Dim Namecolum As New DataGridViewTextBoxColumn
//Namecolum.HeaderText = "Name"
//Namecolum.Name = "Name"
//Namecolum.ValueType = GetType(System.String)
//Namecolum.Width = 170
//Namecolum.ReadOnly = True
//dgvPurchaseItems.Columns.Add(Namecolum)
namecombocolum.DefaultCellStyle.Tag = "editable";
// this is the enhance to control if editable or not
namecombocolum.HeaderText = "Name";
namecombocolum.DataPropertyName = "ProductID";
namecombocolum.DataSource = dt;
namecombocolum.DisplayMember = "NAME";
namecombocolum.ValueMember = "ProductID";
namecombocolum.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing;
namecombocolum.Name = "Name";
namecombocolum.ValueType = typeof(System.String);
namecombocolum.Width = 170;
dgvPurchaseItems.Columns.Add(namecombocolum);
DataGridViewTextBoxColumn Quantitycolum = new DataGridViewTextBoxColumn();
Quantitycolum.HeaderText = "Quantity";
Quantitycolum.Name = "Quantity";
Quantitycolum.ValueType = typeof(System.Decimal);
Quantitycolum.Width = 70;
dgvPurchaseItems.Columns.Add(Quantitycolum);
DataGridViewTextBoxColumn Damagedcolum = new DataGridViewTextBoxColumn();
Damagedcolum.HeaderText = "Damaged";
Damagedcolum.Name = "Damaged";
Damagedcolum.ValueType = typeof(System.Decimal);
Damagedcolum.Width = 70;
dgvPurchaseItems.Columns.Add(Damagedcolum);
DataGridViewTextBoxColumn Expiredcolum = new DataGridViewTextBoxColumn();
Expiredcolum.HeaderText = "Expired";
Expiredcolum.Name = "Expired";
Expiredcolum.ValueType = typeof(System.Decimal);
Expiredcolum.Width = 70;
dgvPurchaseItems.Columns.Add(Expiredcolum);
DataGridViewTextBoxColumn PurchaseRatecolum = new DataGridViewTextBoxColumn();
PurchaseRatecolum.HeaderText = "Purchase Rate";
PurchaseRatecolum.Name = "PurchaseRate";
PurchaseRatecolum.ValueType = typeof(System.Decimal);
PurchaseRatecolum.Width = 110;
dgvPurchaseItems.Columns.Add(PurchaseRatecolum);
DataGridViewTextBoxColumn SellingRatecolum = new DataGridViewTextBoxColumn();
SellingRatecolum.HeaderText = "Selling Rate";
SellingRatecolum.Name = "SellingRate";
SellingRatecolum.ValueType = typeof(System.Decimal);
SellingRatecolum.Width = 100;
dgvPurchaseItems.Columns.Add(SellingRatecolum);
DataGridViewTextBoxColumn Currentcolum = new DataGridViewTextBoxColumn();
Currentcolum.HeaderText = "Current";
Currentcolum.Name = "Current";
Currentcolum.ValueType = typeof(System.Decimal);
Currentcolum.ReadOnly = true;
Currentcolum.Width = 70;
dgvPurchaseItems.Columns.Add(Currentcolum);
DataGridViewTextBoxColumn Loosecolum = new DataGridViewTextBoxColumn();
Loosecolum.HeaderText = "Loose";
Loosecolum.Name = "Loose";
Loosecolum.ValueType = typeof(System.Decimal);
Loosecolum.ReadOnly = true;
Loosecolum.Width = 70;
dgvPurchaseItems.Columns.Add(Loosecolum);
DataGridViewTextBoxColumn PurchaseItemIDcolum = new DataGridViewTextBoxColumn();
PurchaseItemIDcolum.HeaderText = "PurchaseItemID";
PurchaseItemIDcolum.Name = "PurchaseItemID";
PurchaseItemIDcolum.ValueType = typeof(System.Decimal);
PurchaseItemIDcolum.Width = 70;
dgvPurchaseItems.Columns.Add(PurchaseItemIDcolum);
DataGridViewTextBoxColumn ProductIDcolum = new DataGridViewTextBoxColumn();
ProductIDcolum.HeaderText = "ProductID";
ProductIDcolum.Name = "ProductID";
ProductIDcolum.ValueType = typeof(System.Decimal);
ProductIDcolum.Width = 70;
dgvPurchaseItems.Columns.Add(ProductIDcolum);
DataGridViewLinkColumn Deletecolum = new DataGridViewLinkColumn();
Deletecolum.HeaderText = "Delete";
Deletecolum.Name = "Delete";
Deletecolum.Width = 70;
Deletecolum.Text = "Delete";
Deletecolum.UseColumnTextForLinkValue = true;
dgvPurchaseItems.Columns.Add(Deletecolum);
//Dim Savecolum As New DataGridViewLinkColumn
//Savecolum.HeaderText = "Save"
//Savecolum.Name = "Save"
//Savecolum.Width = 70
//Savecolum.Text = "Save"
//Savecolum.UseColumnTextForLinkValue = True
//dgvPurchaseItems.Columns.Add(Savecolum)
dgvPurchaseItems.RowHeadersVisible = false;
dgvPurchaseItems.BackgroundColor = Color.White;
dgvPurchaseItems.Columns("PurchaseItemID").Visible = false;
dgvPurchaseItems.Columns("ProductID").Visible = false;
//Theme.SetGridViewStyle(dgvPurchaseItems)
Theme.SetControlTheme(this);
} catch (Exception ex) {
Utils.LogHandler.HandleError(ex);
}
}
private void dgvPurchaseItems_EditingControlShowing(System.Object sender, System.Windows.Forms.DataGridViewEditingControlShowingEventArgs e)
{
try {
// Here you control if combobox will be editable or not
if (object.ReferenceEquals(e.CellStyle.Tag, "editable")) {
DataGridView dgvPurchaseItems = (DataGridView)sender;
if (((e.Control) is ComboBox)) {
ComboBox cb = (ComboBox)e.Control;
if (((cb != null))) {
cb.DropDownStyle = ComboBoxStyle.DropDown;
cb.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cb.AutoCompleteSource = AutoCompleteSource.ListItems;
cb.SelectionChangeCommitted += cmbProductCodeOnSelectionChangeCommitted;
cb.LostFocus += cmbProductCode_LostFocus;
cb.Leave += cmbProductCode_Leave;
if ((MODE == CBO_MODE.EDITABLE_WITH_NOTIFYCURRENTCELLDIRTY)) {
// Added thanks to Ying Liu, Microsoft Support
dgvPurchaseItems.NotifyCurrentCellDirty(true);
}
}
}
}
} catch (Exception ex) {
Utils.LogHandler.HandleError(ex);
}
}
private void cmbProductCodeOnSelectionChangeCommitted(object sender, EventArgs e)
{
DataGridViewComboBoxEditingControl comboBox = sender as DataGridViewComboBoxEditingControl;
if (sender == null) {
return;
}
if (comboBox.SelectedItem == null) {
return;
}
if (object.ReferenceEquals(this.dgvPurchaseItems.CurrentCell.Value, comboBox.SelectedItem)) {
return;
}
this.dgvPurchaseItems.CurrentCell.Value = comboBox.SelectedItem;
dv = (DataRowView)comboBox.SelectedItem;
pCode = Convert.ToString(dv["pcode"]);
ProductIDs.Add(Convert.ToInt64(dv["ProductID"]));
ProductID = Convert.ToInt32(dv["ProductID"]);
}
private void cmbProductCode_LostFocus(object sender, EventArgs e)
{
DataGridViewComboBoxEditingControl comboBox = sender as DataGridViewComboBoxEditingControl;
if (sender == null) {
return;
}
if (comboBox.SelectedItem == null) {
return;
}
if (object.ReferenceEquals(this.dgvPurchaseItems.CurrentCell.Value, comboBox.SelectedItem)) {
return;
}
this.dgvPurchaseItems.CurrentCell.Value = comboBox.SelectedItem;
dv = (DataRowView)comboBox.SelectedItem;
pCode = Convert.ToString(dv["pcode"]);
ProductIDs.Add(Convert.ToInt64(dv["ProductID"]));
ProductID = Convert.ToInt32(dv["ProductID"]);
}
private void cmbProductCode_Leave(object sender, EventArgs e)
{
DataGridViewComboBoxEditingControl comboBox = sender as DataGridViewComboBoxEditingControl;
if (sender == null) {
return;
}
if (comboBox.SelectedItem == null) {
return;
}
if (object.ReferenceEquals(this.dgvPurchaseItems.CurrentCell.Value, comboBox.SelectedItem)) {
return;
}
this.dgvPurchaseItems.CurrentCell.Value = comboBox.SelectedItem;
dv = (DataRowView)comboBox.SelectedItem;
pCode = Convert.ToString(dv["pcode"]);
ProductIDs.Add(Convert.ToInt64(dv["ProductID"]));
ProductID = Convert.ToInt32(dv["ProductID"]);
}
private void dgvPurchaseItems_CellEndEdit(System.Object sender, System.Windows.Forms.DataGridViewCellEventArgs e)
{
try {
int j = e.RowIndex;
decimal q = default(decimal);
decimal d = default(decimal);
decimal r = default(decimal);
decimal c = default(decimal);
decimal.TryParse(Convert.ToString(dgvPurchaseItems.Rows(j).Cells("Quantity").Value), out q);
decimal.TryParse(Convert.ToString(dgvPurchaseItems.Rows(j).Cells("Damaged").Value), out d);
decimal.TryParse(Convert.ToString(dgvPurchaseItems.Rows(j).Cells("Expired").Value), out r);
if (q < d + r) {
MessageBox.Show("Enter Quantity greater than Damaged and Expired.", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
} else {
c = q - (d + r);
}
dgvPurchaseItems.Rows(j).Cells("Current").Value = c.ToString();
dgvPurchaseItems.Rows(j).Cells("Loose").Value = 0;
if (ProductID != 0) {
dgvPurchaseItems.Rows(j).Cells("ProductID").Value = ProductID;
dgvPurchaseItems.Rows(j).Cells("Name").Value = POSBLayer.Purchaseitems.GetProductName(ProductID);
dgvPurchaseItems.Rows(j).Cells("Product").Value = POSBLayer.Purchaseitems.GetProductCode(ProductID);
} else {
Name = Convert.ToString(dgvPurchaseItems.Rows(j).Cells("Name").Value);
pCode = Convert.ToString(dgvPurchaseItems.Rows(j).Cells("Product").Value);
dgvPurchaseItems.Rows(j).Cells("Name").Value = Name;
dgvPurchaseItems.Rows(j).Cells("Product").Value = pCode;
}
if (dgvPurchaseItems.Rows(j).Cells("PurchaseItemID").Value == null) {
dgvPurchaseItems.Rows(j).Cells("PurchaseItemID").Value = PurchaseItemID;
}
//Dim data1 As New POSCLayer.Purchaseitems
//data1.PurchaseItemID = CLng(dgvPurchaseItems.Rows(j).Cells(8).Value.ToString())
//data1.PurchaseOrderID = PurchaseOrderID
//data1.ProductID = CLng(dgvPurchaseItems.Rows(j).Cells(9).Value.ToString())
//data1.Quantity = Decimal.Parse(dgvPurchaseItems.Rows(j).Cells("Quantity").Value.ToString())
//data1.DamagedQuantity = Decimal.Parse(dgvPurchaseItems.Rows(j).Cells("Damaged").Value.ToString())
//data1.ExpiredQuantity = Decimal.Parse(dgvPurchaseItems.Rows(j).Cells("Expired").Value.ToString())
//data1.PurchasePrice = Decimal.Parse(dgvPurchaseItems.Rows(j).Cells("PurchaseRate").Value.ToString())
//data1.SellingPrice = Decimal.Parse(dgvPurchaseItems.Rows(j).Cells("SellingRate").Value.ToString())
//data1.CurrentQuantity = Decimal.Parse(dgvPurchaseItems.Rows(j).Cells("Current").Value.ToString())
//data1.CurrentLooseVolume = 0
//data1.LooseQuantity = Decimal.Parse(dgvPurchaseItems.Rows(j).Cells("Loose").Value.ToString())
//Dim result = POSBLayer.Purchaseitems.Save(data1)
//MessageBox.Show("Saved successfully.",
// "POS",
// MessageBoxButtons.OK,
// MessageBoxIcon.Information)
//FillGrid(PurchaseOrderID)
} catch (Exception ex) {
Utils.LogHandler.HandleError(ex);
}
}
private void dgvPurchaseItems_CellLeave(System.Object sender, System.Windows.Forms.DataGridViewCellEventArgs e)
{
try {
//If Not cmbProductCode Is Nothing Then
// pCode = cmbProductCode.Text
// Dim dt As DataTable = POSBLayer.Products.GetDataAll()
// cmbProductCode.DataSource = dt
// cmbProductCode.DisplayMember = "Code"
// cmbProductCode.ValueMember = "ProductID"
// cmbProductCode.SelectedIndex = cmbProductCode.FindStringExact(pCode)
// cmbProductCode.Text = pCode
// cmbProductCode.DroppedDown = False
//End If
} catch (Exception ex) {
Utils.LogHandler.HandleError(ex);
}
}
private void dgvPurchaseItems_CellValidating(System.Object sender, System.Windows.Forms.DataGridViewCellValidatingEventArgs e)
{
try {
DataGridView dgvPurchaseItems = (DataGridView)sender;
if ((dgvPurchaseItems.Columns(e.ColumnIndex) is DataGridViewComboBoxColumn)) {
DataGridViewComboBoxColumn comboBoxColumn = (DataGridViewComboBoxColumn)dgvPurchaseItems.Columns(e.ColumnIndex);
if ((!comboBoxColumn.Items.Contains(e.FormattedValue))) {
if ((ALLOW_ADDS)) {
//Beep() ' Audio confirmation that the item has been added (optional)
//comboBoxColumn.Items.Add(e.FormattedValue)
} else {
// How do we cancel?
e.Cancel = true;
}
}
} else {
}
} catch (Exception ex) {
Utils.LogHandler.HandleError(ex);
}
}
private void dgvPurchaseItems_DataError(System.Object sender, System.Windows.Forms.DataGridViewDataErrorEventArgs e)
{
try {
if (e.Exception != null) {
// checking Integer numbers
if (dgvPurchaseItems.Columns(e.ColumnIndex).ValueType.ToString() == "System.Int32") {
MessageBox.Show("Enter only Integer values ");
// checking decimal values
} else if (dgvPurchaseItems.Columns(e.ColumnIndex).ValueType.ToString() == "System.Decimal") {
MessageBox.Show("Enter only numbers");
} else if (dgvPurchaseItems.Columns(e.ColumnIndex).ValueType.ToString() == "System.String") {
//MessageBox.Show("Enter only numbers")
} else {
MessageBox.Show("Enter correct format data. Different format data will not accept");
}
}
} catch (Exception ex) {
Utils.LogHandler.HandleError(ex);
}
}
private void dgvPurchaseItems_CellContentClick(System.Object sender, System.Windows.Forms.DataGridViewCellEventArgs e)
{
try {
if (e.ColumnIndex == 11) {
int j = e.RowIndex;
POSCLayer.Purchaseitems data1 = new POSCLayer.Purchaseitems();
data1.PurchaseItemID = Convert.ToInt64(dgvPurchaseItems.Rows(j).Cells("PurchaseItemID").Value.ToString());
dynamic pid = POSBLayer.Purchaseitems.GetPurchaseItemID(data1.PurchaseItemID);
if (pid > 0) {
MessageBox.Show("Cannot delete.", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
} else {
dynamic result = POSBLayer.Purchaseitems.Delete(data1.PurchaseItemID);
MessageBox.Show("Deleted successfully.", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
FillGrid(PurchaseOrderID);
}
} else {
//If e.ColumnIndex = 11 Then
// If PurchaseOrderID <> 0 Then
// Dim j As Integer = e.RowIndex
// Dim data1 As New POSCLayer.Purchaseitems
// data1.PurchaseItemID = CLng(dgvPurchaseItems.Rows(j).Cells(8).Value.ToString())
// data1.PurchaseOrderID = PurchaseOrderID
// data1.ProductID = CLng(dgvPurchaseItems.Rows(j).Cells(9).Value.ToString())
// data1.Quantity = Decimal.Parse(dgvPurchaseItems.Rows(j).Cells("Quantity").Value.ToString())
// data1.DamagedQuantity = Decimal.Parse(dgvPurchaseItems.Rows(j).Cells("Damaged").Value.ToString())
// data1.ExpiredQuantity = Decimal.Parse(dgvPurchaseItems.Rows(j).Cells("Expired").Value.ToString())
// data1.PurchasePrice = Decimal.Parse(dgvPurchaseItems.Rows(j).Cells("PurchaseRate").Value.ToString())
// data1.SellingPrice = Decimal.Parse(dgvPurchaseItems.Rows(j).Cells("SellingRate").Value.ToString())
// data1.CurrentQuantity = Decimal.Parse(dgvPurchaseItems.Rows(j).Cells("Current").Value.ToString())
// data1.CurrentLooseVolume = 0
// data1.LooseQuantity = Decimal.Parse(dgvPurchaseItems.Rows(j).Cells("Loose").Value.ToString())
// Dim result = POSBLayer.Purchaseitems.Save(data1)
// MessageBox.Show("Saved successfully.",
// "POS",
// MessageBoxButtons.OK,
// MessageBoxIcon.Information)
// FillGrid(PurchaseOrderID)
// End If
}
} catch (Exception ex) {
Utils.LogHandler.HandleError(ex);
}
}
public Purchases()
{
Load += Purchases_Load;
}
}
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm2.aspx.cs" Inherits="AccordionMenu.WebForm2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script type="text/javascript" src="Scripts/jquery-1.7.1.min.js"></script>
<STYLE>
body, input{
font-family: Calibri, Arial;
}
#accordion {
list-style: none;
padding: 0 0 0 0;
width: 170px;
}
#accordion li{
display: block;
background-color: #FF9927;
font-weight: bold;
margin: 1px;
cursor: pointer;
padding: 5 5 5 7px;
list-style: circle;
-moz-border-radius: 10px;
-webkit-border-radius: 10px;
border-radius: 10px;
}
#accordion ul {
list-style: none;
padding: 0 0 0 0;
display: none;
}
#accordion ul li{
font-weight: normal;
cursor: auto;
background-color: #fff;
padding: 0 0 0 7px;
}
#accordion a {
text-decoration: none;
}
#accordion a:hover {
text-decoration: underline;
}
</STYLE>
</head>
<body>
<form id="form1" runat="server">
<div>
<ul id="accordion">
<li>
<asp:LinkButton ID="lnkNational" runat="server">National Members</asp:LinkButton>
</li>
<ul>
<asp:Panel ID="pnlCountries" runat="server"></asp:Panel>
</ul>
<li>
<asp:LinkButton ID="lnkState" runat="server">State Members</asp:LinkButton>
</li>
<ul>
<asp:Panel ID="pnlStates" runat="server"></asp:Panel>
</ul>
<li>
<asp:LinkButton ID="lnkDistrict" runat="server">District Members</asp:LinkButton>
</li>
<ul>
<asp:Panel ID="pnlDistricts" runat="server"></asp:Panel>
</ul>
</ul>
</div>
<input type="hidden" id="hdnShow" value="0"/>
</form>
</body>
<SCRIPT>
$("#accordion > li").click(function () {
if (false == $(this).next().is(':visible')) {
$('#accordion > ul').slideUp(300);
}
$(this).next().slideToggle(300);
});
$(document).ready(function () {
$('#accordion > ul:eq(0)').show();
});
</SCRIPT>
</html>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace AccordionMenu
{
public partial class WebForm2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
LinkButton lic1 = new LinkButton();
lic1.Text = "India";
LinkButton lic2 = new LinkButton();
lic2.Text = "China";
Table tbc = new Table();
TableRow trc1 = new TableRow();
TableRow trc2 = new TableRow();
TableCell tcc1 = new TableCell();
TableCell tcc2 = new TableCell();
tcc1.Controls.Add(lic1);
tcc2.Controls.Add(lic2);
trc1.Cells.Add(tcc1);
trc2.Cells.Add(tcc2);
tbc.Rows.Add(trc1);
tbc.Rows.Add(trc2);
pnlCountries.Controls.Add(tbc);
LinkButton lis1 = new LinkButton();
lis1.Text = "Kerala";
LinkButton lis2 = new LinkButton();
lis2.Text = "Tamilnadu";
Table tbs = new Table();
TableRow trs1 = new TableRow();
TableRow trs2 = new TableRow();
TableCell tcs1 = new TableCell();
TableCell tcs2 = new TableCell();
tcs1.Controls.Add(lis1);
tcs2.Controls.Add(lis2);
trs1.Cells.Add(tcs1);
trs2.Cells.Add(tcs2);
tbs.Rows.Add(trs1);
tbs.Rows.Add(trs2);
pnlStates.Controls.Add(tbs);
LinkButton lid1 = new LinkButton();
lid1.Text = "Ernakulam";
LinkButton lid2 = new LinkButton();
lid2.Text = "Trissur";
Table tbd = new Table();
TableRow trd1 = new TableRow();
TableRow trd2 = new TableRow();
TableCell tcd1 = new TableCell();
TableCell tcd2 = new TableCell();
tcd1.Controls.Add(lid1);
tcd2.Controls.Add(lid2);
trd1.Cells.Add(tcd1);
trd2.Cells.Add(tcd2);
tbd.Rows.Add(trd1);
tbd.Rows.Add(trd2);
pnlDistricts.Controls.Add(tbd);
}
}
}
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script type="text/javascript" src="Scripts/jquery-1.7.1.min.js"></script>
<STYLE>
body, input{
font-family: Calibri, Arial;
}
#accordion {
list-style: none;
padding: 0 0 0 0;
width: 170px;
}
#accordion li{
display: block;
background-color: #FF9927;
font-weight: bold;
margin: 1px;
cursor: pointer;
padding: 5 5 5 7px;
list-style: circle;
-moz-border-radius: 10px;
-webkit-border-radius: 10px;
border-radius: 10px;
}
#accordion ul {
list-style: none;
padding: 0 0 0 0;
display: none;
}
#accordion ul li{
font-weight: normal;
cursor: auto;
background-color: #fff;
padding: 0 0 0 7px;
}
#accordion a {
text-decoration: none;
}
#accordion a:hover {
text-decoration: underline;
}
</STYLE>
</head>
<body>
<form id="form1" runat="server">
<div>
<ul id="accordion">
<li>
<asp:LinkButton ID="lnkNational" runat="server">National Members</asp:LinkButton>
</li>
<ul>
<asp:Panel ID="pnlCountries" runat="server"></asp:Panel>
</ul>
<li>
<asp:LinkButton ID="lnkState" runat="server">State Members</asp:LinkButton>
</li>
<ul>
<asp:Panel ID="pnlStates" runat="server"></asp:Panel>
</ul>
<li>
<asp:LinkButton ID="lnkDistrict" runat="server">District Members</asp:LinkButton>
</li>
<ul>
<asp:Panel ID="pnlDistricts" runat="server"></asp:Panel>
</ul>
</ul>
</div>
<input type="hidden" id="hdnShow" value="0"/>
</form>
</body>
<SCRIPT>
$("#accordion > li").click(function () {
if (false == $(this).next().is(':visible')) {
$('#accordion > ul').slideUp(300);
}
$(this).next().slideToggle(300);
});
$(document).ready(function () {
$('#accordion > ul:eq(0)').show();
});
</SCRIPT>
</html>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace AccordionMenu
{
public partial class WebForm2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
LinkButton lic1 = new LinkButton();
lic1.Text = "India";
LinkButton lic2 = new LinkButton();
lic2.Text = "China";
Table tbc = new Table();
TableRow trc1 = new TableRow();
TableRow trc2 = new TableRow();
TableCell tcc1 = new TableCell();
TableCell tcc2 = new TableCell();
tcc1.Controls.Add(lic1);
tcc2.Controls.Add(lic2);
trc1.Cells.Add(tcc1);
trc2.Cells.Add(tcc2);
tbc.Rows.Add(trc1);
tbc.Rows.Add(trc2);
pnlCountries.Controls.Add(tbc);
LinkButton lis1 = new LinkButton();
lis1.Text = "Kerala";
LinkButton lis2 = new LinkButton();
lis2.Text = "Tamilnadu";
Table tbs = new Table();
TableRow trs1 = new TableRow();
TableRow trs2 = new TableRow();
TableCell tcs1 = new TableCell();
TableCell tcs2 = new TableCell();
tcs1.Controls.Add(lis1);
tcs2.Controls.Add(lis2);
trs1.Cells.Add(tcs1);
trs2.Cells.Add(tcs2);
tbs.Rows.Add(trs1);
tbs.Rows.Add(trs2);
pnlStates.Controls.Add(tbs);
LinkButton lid1 = new LinkButton();
lid1.Text = "Ernakulam";
LinkButton lid2 = new LinkButton();
lid2.Text = "Trissur";
Table tbd = new Table();
TableRow trd1 = new TableRow();
TableRow trd2 = new TableRow();
TableCell tcd1 = new TableCell();
TableCell tcd2 = new TableCell();
tcd1.Controls.Add(lid1);
tcd2.Controls.Add(lid2);
trd1.Cells.Add(tcd1);
trd2.Cells.Add(tcd2);
tbd.Rows.Add(trd1);
tbd.Rows.Add(trd2);
pnlDistricts.Controls.Add(tbd);
}
}
}
