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;
}
}
