private void grdCompetitor_AfterColUpdate(object sender, ColEventArgs e) { switch (grdCompetitor.Col) { case 0: grdCompetitor.Col = 1; grdCompetitor.Focus(); break; case 1: grdCompetitor.Col = 2; grdCompetitor.Focus(); break; case 2: grdCompetitor.Row = grdCompetitor.Row + 1; ; grdCompetitor.Col = 0; grdCompetitor.Focus(); break; } }
private void grdInvoiceAdjustments_AfterColUpdate(object sender, ColEventArgs e) { DataTable dt = new DataTable(); switch (grdInvoiceAdjustments.Col) { case 0: { if (grdInvoiceAdjustments.Columns[0].Value.ToString() != "") { if (!grdInvoiceAdjustments.Columns[0].Value.ToString().Contains("-")) grdInvoiceAdjustments.Columns[0].Value = string.Format("{0:000000}", Convert.ToInt32(grdInvoiceAdjustments.Columns[0].Text.Trim())) + "-" + GlobalVar.g_WorkDate.Remove(0, 8); //if (txtDSSID.Text != "") //{ dt = obj_bllChequeWithoutSummary.VerifyInvoice(grdInvoiceAdjustments.Columns[0].Text, txtDSSID.Text, "VerifyInv"); if (dt.Rows.Count > 0) { grdInvoiceAdjustments.Columns["Inv. Date"].Value = dt.Rows[0]["Inv. Date"].ToString(); grdInvoiceAdjustments.Columns["Cust. ID"].Value = dt.Rows[0]["Cust. ID"].ToString(); grdInvoiceAdjustments.Columns["Customer"].Value = dt.Rows[0]["Customer"].ToString(); grdInvoiceAdjustments.Columns["Area"].Value = dt.Rows[0]["Area"].ToString(); grdInvoiceAdjustments.Columns["Balance"].Value = dt.Rows[0]["Balance"].ToString(); grdInvoiceAdjustments.Columns["InvoiceBal"].Value = dt.Rows[0]["NetAmount"].ToString(); if(dt.Rows[0]["DSSid"].ToString() != "") { txtDSSID.Text = dt.Rows[0]["DSSid"].ToString(); } //.Columns("Chq. Value").Text = Format(mc_DAL_Cheque.InvDetails.Item("Balance"), "0.00") //UpdateGridFooter(); grdInvoiceAdjustments.Col = 6; grdInvoiceAdjustments.Focus(); } else { grdInvoiceAdjustments.Columns["Inv. Id"].Text = ""; grdInvoiceAdjustments.Columns["Inv. Date"].Text = ""; grdInvoiceAdjustments.Columns["Cust. Id"].Text = ""; grdInvoiceAdjustments.Columns["Customer"].Text = ""; grdInvoiceAdjustments.Columns["Area"].Text = ""; grdInvoiceAdjustments.Columns["Balance"].Text = ""; grdInvoiceAdjustments.Columns["InvoiceBal"].Text = ""; grdInvoiceAdjustments.Columns["Chq. Value"].Text = ""; grdInvoiceAdjustments.Col = 0; grdInvoiceAdjustments.Focus(); } //} //if (txtDSSID.Text == "") //{ // txtDSSID.Text = obj_bllChequeWithoutSummary.Verify(grdInvoiceAdjustments.Columns["Inv. Date"].Text, "VerifyInvDss"); // if (txtDSSID.Text == "") // { // GlobalVar.MB("DSS for the selected invoice is closed.", MessageBoxIcon.Warning); // } //} if (CheckDuplicateInvoice(grdInvoiceAdjustments.Columns[0].Text, grdInvoiceAdjustments.Row) && grdInvoiceAdjustments.Columns["Inv. Id"].Text != "") { GlobalVar.MB("Duplicate Invoice ID found", MessageBoxIcon.Warning); grdInvoiceAdjustments.Columns[0].Text = ""; grdInvoiceAdjustments.Col = 0; grdInvoiceAdjustments.Focus(); break; } } break; } case 1: { break; } case 3: { break; } case 5: { break; } case 10: { break; } case 11: { break; } } }
private void grdAttachment_ButtonClick(object sender, ColEventArgs e) { if (e.ColIndex == 0) { OpenFileDialog Objfd = new OpenFileDialog(); Objfd.Filter = "Images only. |*.txt; *.pdf; *.doc; "; DialogResult dr = Objfd.ShowDialog(); if (Objfd.FileName != "") { grdAttachment.Columns["Path"].Value = Objfd.FileName; grdAttachment.Col = 1; grdAttachment.Focus(); } } else if (e.ColIndex == 3) { FolderBrowserDialog Objfd = new FolderBrowserDialog(); DialogResult result = Objfd.ShowDialog(); if (result == DialogResult.OK) { string path = grdAttachment.Columns["Path"].Text; if (path != "") { bllProducts objbllProducts = new bllProducts(); objbllSalesOppertunity.DownLoadFile(path, Objfd.SelectedPath, grdAttachment.Columns["File Name"].Text, ".txt"); } } } }
private void grdPresevasionStandard_AfterColUpdate(object sender, ColEventArgs e) { switch (grdPresevasionStandard.Col) { case 1: grdPresevasionStandard.Row = grdPresevasionStandard.Row + 1; grdPresevasionStandard.Col = 0; grdPresevasionStandard.Focus(); break; } }
private void grdOrderDetails_AfterColUpdate(object sender, ColEventArgs e) { switch (grdOrderDetails.Col) { case 0: { if (grdOrderDetails.Columns[0].Value.ToString() == "True") { grdOrderDetails.Columns[0].Value = "True"; } else { grdOrderDetails.Columns[0].Value = "False"; } grdOrderDetails.Columns["Batch No"].Value = ""; grdOrderDetails.Columns["Qty"].Value = ""; grdOrderDetails.Columns["Mfg. Date"].Value = ""; grdOrderDetails.Columns["Exp. Date"].Value = ""; grdOrderDetails.Columns["Intimation"].Value = ""; if (grdOrderDetails.Columns["Product ID"].Text != "" && grdOrderDetails.Columns["Customer ID"].Text != "") { grdOrderDetails.Col = 7; grdOrderDetails.Focus(); } break; } case 1: { if (grdOrderDetails.Columns["Product ID"].Text.Trim() != "" && grdOrderDetails.Columns["Product ID"].Text.Length <= 6) { grdOrderDetails.Columns["Batch No"].Text = ""; grdOrderDetails.Columns["Product ID"].Value = string.Format("{0:000-000}", Convert.ToInt32(grdOrderDetails.Columns[1].Text.Trim())); grdOrderDetails.Columns["Product Name"].Value = ReturnName(grdOrderDetails.Columns["Product ID"].Value.ToString().Replace("-", ""), "ProName", 1); } if (grdOrderDetails.Columns["Product ID"].Text.Trim() == "") { DeleteSelectedRow(grdOrderDetails); dsIntimations.Tables[1].AcceptChanges(); } if (grdOrderDetails.Columns["Product ID"].Text.Replace("-", "").Length > 6) { DeleteSelectedRow(grdOrderDetails); dsIntimations.Tables[1].AcceptChanges(); } break; } case 3: { if (grdOrderDetails.Columns["Customer ID"].Text.Trim() != "") { grdOrderDetails.Columns["Customer ID"].Value = string.Format("{0:00000}", Convert.ToInt32(grdOrderDetails.Columns["Customer ID"].Text.Trim())); grdOrderDetails.Columns["Customer Name"].Value = ReturnName(grdOrderDetails.Columns["Customer ID"].Value.ToString(), "CusName", 3); } break; } case 5: { if (grdOrderDetails.Columns["Territory ID"].Text.Trim() != "") { grdOrderDetails.Columns["Territory ID"].Value = string.Format("{0:0000}", Convert.ToInt32(grdOrderDetails.Columns["Territory ID"].Text.Trim())); grdOrderDetails.Columns["Territory Name"].Value = ReturnName(grdOrderDetails.Columns["Territory ID"].Value.ToString(), "TerName", 5); } break; } case 10: { if (grdOrderDetails.Columns[10].Text.Trim() != "") { grdOrderDetails.Col = 11; grdOrderDetails.Focus(); } break; } case 11: { if (grdOrderDetails.Columns[11].Text.Trim() != "") { if (Convert.ToDouble(grdOrderDetails.Columns["Intimation"].Text) > Convert.ToDouble(grdOrderDetails.Columns["Qty"].Text)) { GlobalVar.MB("Intimation cannot be greater than quantity.", MessageBoxIcon.Warning); grdOrderDetails.Columns["Intimation"].Text = ""; grdOrderDetails.Col = 11; grdOrderDetails.Focus(); } else { grdOrderDetails.Col = 0; grdOrderDetails.Row = grdOrderDetails.Row + 1; grdOrderDetails.Focus(); } } break; } } }
private void grdProductWise_AfterColUpdate(object sender, ColEventArgs e) { DateTime datetime; DateTime datetime1; switch (grdProductWise.Col) { case 3: { if (grdProductWise.Columns["Type"].Text == "Stock" || grdProductWise.Columns["Type"].Text == "Bonus" || grdProductWise.Columns["Type"].Text == "NearExpiry" || grdProductWise.Columns["Type"].Text == "Expire" || grdProductWise.Columns["Type"].Text == "NonSaleabl" || grdProductWise.Columns["Type"].Text == "Breakage") { grdProductWise.Col = 4; grdProductWise.Focus(); } break; } case 4: { if (!string.IsNullOrEmpty(grdProductWise.Columns["Type"].Text)) { grdProductWise.Columns["TP"].Text = dtProductWiseCorrection.Rows[0]["TP"].ToString(); grdProductWise.Columns["Old Qty"].Text = "0.00"; grdProductWise.Columns["Cost Rate"].Text = "0.00"; grdProductWise.Columns["Qty To"].Text = "0"; grdProductWise.Columns["Qty From"].Text = "0"; grdProductWise.Columns["Balance Qty"].Text = "0"; grdProductWise.Columns["Block Qty"].Text = "0"; grdProductWise.Columns["S.Tax Value"].Text = "0"; grdProductWise.Columns["Old Block"].Text = "0"; grdProductWise.Col = 5; grdProductWise.Focus(); } break; } case 5: { if (grdProductWise.Columns["Mfg. Date"].Text != "") { DateTime.TryParse(grdProductWise.Columns["Mfg. Date"].Text, out datetime); if (datetime.ToString() == "01/01/0001 12:00:00 AM") { grdProductWise.Columns["Mfg. Date"].Text = ""; grdProductWise.Col = 5; grdProductWise.Focus(); } else { if (grdProductWise.Columns["Exp. Date"].Text != "") { DateTime.TryParse(grdProductWise.Columns["Exp. Date"].Text, out datetime1); grdProductWise.Columns["Exp. Date"].Value = datetime1.Date.ToString("dd/MM/yyyy"); if (Convert.ToDateTime(grdProductWise.Columns["Exp. Date"].Text) <= Convert.ToDateTime(grdProductWise.Columns["Mfg. Date"].Text)) { grdProductWise.Columns["Exp. Date"].Value = datetime.Date.ToString("dd/MM/yyyy"); GlobalVar.MB("Expiry date cannot be less than or equal to Manafacture date.", MessageBoxIcon.Warning); grdProductWise.Columns["Mfg. Date"].Text = ""; grdProductWise.Col = 5; grdProductWise.Focus(); } else { grdProductWise.Columns["Mfg. Date"].Value = datetime.Date.ToString("dd/MM/yyyy"); grdProductWise.Col = 6; grdProductWise.Focus(); } } else { grdProductWise.Columns["Mfg. Date"].Value = datetime.Date.ToString("dd/MM/yyyy"); grdProductWise.Col = 6; grdProductWise.Focus(); } } } break; } case 6: { if (grdProductWise.Columns["Exp. Date"].Text != "") { DateTime.TryParse(grdProductWise.Columns["Exp. Date"].Text, out datetime); DateTime.TryParse(grdProductWise.Columns["Mfg. Date"].Text, out datetime1); if (datetime.ToString() == "01/01/0001 12:00:00 AM") { grdProductWise.Columns["Exp. Date"].Text = ""; grdProductWise.Col = 6; grdProductWise.Focus(); } else { grdProductWise.Columns["Exp. Date"].Value = datetime.Date.ToString("dd/MM/yyyy"); grdProductWise.Columns["Mfg. Date"].Value = datetime1.Date.ToString("dd/MM/yyyy"); if (Convert.ToDateTime(grdProductWise.Columns["Exp. Date"].Text) <= Convert.ToDateTime(grdProductWise.Columns["Mfg. Date"].Text)) { grdProductWise.Columns["Exp. Date"].Value = datetime.Date.ToString("dd/MM/yyyy"); GlobalVar.MB("Expiry date cannot be less than or equal to Manafacture date.", MessageBoxIcon.Warning); grdProductWise.Columns["Exp. Date"].Text = ""; grdProductWise.Col = 6; grdProductWise.Focus(); } else { grdProductWise.Col = 8; grdProductWise.Focus(); } } } break; } case 7: { //CalculationsFooter(); grdProductWise.Col = 4; grdProductWise.Focus(); break; } case 8: { //CalculationsFooter(); grdProductWise.Col = 9; grdProductWise.Focus(); break; } case 9: { if (grdProductWise.Columns["Balance Qty"].Text != "") { CalculationsFooter(grdProductWise); grdProductWise.Col = 10; grdProductWise.Focus(); } else { grdProductWise.Columns["Balance Qty"].Text = "0.00"; CalculationsFooter(grdProductWise); grdProductWise.Col = 10; grdProductWise.Focus(); } break; } case 10: { if (grdProductWise.Columns["Block Qty"].Text != "" && grdProductWise.Columns["Balance Qty"].Text != "0.00") { if (Convert.ToDouble(grdProductWise.Columns["Block Qty"].Text) > Convert.ToDouble(grdProductWise.Columns["Balance Qty"].Text)) { GlobalVar.MB("Block quantity cannot be greater than balance quantity", MessageBoxIcon.Warning); grdProductWise.Columns["Block Qty"].Text = ""; grdProductWise.Col = 10; grdProductWise.Focus(); } } else { grdProductWise.Col = 11; grdProductWise.Focus(); } break; } case 14: { //CalculationsFooter(); grdProductWise.Col = 5; grdProductWise.Focus(); break; } case 15: { CalculationsFooter(grdProductWise); grdProductWise.Col = 7; grdProductWise.Focus(); break; } case 17: if (Convert.ToDouble(grdProductWise.Columns[7].Text) > Convert.ToDouble(grdProductWise.Columns[5].Text) + Convert.ToDouble(grdProductWise.Columns[6].Text)) { GlobalVar.MB("Cannot Block more than availble quantity ! ", MessageBoxIcon.Error); grdProductWise.Columns[7].Text = grdProductWise.Columns[5].Text; } grdProductWise.Col = 8; grdProductWise.Focus(); break; } }
private void dgFileAttachments_AfterColUpdate(object sender, ColEventArgs e) { switch (dgFileAttachments.Col) { case 2: dgFileAttachments.Row = dgFileAttachments.Row + 1; dgFileAttachments.Col = 0; dgFileAttachments.Focus(); break; } }
private void grdBonus_AfterColUpdate(object sender, ColEventArgs e) { DateTime datetime; switch (grdBonus.Col) { case 0: { grdBonus.Columns[0].Text = string.Format("{0:000-000}", Convert.ToInt32(grdBonus.Columns[0].Text)); grdBonus.Columns[1].Text = obj_bllReturnValue.ReturnValue(" pk_ProductID", (grdBonus.Columns[0].Text.Replace("-", "")), "ProductName", " M_Products"); if (grdBonus.Columns[1].Text != "") { grdBonus.Col = 2; grdBonus.Focus(); } else { grdBonus.Col = 0; grdBonus.Focus(); } break; } case 2: { if (grdBonus.Columns["Quantity"].Text != "") { if (Convert.ToDouble(grdBonus.Columns["Quantity"].Text) >= 0) { grdBonus.Col = 3; grdBonus.Focus(); } else { grdBonus.Columns["Quantity"].Text = ""; grdBonus.Col = 2; grdBonus.Focus(); } } else { grdBonus.Col = 2; grdBonus.Focus(); } break; } case 3: { if (grdBonus.Columns["Bonus"].Text != "") { if (Convert.ToDouble(grdBonus.Columns["Bonus"].Text) >= 0) { grdBonus.Col = 4; grdBonus.Focus(); } else { grdBonus.Columns["Bonus"].Text = ""; grdBonus.Col = 3; grdBonus.Focus(); } } else { grdBonus.Col = 3; grdBonus.Focus(); } break; } case 4: { if (grdBonus.Columns["Start Date"].Text != "") { DateTime.TryParse(grdBonus.Columns["Start Date"].Text, out datetime); if (datetime.ToString() == "01/01/0001 12:00:00 AM") { grdBonus.Columns["Start Date"].Text = ""; grdBonus.Col = 4; grdBonus.Focus(); } else { grdBonus.Columns["Start Date"].Value = datetime.Date.ToString("dd/MM/yyyy"); grdBonus.Col = 5; grdBonus.Focus(); } } break; } case 5: { if (grdBonus.Columns["End Date"].Text != "") { DateTime.TryParse(grdBonus.Columns["End Date"].Text, out datetime); if (datetime.ToString() == "01/01/0001 12:00:00 AM") { grdBonus.Columns["End Date"].Text = ""; grdBonus.Col = 5; grdBonus.Focus(); } else { grdBonus.Columns["End Date"].Value = datetime.Date.ToString("dd/MM/yyyy"); grdBonus.Col = 0; grdBonus.Row = grdBonus.Row + 1; grdBonus.Focus(); } } break; } } }
void Grid_Filters_ButtonClick(object sender, ColEventArgs e) { this.DeleteFilter(); }
private void grdSalemanWiseDetails_AfterColUpdate(object sender, ColEventArgs e) { switch (grdSalemanWiseDetails.Col) { case 0: { grdSalemanWiseDetails.Columns[0].Text = string.Format("{0:000000}", Convert.ToInt32(grdSalemanWiseDetails.Columns[0].Text)); grdSalemanWiseDetails.Columns[1].Text = obj_bllReturnValue.ReturnValue(" pk_GroupID", (grdSalemanWiseDetails.Columns[0].Text.Replace("-", "")), "G_Name", " M_Groups"); if (grdSalemanWiseDetails.Columns[1].Text != "") { grdSalemanWiseDetails.Col = 2; grdSalemanWiseDetails.Focus(); } else { grdSalemanWiseDetails.Col = 0; grdSalemanWiseDetails.Focus(); } break; } case 2: { if (grdSalemanWiseDetails.Columns["Week Day"].Text != "") { grdSalemanWiseDetails.Col = 3; grdSalemanWiseDetails.Focus(); } else { grdSalemanWiseDetails.Col = 2; grdSalemanWiseDetails.Focus(); } break; } case 3: { grdSalemanWiseDetails.Col = 4; grdSalemanWiseDetails.Focus(); break; } case 4: { grdSalemanWiseDetails.Col = 0; grdSalemanWiseDetails.Row = grdLicenses.Row + 1; grdSalemanWiseDetails.Focus(); break; } } }
private void grdAccountInformation_AfterColUpdate(object sender, ColEventArgs e) { switch (grdAccountInformation.Col) { case 0: { grdAccountInformation.Col = 1; grdAccountInformation.Focus(); break; } case 1: { grdAccountInformation.Col = 2; grdAccountInformation.Focus(); break; } case 2: { grdAccountInformation.Col = 0; grdAccountInformation.Row = grdLicenses.Row + 1; grdAccountInformation.Focus(); break; } } }
private void grdLicenses_AfterColUpdate(object sender, ColEventArgs e) { DateTime datetime; switch (grdLicenses.Col) { case 1: { grdLicenses.Col = 2; grdLicenses.Focus(); break; } case 2: { if (grdLicenses.Columns["Expiry Date"].Text != "") { DateTime.TryParse(grdLicenses.Columns["Expiry Date"].Text, out datetime); if (datetime.ToString() == "01/01/0001 12:00:00 AM") { grdLicenses.Columns["Expiry Date"].Text = ""; grdLicenses.Col = 2; grdLicenses.Focus(); } else { grdLicenses.Columns["Expiry Date"].Value = datetime.Date.ToString("dd/MM/yyyy"); grdLicenses.Col = 3; grdLicenses.Focus(); } } break; } case 3: { if (grdLicenses.Columns["Receipt Date"].Text != "") { DateTime.TryParse(grdLicenses.Columns["Receipt Date"].Text, out datetime); if (datetime.ToString() == "01/01/0001 12:00:00 AM") { grdLicenses.Columns["Receipt Date"].Text = ""; grdLicenses.Col = 3; grdLicenses.Focus(); } else { grdLicenses.Columns["Receipt Date"].Value = datetime.Date.ToString("dd/MM/yyyy"); grdLicenses.Col = 4; grdLicenses.Focus(); } } break; } case 4: { if (grdLicenses.Columns["Block Date"].Text != "") { DateTime.TryParse(grdLicenses.Columns["Block Date"].Text, out datetime); if (datetime.ToString() == "01/01/0001 12:00:00 AM") { grdLicenses.Columns["Block Date"].Text = ""; grdLicenses.Col = 4; grdLicenses.Focus(); } else { grdLicenses.Columns["Block Date"].Value = datetime.Date.ToString("dd/MM/yyyy"); grdLicenses.Col = 0; grdLicenses.Row = grdLicenses.Row + 1; grdLicenses.Focus(); } } break; } } }
private void grdCompanyPolicies_AfterColUpdate(object sender, ColEventArgs e) { DateTime datetime; switch (grdCompanyPolicies.Col) { case 0: { grdCompanyPolicies.Columns[0].Text = string.Format("{0:000}", Convert.ToInt32(grdCompanyPolicies.Columns[0].Text)); grdCompanyPolicies.Columns[1].Text = obj_bllReturnValue.ReturnValue(" pk_CompanyID", grdCompanyPolicies.Columns[0].Text, "CompanyName", " M_Company"); if (grdCompanyPolicies.Columns[1].Text != "") { grdCompanyPolicies.Col = 2; grdCompanyPolicies.Focus(); } else { grdCompanyPolicies.Col = 0; grdCompanyPolicies.Focus(); } break; } case 2: { grdCompanyPolicies.Col = 3; grdCompanyPolicies.Focus(); break; } case 3: { if (grdCompanyPolicies.Columns["Discount"].Text != "") { if (Convert.ToDouble(grdCompanyPolicies.Columns["Discount"].Text) <= 100 && Convert.ToDouble(grdCompanyPolicies.Columns["Discount"].Text) >= 0) { grdCompanyPolicies.Col = 4; grdCompanyPolicies.Focus(); } else { grdCompanyPolicies.Columns["Discount"].Text = ""; grdCompanyPolicies.Col = 3; grdCompanyPolicies.Focus(); } } else { grdCompanyPolicies.Col = 3; grdCompanyPolicies.Focus(); } break; } case 4: { if (grdCompanyPolicies.Columns["Start Date"].Text != "") { DateTime.TryParse(grdCompanyPolicies.Columns["Start Date"].Text, out datetime); if (datetime.ToString() == "01/01/0001 12:00:00 AM") { grdCompanyPolicies.Columns["Start Date"].Text = ""; grdCompanyPolicies.Col = 4; grdCompanyPolicies.Focus(); } else { grdCompanyPolicies.Columns["Start Date"].Value = datetime.Date.ToString("dd/MM/yyyy"); grdCompanyPolicies.Col = 5; grdCompanyPolicies.Focus(); } } break; } case 5: { if (grdCompanyPolicies.Columns["End Date"].Text != "") { DateTime.TryParse(grdCompanyPolicies.Columns["End Date"].Text, out datetime); if (datetime.ToString() == "01/01/0001 12:00:00 AM") { grdCompanyPolicies.Columns["End Date"].Text = ""; grdCompanyPolicies.Col = 5; grdCompanyPolicies.Focus(); } else { grdCompanyPolicies.Columns["End Date"].Value = datetime.Date.ToString("dd/MM/yyyy"); grdCompanyPolicies.Col = 6; grdCompanyPolicies.Focus(); } } break; } case 6: { grdCompanyPolicies.Col = 0; grdCompanyPolicies.Row = grdCompanyPolicies.Row + 1; grdCompanyPolicies.Focus(); break; } } }
private void grdCommission_AfterColUpdate(object sender, ColEventArgs e) { switch (grdCommission.Col) { case 0: { grdCommission.Col = 1; grdCommission.Focus(); break; } case 3: { if (grdCommission.Columns["Commission %"].Text != "") { if (Convert.ToDouble(grdCommission.Columns["Commission %"].Text) <= 100 && Convert.ToDouble(grdCommission.Columns["Commission %"].Text) >= 0) { grdCommission.Col = 0; grdCommission.Row = grdCommission.Row + 1; grdCommission.Focus(); } else { grdCommission.Columns["Commission %"].Text = ""; grdCommission.Col = 3; grdCommission.Focus(); } } else { grdCommission.Col = 0; grdCommission.Row = grdCommission.Row + 1; grdCommission.Focus(); } break; } } }
private void grdProductDetail_AfterColUpdate(object sender, ColEventArgs e) { switch (grdProductDetail.Col) { case 3: { grdProductDetail.Col = 4; grdProductDetail.Focus(); break; } case 4: { grdProductDetail.Col = 3; grdProductDetail.Row = grdProductDetail.Row + 1; grdProductDetail.Focus(); break; } } }
private void grdOrderDetails_AfterColUpdate(object sender, ColEventArgs e) { switch (grdDetails.Col) { case 3: { if (ValidateGrid(grdDetails.Columns["ID"].Text, grdDetails.Columns["Batch No"].Text, grdDetails.Columns["Type"].Text, grdDetails.Columns["Mfg. Date"].Text, grdDetails.Columns["Exp. Date"].Text, grdDetails.Row)) { grdDetails.Col = 4; grdDetails.Focus(); } else { grdDetails.Columns["Type"].Text = ""; grdDetails.Col = 3; grdDetails.Focus(); MessageBox.Show("This Product is Already exist with same Batch", "Babar Medicine Company Lahore - ERP", MessageBoxButtons.OK, MessageBoxIcon.Warning); } break; } case 5: { DateTime dt; if (DateTime.TryParseExact(grdDetails.Columns["Mfg. Date"].Text, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out dt)) { grdDetails.Columns["Mfg. Date"].Value = dt.Date.ToString("dd/MM/yyyy"); grdDetails.Col = 6; grdDetails.Focus(); } else { DateTime dt1; if (DateTime.TryParseExact(grdDetails.Columns["Mfg. Date"].Text, "dd/MM/yy ", CultureInfo.InvariantCulture, DateTimeStyles.None, out dt1)) { grdDetails.Columns["Mfg. Date"].Value = dt1.Date.ToString("dd/MM/yyyy"); grdDetails.Col = 6; grdDetails.Focus(); } else { grdDetails.Col = 5; grdDetails.Focus(); MessageBox.Show("Invalid Date", "Babar Medicine Company Lahore - ERP", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); grdDetails.Columns["Mfg. Date"].Value = ""; } } break; } case 6: { DateTime dt; if (DateTime.TryParseExact(grdDetails.Columns["Exp. Date"].Text, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out dt)) { grdDetails.Columns["Exp. Date"].Value = dt.Date.ToString("dd/MM/yyyy"); if (Convert.ToDateTime(grdDetails.Columns["Exp. Date"].Value) <= Convert.ToDateTime(grdDetails.Columns["Mfg. Date"].Value)) { MessageBox.Show("Expiry date must be greater than tha manufacturing date", "Babar Medicine Company Lahore - ERP", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); grdDetails.Columns["Exp. Date"].Value = ""; grdDetails.Col = 6; grdDetails.Focus(); } else { grdDetails.Col = 8; grdDetails.Focus(); } } else { DateTime dt1; if (DateTime.TryParseExact(grdDetails.Columns["Exp. Date"].Text, "dd/MM/yy ", CultureInfo.InvariantCulture, DateTimeStyles.None, out dt1)) { grdDetails.Columns["Exp. Date"].Value = dt1.Date.ToString("dd/MM/yyyy"); if (Convert.ToDateTime(grdDetails.Columns["Exp. Date"].Value) <= Convert.ToDateTime(grdDetails.Columns["Mfg. Date"].Value)) { MessageBox.Show("Expiry date must be greater than tha manufacturing date", "Babar Medicine Company Lahore - ERP", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); grdDetails.Columns["Exp. Date"].Value = ""; grdDetails.Col = 6; grdDetails.Focus(); } else { grdDetails.Col = 8; grdDetails.Focus(); } } else { grdDetails.Col = 6; grdDetails.Focus(); MessageBox.Show("Invalid Date", "Babar Medicine Company Lahore - ERP", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); grdDetails.Columns["Exp. Date"].Value = ""; } } break; } case 7: { grdDetails.Col = 8; grdDetails.Focus(); Calculations(); break; } case 8: { if (grdDetails.Columns["Qty"].Value.ToString() != "" && grdDetails.Columns["ID"].Value.ToString() != "" && grdDetails.Columns["Batch No"].Value.ToString() != "" && grdDetails.Columns["Type"].Value.ToString() != "" && grdDetails.Columns["Mfg. Date"].Value.ToString() != "" && grdDetails.Columns["Mfg. Date"].Value.ToString() != "" && grdDetails.Columns["CostRate"].Value.ToString() != "") { if (Convert.ToDateTime(grdDetails.Columns["Exp. Date"].Value.ToString()) < Convert.ToDateTime(GlobalVar.g_WorkDate)) { if (Convert.ToUInt32(grdDetails.Columns["Qty"].Value) > Convert.ToUInt32(ObjbllSaleReturn.VerifyIntimationQuantity(grdDetails.Columns["ID"].Text.Replace("-", ""), grdDetails.Columns["Batch No"].Text, grdDetails.Columns["Type"].Text, grdDetails.Columns["Mfg. Date"].Value.ToString(), grdDetails.Columns["Exp. Date"].Value.ToString(), grdDetails.Columns["CostRate"].Value.ToString(), txtCustomerId.Text, txtEmployeeid.Text))) { MessageBox.Show("Intimation Not found", "Babar Medicine Company Lahore - ERP", MessageBoxButtons.OK, MessageBoxIcon.Warning); grdDetails.Col = 8; grdDetails.Focus(); grdDetails.Columns["Qty"].Value = "0.00"; Calculations(); } else { Calculations(); grdDetails.Row = grdDetails.Row + 1; grdDetails.Col = 0; grdDetails.Focus(); } } else { Calculations(); grdDetails.Row = grdDetails.Row + 1; grdDetails.Col = 0; grdDetails.Focus(); } } else { MessageBox.Show("Some fields are empty", "Babar Medicine Company Lahore - ERP", MessageBoxButtons.OK, MessageBoxIcon.Warning); grdDetails.Columns["Qty"].Value = "0.00"; Calculations(); } break; } case 9: { if (grdDetails.Columns["Discount"].Value.ToString() != "") { Calculations(); grdDetails.Row = grdDetails.Row + 1; grdDetails.Col = 0; grdDetails.Focus(); } else { grdDetails.Columns["Discount"].Value = 0; Calculations(); grdDetails.Row = grdDetails.Row + 1; grdDetails.Focus(); } break; } } }
private void grdStages_AfterColUpdate(object sender, ColEventArgs e) { switch (grdStages.Col) { case 0: { DateTime dt; if (DateTime.TryParseExact(grdStages.Columns[0].Text, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out dt)) { grdStages.Columns[0].Value = dt.Date.ToString("dd/MM/yyyy"); grdStages.Col = 1; grdStages.Focus(); } else { DateTime dt1; if (DateTime.TryParseExact(grdStages.Columns[0].Text, "dd/MM/yy ", CultureInfo.InvariantCulture, DateTimeStyles.None, out dt1)) { grdStages.Columns[0].Value = dt1.Date.ToString("dd/MM/yyyy"); grdStages.Col = 1; grdStages.Focus(); } else { grdStages.Col = 0; grdStages.Focus(); MessageBox.Show("Invalid Date", "Babar Medicine Company Lahore - ERP", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); grdStages.Columns[0].Value = ""; } } break; } case 1: { DateTime dt; if (DateTime.TryParseExact(grdStages.Columns[1].Text, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out dt)) { grdStages.Columns[1].Value = dt.Date.ToString("dd/MM/yyyy"); grdStages.Col = 2; grdStages.Focus(); } else { DateTime dt1; if (DateTime.TryParseExact(grdStages.Columns[1].Text, "dd/MM/yy ", CultureInfo.InvariantCulture, DateTimeStyles.None, out dt1)) { grdStages.Columns[1].Value = dt1.Date.ToString("dd/MM/yyyy"); grdStages.Col = 2; grdStages.Focus(); } else { grdStages.Col = 1; grdStages.Focus(); MessageBox.Show("Invalid Date", "Babar Medicine Company Lahore - ERP", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); grdStages.Columns[1].Value = ""; } } break; } case 2: { if (grdStages.Columns[2].Value.ToString() != "" && Isnumeric(grdStages.Columns[2].Value.ToString())) { string SalePersonName = ""; SalePersonName = objbllSalesOppertunity.NameByID("M_BMC_Employee", "pk_EmployeeId", grdStages.Columns[2].Value.ToString(), "FirstName", ""); if (SalePersonName != "") { grdStages.Columns[3].Value = SalePersonName; grdStages.Columns[2].Value = string.Format("{0:000000}", Convert.ToInt32(grdStages.Columns[2].Value.ToString())); grdStages.Col = 4; grdStages.Focus(); } else { MessageBox.Show("Employee not Exist ", "Babar Medicine Company Lahore - ERP", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); grdStages.Columns[2].Value = ""; grdStages.Columns[3].Value = ""; grdStages.Col = 2; grdStages.Focus(); } } else { MessageBox.Show("Please enter valid Id", "Babar Medicine Company Lahore - ERP", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); grdStages.Columns[2].Value = ""; grdStages.Columns[3].Value = ""; grdStages.Col = 2; grdStages.Focus(); } break; } case 4: grdStages.Col = 5; grdStages.Focus(); break; case 5: if (Isnumeric(grdStages.Columns[5].Value.ToString())) { grdStages.Col = 6; grdStages.Focus(); } else { MessageBox.Show("Numeric value only", "Babar Medicine Company Lahore - ERP", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); grdStages.Columns[5].Value = ""; grdStages.Col = 5; grdStages.Focus(); } break; case 6: grdStages.Col = 7; grdStages.Focus(); break; case 7: grdStages.Row = grdStages.Row + 1; grdStages.Col = 0; grdStages.Focus(); break; } }
private void grdDetails_AfterColUpdate(object sender, ColEventArgs e) { var _with1 = grdDetails; switch (_with1.Col) { case 10: Ln_Balance = Convert.ToDouble(_with1.Columns["Amount"].Text) - Convert.ToDouble(_with1.Columns["Cheque"].Text) - Convert.ToDouble(_with1.Columns["Return"].Text) - Convert.ToDouble(_with1.Columns["Cash"].Text) - Convert.ToDouble(_with1.Columns["ChqRound"].Text); if (Convert.ToDouble(_with1.Columns["Comm."].Text) > Ln_Balance) { _with1.Columns["Comm."].Text = string.Format("{0:0.0000}", Ln_Balance); } UpdateFooterInformation(); break; case 6: Ln_Balance = Convert.ToDouble(_with1.Columns["Amount"].Text) - Convert.ToDouble(_with1.Columns["Credit"].Text) - Convert.ToDouble(_with1.Columns["Cheque"].Text) - Convert.ToDouble(_with1.Columns["Return"].Text) - Convert.ToDouble(_with1.Columns["Comm."].Text) - Convert.ToDouble(_with1.Columns["ChqRound"].Text); if (Convert.ToDouble(_with1.Columns["Cash"].Text) > Ln_Balance) _with1.Columns["Cash"].Text = string.Format("{0:0.0000}", Ln_Balance); if (Convert.ToDouble(_with1.Columns["Cash"].Text) != 0) _with1.Columns["Status"].Text = "Cash"; if (Convert.ToDouble(_with1.Columns["Cash"].Text) != 0) { _with1.Columns["Credit"].Text = string.Format("{0:0.0000}", Convert.ToDouble(_with1.Columns["Amount"].Text) - Convert.ToDouble(_with1.Columns["Cash"].Text) - Convert.ToDouble(_with1.Columns["Cheque"].Text) - Convert.ToDouble(_with1.Columns["Return"].Text) - Convert.ToDouble(_with1.Columns["Comm."].Text) - Convert.ToDouble(_with1.Columns["ChqRound"].Text)); } if (Convert.ToDouble(_with1.Columns["Credit"].Text) != 0) _with1.Columns["Status"].Text = "Credit"; UpdateFooterInformation(); _with1.Row = _with1.Row + 1; _with1.Col = 6; _with1.Focus(); break; } }