private void btnPickList_Click(object sender, EventArgs e)
{
frmPickList pickList = new frmPickList(obj_pickList);
//obj_pickList.WhereClause = "@DSSId= " + obj_mdlSaleInvoice.DSSID + ",@OCGroupId= " + obj_mdlSaleInvoice.OCGroupID + "";
obj_pickList.PickListID = "Sale Invoice";
obj_pickList.ReturnFieldName = "Invoice Id";
obj_pickList.ReturnSecondFieldValue = "InvoiceDate";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
txtID.Text = obj_pickList.ReturnFieldValue;
}
private void btnFindSalemanID_Click(object sender, EventArgs e)
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.WhereClause = null;
obj_pickList.PickListID = "Users";
obj_pickList.ReturnFieldName = "User ID";
obj_pickList.ReturnSecondFieldValue = "UserName";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
txtSaleManId.Text = obj_pickList.ReturnFieldValue;
txtSaleManName.Text = obj_pickList.ReturnSecondFieldValue;
}
private void PickListSaleEmployee()
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.WhereClause = null;
obj_pickList.PickListID = "Employees";
obj_pickList.ReturnFieldName = "Employee ID";
obj_pickList.ReturnSecondFieldValue = "Name";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
if (obj_pickList.ReturnFieldValue == null) return;
txtSalePersonId.Text = obj_pickList.ReturnFieldValue;
txtSaleEmployee.Text = obj_pickList.ReturnSecondFieldValue;
txtTenderNo.Focus();
}
private void grdStages_PreviewKeyDown(object sender, PreviewKeyDownEventArgs e)
{
if (e.KeyCode == Keys.F11)
{
DeleteSelectedRow(grdStages);
}
if (e.KeyCode == Keys.F10)
{
switch (grdStages.Col)
{
case 2:
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.WhereClause = null;
obj_pickList.PickListID = "Employees";
obj_pickList.ReturnFieldName = "Employee ID";
obj_pickList.ReturnSecondFieldValue = "Name";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
if (obj_pickList.ReturnFieldValue == null) return;
grdStages.Columns[2].Value = obj_pickList.ReturnFieldValue;
grdStages.Columns[3].Value = obj_pickList.ReturnSecondFieldValue;
grdStages.Col = 4;
grdStages.Focus();
break;
}
}
}
private void PickList(string PickListID, string ReturnField, string Second, TextEdit txtBox1, TextEdit txtBox2, string WhereClause)
{
obj_mdlPickList.WhereClause = null;
frmPickList pickList = new frmPickList(obj_mdlPickList);
obj_mdlPickList.PickListID = PickListID;
obj_mdlPickList.ReturnFieldName = ReturnField;
obj_mdlPickList.ReturnSecondFieldValue = Second;
if (WhereClause != "")
{
obj_mdlPickList.WhereClause = WhereClause;
}
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
if (obj_mdlPickList.ReturnFieldValue != null)
{
txtBox1.Text = obj_mdlPickList.ReturnFieldValue;
if (Second != "")
txtBox2.Text = obj_mdlPickList.ReturnSecondFieldValue;
}
}
private void PickListFM()
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.PickListID = "FieldManager";
obj_pickList.ReturnFieldName = "FM ID";
obj_pickList.ReturnSecondFieldValue = "FM Name";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
if (obj_pickList.ReturnFieldName == "") return;
txtFMID.Text = obj_pickList.ReturnFieldValue;
txtFMName.Text = obj_pickList.ReturnSecondFieldValue;
chkIsDiscontinue.Focus();
}
private void txtCompanygroupid_PreviewKeyDown_1(object sender, PreviewKeyDownEventArgs e)
{
// F10 ASCII 121
if (e.KeyCode == (Keys.F10))
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.PickListID = "Companygroups";
obj_pickList.ReturnFieldName = "Groupid";
//obj_pickList.WhereClause = GlobalVar.g_UserID;
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
ShowData(obj_pickList.ReturnFieldValue);
txtCompanygroupid.Text = obj_pickList.ReturnFieldValue;
}
//Enter ASCII 13
if (e.KeyCode == (Keys.Enter))
{
OnGoupIdEnter();
}
}
private void ShowPickList()
{
frmPickList pickList = new frmPickList(obj_mdlPickList);
obj_mdlPickList.PickListID = "SystemInformation";
obj_mdlPickList.ReturnFieldName = "BranchId";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
if (obj_mdlPickList.ReturnFieldValue != null)
{
ShowDataGeneralSettings(obj_mdlPickList.ReturnFieldValue);
}
}
private void PickListReportCompany()
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.PickListID = "Company";
obj_pickList.ReturnFieldName = "Company ID";
obj_pickList.ReturnSecondFieldValue = "Company Name";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
txtReportCompanyid.Text = obj_pickList.ReturnFieldValue;
txtReportCompanyName.Text = obj_pickList.ReturnSecondFieldValue;
}
private void PickListProduct()
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.WhereClause = null;
obj_pickList.PickListID = "Products";
obj_pickList.ReturnFieldName = "Product Id";
obj_pickList.ReturnSecondFieldValue = "Product Name";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
txtProductId.Text = obj_pickList.ReturnFieldValue;
txtProductName.Text = obj_pickList.ReturnSecondFieldValue;
}
private void PickListCompanyGroup()
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.PickListID = "Companygroups";
obj_pickList.ReturnFieldName = "Groupid";
obj_pickList.ReturnSecondFieldValue = "GroupName";
//obj_pickList.WhereClause = GlobalVar.g_UserID;
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
txtGroupid.Text = obj_pickList.ReturnFieldValue;
txtGroupName.Text = obj_pickList.ReturnSecondFieldValue;
}
private void PickListClaimPartner()
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.PickListID = "Business Partner";
obj_pickList.ReturnFieldName = "Partner ID";
obj_pickList.ReturnSecondFieldValue = "Partner Name";
obj_pickList.WhereClause = "Claims";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
txtClaimPartnerID.Text = obj_pickList.ReturnFieldValue;
txtClaimPartnerName.Text = obj_pickList.ReturnSecondFieldValue;
txtShelfCode.Focus();
}
private void c1_grdInvoice_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.KeyCode == Keys.F11)
{
if (!string.IsNullOrEmpty(c1_grdInvoice[c1_grdInvoice.Row, 0].ToString()) && string.IsNullOrEmpty(c1_grdInvoice[c1_grdInvoice.Row, 1].ToString()))
{
c1_grdInvoice.Delete(c1_grdInvoice.Row);
UpdateGridFooter();
}
else
{
MessageBox.Show("System was unable to remove the selected information.\n Try again to remove the selected information.", "Babar Medicine Company - ERP", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
if (e.KeyCode == Keys.F10 & (!string.IsNullOrEmpty((txtCustomerId.Text).Trim()) || !string.IsNullOrEmpty((txtCustomerName.Text).Trim())))
{
switch (c1_grdInvoice.Col)
{
case 0:
if (e.KeyCode == Keys.F10)
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.WhereClause = null;
obj_pickList.PickListID = "Sale Invoice Products";
obj_pickList.ReturnFieldName = "Product Id";
obj_pickList.ReturnSecondFieldValue = "Product Name";
if (!string.IsNullOrEmpty((obj_mdlSaleInvoice.OCGroupID)))
{
obj_pickList.WhereClause = obj_mdlSaleInvoice.OCGroupID;
}
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
txtSaleManId.Text = obj_pickList.ReturnFieldValue;
txtSaleManName.Text = obj_pickList.ReturnSecondFieldValue;
if (!string.IsNullOrEmpty(obj_pickList.ReturnFieldValue))
{
dtProduct = null;
dtProduct = obj_bllProduct.SelectData(obj_pickList.ReturnFieldValue);
if (dtProduct.Rows.Count == 0)
{
c1_grdInvoice.Columns["Product"].Text = "";
c1_grdInvoice.Columns["Product Name"].Text = "";
c1_grdInvoice.Columns["Unit"].Text = "";
c1_grdInvoice.Columns["T.P."].Text = "";
c1_grdInvoice.Columns["SaleTaxPer"].Text = "";
c1_grdInvoice.Columns["SaleTaxVal"].Text = "";
c1_grdInvoice.Columns["GroupId"].Text = "";
c1_grdInvoice.Columns["OCGroup"].Text = "";
c1_grdInvoice.Columns["MaxSaleDiscount"].Text = "";
c1_grdInvoice.Columns["MinFlatRate"].Text = "";
c1_grdInvoice.Columns["MaxFlatRate"].Text = "";
c1_grdInvoice.Columns["UseFlatRate"].Text = "";
c1_grdInvoice.Columns["Narcotic"].Text = "";
c1_grdInvoice.Columns["MaxQtyDay"].Text = "";
c1_grdInvoice.Columns["MaxQty"].Text = "";
c1_grdInvoice.Columns["MaxDays"].Text = "";
c1_grdInvoice.Columns["bk_BatchNo"].Text = "";
c1_grdInvoice.Columns["bk_ExpiryDate"].Text = "";
c1_grdInvoice.Columns["bk_TradePrice"].Text = "";
c1_grdInvoice.Columns["bk_Bonus"].Text = "";
c1_grdInvoice.Columns["bk_SaleTaxValue"].Text = "";
c1_grdInvoice.Columns["InvDetId"].Text = "";
c1_grdInvoice.Columns["FlatRate"].Text = "";
c1_grdInvoice.Columns["ClaimableDisc"].Text = "";
c1_grdInvoice.Columns["OurShare"].Text = "";
c1_grdInvoice.Columns["Quantity"].Text = "0";
c1_grdInvoice.Columns["Bonus"].Text = "0";
c1_grdInvoice.Columns["Discount"].Text = "0.0000";
c1_grdInvoice.Columns["Discount"].Text = "0.0000";
c1_grdInvoice.Columns["Sale Tax"].Text = "0.0000";
c1_grdInvoice.Columns["CommPer"].Text = "0.0000";
c1_grdInvoice.Columns["Commission"].Text = "0.0000";
c1_grdInvoice.Columns["Total"].Text = "0.0000";
//.Columns("DP"].Text = ""
UpdateGridFooter();
c1_grdInvoice.Col = 0;
c1_grdInvoice.Focus();
}
else
{
//string Lc_Product12 = null;
string LcProduct = null;
string Lc_price = null;
LcProduct = obj_pickList.ReturnFieldValue;
Lc_LicNo = "01";
//Lc_Product12 = mpi_DAL_SaleInv.ReturnKeyName(obj_pickList.ReturnFieldValue, "Product12"];
if (string.IsNullOrEmpty(Lc_LicNo))
{
MessageBox.Show("This Product is Not Allow For This Customer.", "Babar Medicine Company - ERP", MessageBoxButtons.OK, MessageBoxIcon.Stop);
c1_grdInvoice.Columns["Product"].Text = "";
}
else
{
if (txtEmployeeId.Text == "09")
{
//if (mpi_DAL_SaleInv.ProductInformation.Item("Ins"] == "True"]
//{
// Interaction.MsgBox("This Product is Not Allow For Instituation", MsgBoxStyle.Critical, lblTitle.Text);
//}
//else
//{
c1_grdInvoice.Columns["Product"].Text = string.Format("{0:000-000}", (dtProduct.Rows[0]["Pk_ProductId"]));
Ln_RC = Ln_RC + 1;
c1_grdInvoice.Columns["InvDetId"].Text = dtProduct.Rows[0]["Pk_ProductId"] + string.Format("{0:000}", Ln_RC);
c1_grdInvoice.Columns["Product Name"].Text = dtProduct.Rows[0]["ProductName"].ToString();
c1_grdInvoice.Columns["Unit"].Text = dtProduct.Rows[0]["Pack"].ToString();
Lc_price = obj_bllSaleInvoice.GetProductPrice(LcProduct, txtCustomerId.Text, GlobalVar.g_WorkDate);
if (!string.IsNullOrEmpty(Lc_price))
{
c1_grdInvoice.Columns["T.P."].Text = Lc_price;
c1_grdInvoice.Columns["Product Name"].Text = c1_grdInvoice.Columns["Product Name"].Text.Replace(c1_grdInvoice.Columns["Product Name"].ToString(), "(SP)-" + c1_grdInvoice.Columns["Product Name"].Text);
}
else if (string.IsNullOrEmpty(Lc_price) & dtProduct.Rows[0]["SpecialRate"].ToString() != "0")
{
c1_grdInvoice.Columns["Product Name"].Text = c1_grdInvoice.Columns["Product Name"].Text.Replace(c1_grdInvoice.Columns["Product Name"].ToString(), "(SP)-" + c1_grdInvoice.Columns["Product Name"].Text);
c1_grdInvoice.Columns["T.P."].Text = dtProduct.Rows[0]["SpecialRate"].ToString();
}
else
{
c1_grdInvoice.Columns["T.P."].Text = dtProduct.Rows[0]["TradePrice"].ToString();
}
c1_grdInvoice.Columns["SaleTaxPer"].Text = dtProduct.Rows[0]["SaleTaxPer"].ToString();
c1_grdInvoice.Columns["SaleTaxVal"].Text = dtProduct.Rows[0]["SaleTaxValue"].ToString();
c1_grdInvoice.Columns["GroupId"].Text = dtProduct.Rows[0]["Fk_GroupId"].ToString();
c1_grdInvoice.Columns["OCGroup"].Text = dtProduct.Rows[0]["Fk_GroupId"].ToString();
c1_grdInvoice.Columns["MaxSaleDiscount"].Text = dtProduct.Rows[0]["MaxSaleDiscPer"].ToString();
c1_grdInvoice.Columns["MinFlatRate"].Text = dtProduct.Rows[0]["MinFlatRate"].ToString();
c1_grdInvoice.Columns["MaxFlatRate"].Text = dtProduct.Rows[0]["MaxFlatRate"].ToString();
c1_grdInvoice.Columns["UseFlatRate"].Text = dtProduct.Rows[0]["UseFlatRate"].ToString();
c1_grdInvoice.Columns["Narcotic"].Text = dtProduct.Rows[0]["NonPharma"].ToString();
c1_grdInvoice.Columns["MaxQtyDay"].Text = dtProduct.Rows[0]["MaxQtyDay"].ToString();
c1_grdInvoice.Columns["MaxQty"].Text = dtProduct.Rows[0]["MaxQtyPerCustomer"].ToString();
c1_grdInvoice.Columns["MaxDays"].Text = dtProduct.Rows[0]["MaxQtyDays"].ToString();
c1_grdInvoice.Columns["bk_BatchNo"].Text = dtProduct.Rows[0]["Pack"].ToString();
c1_grdInvoice.Columns["bk_ExpiryDate"].Text = dtProduct.Rows[0]["InventoryDays"].ToString();
c1_grdInvoice.Columns["bk_TradePrice"].Text = dtProduct.Rows[0]["TradePrice"].ToString();
c1_grdInvoice.Columns["bk_Bonus"].Text = dtProduct.Rows[0]["AutoBonus"].ToString();
c1_grdInvoice.Columns["bk_SaleTaxValue"].Text = dtProduct.Rows[0]["AutoBonus"].ToString();
//c1_grdInvoice.Columns["OurShare"].Text = dtProduct.Rows[0]["sh;
c1_grdInvoice.Columns["FlatRate"].Text = dtProduct.Rows[0]["TradePrice"].ToString();
c1_grdInvoice.Columns["CommPer"].Text = dtProduct.Rows[0]["SaleTaxPer"].ToString();
c1_grdInvoice.Columns["Bonus"].Text = "0";
c1_grdInvoice.Columns["Discount"].Text = string.Format("{0:0.0000}", ReturnGridCalculation("Discount"));
c1_grdInvoice.Columns["Sale Tax"].Text = string.Format("{0:0.0000}", ReturnGridCalculation("SaleTax"));
c1_grdInvoice.Columns["Total"].Text = string.Format("{0:0.0000}", ReturnGridCalculation("Total"));
c1_grdInvoice.Columns["Commission"].Text = string.Format("{0:0.0000}", ReturnGridCalculation("Commission"));
//.Columns("DP"].Text = ""
UpdateGridFooter();
txtStock.Text = dtProduct.Rows[0]["BalanceStock"].ToString();
txtBonus.Text = dtProduct.Rows[0]["BalanceBonus"].ToString();
if (Convert.ToInt16(txtStock.Text) == 0)
{
MessageBox.Show("Item has no stock to Issue.", "Babar Medicine Company - ERP", MessageBoxButtons.OK, MessageBoxIcon.Stop);
c1_grdInvoice.Columns["Product"].Text = "";
c1_grdInvoice.Columns["Product Name"].Text = "";
c1_grdInvoice.Columns["Unit"].Text = "";
c1_grdInvoice.Columns["T.P."].Text = "";
c1_grdInvoice.Columns["SaleTaxPer"].Text = "";
c1_grdInvoice.Columns["SaleTaxVal"].Text = "";
c1_grdInvoice.Columns["GroupId"].Text = "";
c1_grdInvoice.Columns["OCGroup"].Text = "";
c1_grdInvoice.Columns["MaxSaleDiscount"].Text = "";
c1_grdInvoice.Columns["MinFlatRate"].Text = "";
c1_grdInvoice.Columns["MaxFlatRate"].Text = "";
c1_grdInvoice.Columns["UseFlatRate"].Text = "";
c1_grdInvoice.Columns["Narcotic"].Text = "";
c1_grdInvoice.Columns["MaxQtyDay"].Text = "";
c1_grdInvoice.Columns["MaxQty"].Text = "";
c1_grdInvoice.Columns["MaxDays"].Text = "";
c1_grdInvoice.Columns["bk_BatchNo"].Text = "";
c1_grdInvoice.Columns["bk_ExpiryDate"].Text = "";
c1_grdInvoice.Columns["bk_TradePrice"].Text = "";
c1_grdInvoice.Columns["bk_Bonus"].Text = "";
c1_grdInvoice.Columns["bk_SaleTaxValue"].Text = "";
c1_grdInvoice.Columns["Quantity"].Text = "0";
c1_grdInvoice.Columns["Bonus"].Text = "0";
c1_grdInvoice.Columns["Discount"].Text = "0.0000";
c1_grdInvoice.Columns["Discount"].Text = "0.0000";
c1_grdInvoice.Columns["Sale Tax"].Text = "0.0000";
c1_grdInvoice.Columns["Total"].Text = "0.0000";
c1_grdInvoice.Columns["CommPer"].Text = "0.0000";
c1_grdInvoice.Columns["Commission"].Text = "0.0000";
//.Columns("DP"].Text = ""
UpdateGridFooter();
txtStock.Text = "";
txtBonus.Text = "";
c1_grdInvoice.Col = 0;
c1_grdInvoice.Focus();
}
else
{
c1_grdInvoice.Col = 4;
c1_grdInvoice.Focus();
}
//}
}
else
{
c1_grdInvoice.Columns["Product"].Text = string.Format("{0:000-000}", Convert.ToInt32(dtProduct.Rows[0]["Pk_ProductId"].ToString()));
Ln_RC = Ln_RC + Convert.ToInt16(1);
c1_grdInvoice.Columns["InvDetId"].Text = dtProduct.Rows[0]["Pk_ProductId"] + string.Format("{0:000}", Ln_RC);
c1_grdInvoice.Columns["Product Name"].Text = dtProduct.Rows[0]["ProductName"].ToString();
c1_grdInvoice.Columns["Unit"].Text = dtProduct.Rows[0]["Pack"].ToString();
Lc_price = obj_bllSaleInvoice.GetProductPrice(LcProduct, txtCustomerId.Text, GlobalVar.g_WorkDate);
if (!string.IsNullOrEmpty(Lc_price))
{
c1_grdInvoice.Columns["T.P."].Text = Lc_price;
c1_grdInvoice.Columns["Product Name"].Text = c1_grdInvoice.Columns["Product Name"].Text.Replace(c1_grdInvoice.Columns["Product Name"].ToString(), "(SP)-" + c1_grdInvoice.Columns["Product Name"].Text);
}
else if (string.IsNullOrEmpty(Lc_price) && dtProduct.Rows[0]["SpecialRate"].ToString() != "0")
{
c1_grdInvoice.Columns["Product Name"].Text = c1_grdInvoice.Columns["Product Name"].Text.Replace(c1_grdInvoice.Columns["Product Name"].ToString(), "(SP)-" + c1_grdInvoice.Columns["Product Name"].Text);
c1_grdInvoice.Columns["T.P."].Text = dtProduct.Rows[0]["SpecialRate"].ToString();
}
else
{
c1_grdInvoice.Columns["T.P."].Text = dtProduct.Rows[0]["TradePrice"].ToString();
}
c1_grdInvoice.Columns["SaleTaxPer"].Text = dtProduct.Rows[0]["SaleTaxPer"].ToString();
c1_grdInvoice.Columns["SaleTaxVal"].Text = dtProduct.Rows[0]["SaleTaxValue"].ToString();
c1_grdInvoice.Columns["GroupId"].Text = dtProduct.Rows[0]["Fk_GroupId"].ToString();
c1_grdInvoice.Columns["OCGroup"].Text = dtProduct.Rows[0]["Fk_GroupId"].ToString();
c1_grdInvoice.Columns["MaxSaleDiscount"].Text = dtProduct.Rows[0]["MaxSaleDiscPer"].ToString();
c1_grdInvoice.Columns["MinFlatRate"].Text = dtProduct.Rows[0]["MinFlatRate"].ToString();
c1_grdInvoice.Columns["MaxFlatRate"].Text = dtProduct.Rows[0]["MaxFlatRate"].ToString();
c1_grdInvoice.Columns["UseFlatRate"].Text = dtProduct.Rows[0]["UseFlatRate"].ToString();
c1_grdInvoice.Columns["Narcotic"].Text = dtProduct.Rows[0]["NonPharma"].ToString();
c1_grdInvoice.Columns["MaxQtyDay"].Text = dtProduct.Rows[0]["MaxQtyDay"].ToString();
c1_grdInvoice.Columns["MaxQty"].Text = dtProduct.Rows[0]["MaxQtyPerCustomer"].ToString();
c1_grdInvoice.Columns["MaxDays"].Text = dtProduct.Rows[0]["MaxQtyDays"].ToString();
c1_grdInvoice.Columns["bk_BatchNo"].Text = dtProduct.Rows[0]["Pack"].ToString();
c1_grdInvoice.Columns["bk_ExpiryDate"].Text = dtProduct.Rows[0]["InventoryDays"].ToString();
c1_grdInvoice.Columns["bk_TradePrice"].Text = dtProduct.Rows[0]["TradePrice"].ToString();
c1_grdInvoice.Columns["bk_Bonus"].Text = dtProduct.Rows[0]["AutoBonus"].ToString();
c1_grdInvoice.Columns["bk_SaleTaxValue"].Text = dtProduct.Rows[0]["AutoBonus"].ToString();
//c1_grdInvoice.Columns["OurShare"].Text = dtProduct.Rows[0]["sh;
c1_grdInvoice.Columns["FlatRate"].Text = dtProduct.Rows[0]["TradePrice"].ToString();
c1_grdInvoice.Columns["CommPer"].Text = dtProduct.Rows[0]["SaleTaxPer"].ToString();
c1_grdInvoice.Columns["Bonus"].Text = "0";
c1_grdInvoice.Columns["Discount"].Text = ReturnGridCalculation("Discount").ToString();
c1_grdInvoice.Columns["Sale Tax"].Text = ReturnGridCalculation("SaleTax").ToString();
c1_grdInvoice.Columns["Total"].Text = ReturnGridCalculation("Total").ToString();
c1_grdInvoice.Columns["Commission"].Text = ReturnGridCalculation("Commission").ToString();
//.Columns("DP"].Text = ""
UpdateGridFooter();
txtStock.Text = dtProduct.Rows[0]["BalanceStock"].ToString();
txtBonus.Text = dtProduct.Rows[0]["BalanceBonus"].ToString();
if (Convert.ToInt32(txtStock.Text) == 0)
{
MessageBox.Show("Item has no stock to Issue.", "Babar Medicine Company - ERP", MessageBoxButtons.OK, MessageBoxIcon.Stop);
c1_grdInvoice.Columns["Product"].Text = "";
c1_grdInvoice.Columns["Product Name"].Text = "";
c1_grdInvoice.Columns["Unit"].Text = "";
c1_grdInvoice.Columns["T.P."].Text = "";
c1_grdInvoice.Columns["SaleTaxPer"].Text = "";
c1_grdInvoice.Columns["SaleTaxVal"].Text = "";
c1_grdInvoice.Columns["GroupId"].Text = "";
c1_grdInvoice.Columns["OCGroup"].Text = "";
c1_grdInvoice.Columns["MaxSaleDiscount"].Text = "";
c1_grdInvoice.Columns["MinFlatRate"].Text = "";
c1_grdInvoice.Columns["MaxFlatRate"].Text = "";
c1_grdInvoice.Columns["UseFlatRate"].Text = "";
c1_grdInvoice.Columns["Narcotic"].Text = "";
c1_grdInvoice.Columns["MaxQtyDay"].Text = "";
c1_grdInvoice.Columns["MaxQty"].Text = "";
c1_grdInvoice.Columns["MaxDays"].Text = "";
c1_grdInvoice.Columns["bk_BatchNo"].Text = "";
c1_grdInvoice.Columns["bk_ExpiryDate"].Text = "";
c1_grdInvoice.Columns["bk_TradePrice"].Text = "";
c1_grdInvoice.Columns["bk_Bonus"].Text = "";
c1_grdInvoice.Columns["bk_SaleTaxValue"].Text = "";
c1_grdInvoice.Columns["Quantity"].Text = "0";
c1_grdInvoice.Columns["Bonus"].Text = "0";
c1_grdInvoice.Columns["Discount"].Text = "0.0000";
c1_grdInvoice.Columns["Discount"].Text = "0.0000";
c1_grdInvoice.Columns["Sale Tax"].Text = "0.0000";
c1_grdInvoice.Columns["Total"].Text = "0.0000";
c1_grdInvoice.Columns["CommPer"].Text = "0.0000";
c1_grdInvoice.Columns["Commission"].Text = "0.0000";
UpdateGridFooter();
txtStock.Text = "";
txtBonus.Text = "";
c1_grdInvoice.Col = 0;
c1_grdInvoice.Focus();
}
else
{
c1_grdInvoice.Col = 4;
c1_grdInvoice.Focus();
}
}
}
}
}
else
{
c1_grdInvoice.Col = 0;
c1_grdInvoice.Focus();
}
}
break;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Babar Medicine Company - ERP", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
private void btnFindTerrID_Click(object sender, EventArgs e)
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.WhereClause = null;
obj_pickList.PickListID = "Terrority";
obj_pickList.ReturnFieldName = "TerrorityID";
obj_pickList.ReturnSecondFieldValue = "TerritoryName";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
txtEmployeeId.Text = obj_pickList.ReturnFieldValue;
txtEmployeeName.Text = obj_pickList.ReturnSecondFieldValue;
}
private void txtSaleManId_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F10)
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.WhereClause = null;
obj_pickList.PickListID = "Users";
obj_pickList.ReturnFieldName = "User ID";
obj_pickList.ReturnSecondFieldValue = "UserName";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
txtSaleManId.Text = obj_pickList.ReturnFieldValue;
txtSaleManName.Text = obj_pickList.ReturnSecondFieldValue;
}
}
private void btnSupplierPickList_Click(object sender, EventArgs e)
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.PickListID = "Business Partner";
obj_pickList.ReturnFieldName = "Partner ID";
obj_pickList.ReturnSecondFieldValue = "Partner Name";
obj_pickList.WhereClause = "@WhereClause = Vendors";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
txtSupplierID.Text = obj_pickList.ReturnFieldValue;
txtSupplierName.Text = obj_pickList.ReturnSecondFieldValue;
}
private void grdAgreementDetails_ButtonClick(object sender, C1.Win.C1TrueDBGrid.ColEventArgs e)
{
obj_pickList.WhereClause = null;
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.PickListID = "Products";
obj_pickList.ReturnFieldName = "Product Id";
obj_pickList.ReturnSecondFieldValue = "Product Name";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
if (obj_pickList.ReturnFieldValue != null)
{
grdAgreementDetails.Columns[1].Value = obj_pickList.ReturnFieldValue;
grdAgreementDetails.Columns[2].Value = obj_pickList.ReturnSecondFieldValue;
grdAgreementDetails.Col = 3;
grdAgreementDetails.Focus();
}
}
private void datagridBonus_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == (Keys.F11))
{
datagridBonus.Delete();
}
switch (datagridBonus.Col)
{
case 5:
string type = datagridBonus.Columns["Type"].Value.ToString();
if (e.KeyCode == (Keys.ControlKey))
{
switch (type)
{
case "":
datagridBonus.Columns["Type"].Value = "Bonus";
datagridBonus.Col = 5;
datagridBonus.Focus();
break;
case "Bonus":
datagridBonus.Columns["Type"].Value = "Discount";
datagridBonus.Col = 5;
datagridBonus.Focus();
break;
case "Discount":
datagridBonus.Columns["Type"].Value = "FreeGoods";
datagridBonus.Col = 5;
datagridBonus.Focus();
break;
case "FreeGoods":
datagridBonus.Columns["Type"].Value = "Bonus";
datagridBonus.Col = 5;
datagridBonus.Focus();
break;
}
}
if (e.KeyCode == (Keys.Enter))
{
datagridBonus.Col = 6;
datagridBonus.Focus();
}
break;
case 2:
if (e.KeyCode == (Keys.F10))
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.PickListID = "Products";
obj_pickList.ReturnFieldName = "Product Id";
obj_pickList.ReturnSecondFieldValue = "Product Name";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
//ShowData(obj_pickList.ReturnFieldValue + '-' + GlobalVar.g_BranchCode);
txtProductId.Text = obj_pickList.ReturnFieldValue;
txtProductName.Text = obj_pickList.ReturnSecondFieldValue;
datagridBonus.Columns[2].Value = string.Format("{0:000-000}", Convert.ToInt32(obj_pickList.ReturnFieldValue.ToString()));
datagridBonus.Columns[3].Value = obj_pickList.ReturnSecondFieldValue;
FormatInvDetialGrid();
if (obj_pickList.ReturnFieldValue != null)
{
datagridBonus.Col = 4;
datagridBonus.Focus();
}
}
break;
}
}
//FORM PICK LIS COMPANY GROUP
private void btnPickList_Click(object sender, EventArgs e)
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.PickListID = "Companygroups";
obj_pickList.ReturnFieldName = "Groupid";
//obj_pickList.WhereClause = GlobalVar.g_UserID;
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
ShowData(obj_pickList.ReturnFieldValue);
txtCompanygroupid.Text = obj_pickList.ReturnFieldValue;
}
private void datagridProductAllocation_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == (Keys.F11))
{
datagridProductAllocation.Delete();
}
switch (datagridProductAllocation.Col)
{
case 0:
if (e.KeyCode == (Keys.F10))
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.PickListID = "Terrority";
obj_pickList.ReturnFieldName = "TerrorityID";
obj_pickList.ReturnSecondFieldValue = "TerritoryName";
obj_pickList.WhereClause = GlobalVar.g_UserID;
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
datagridProductAllocation.Columns["TerritoryId"].Value = obj_pickList.ReturnFieldValue;
datagridProductAllocation.Columns["Name"].Value = obj_pickList.ReturnSecondFieldValue;
if (obj_pickList.ReturnFieldValue != null)
{
datagridProductAllocation.Col = 2;
datagridProductAllocation.Focus();
}
}
break;
}
}
public void PicklistData()
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.PickListID = "Modules List";
obj_pickList.ReturnFieldName = "Module ID";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
ShowData(obj_pickList.ReturnFieldValue);
}
private void btnIntimationPickList_Click(object sender, EventArgs e)
{
obj_mdlPickList.WhereClause = null;
frmPickList pickList = new frmPickList(obj_mdlPickList);
obj_mdlPickList.PickListID = "Intimation";
obj_mdlPickList.ReturnFieldName = "Voucher ID";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
if (obj_mdlPickList.ReturnFieldValue != null)
{
ShowData(obj_mdlPickList.ReturnFieldValue);
}
}
private void PicListData()
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.PickListID = "Terrority";
obj_pickList.ReturnFieldName = "TerrorityID";
obj_pickList.ReturnSecondFieldValue = "TerritoryName";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
ShowData(obj_pickList.ReturnFieldValue);
}
private void PickListTender()
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.PickListID = "Tender Document";
obj_pickList.ReturnFieldName = "DocId";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
ShowData(obj_pickList.ReturnFieldValue);
}
private void PickListsForGrid(string PickListID, string ReturnField, string Second, string Third, string Fourth, C1DataColumnCollection Col, int IdIndex, int FocusIndex, string WhereClause)
{
obj_mdlPickList.WhereClause = null;
frmPickList pickList = new frmPickList(obj_mdlPickList);
obj_mdlPickList.PickListID = PickListID;
obj_mdlPickList.ReturnFieldName = ReturnField;
obj_mdlPickList.ReturnSecondFieldValue = Second;
obj_mdlPickList.ReturnThirdFieldValue = Third;
obj_mdlPickList.ReturnFourthFieldValue = Fourth;
if (WhereClause != "")
{
obj_mdlPickList.WhereClause = WhereClause;
}
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
if (obj_mdlPickList.ReturnFieldValue != null)
{
Col[IdIndex].Value = obj_mdlPickList.ReturnFieldValue;
Col[IdIndex + 1].Value = obj_mdlPickList.ReturnSecondFieldValue;
if (Third != "" && Fourth != "")
{
Col[FocusIndex - 3].Value = obj_mdlPickList.ReturnSecondFieldValue;
Col[FocusIndex - 2].Value = obj_mdlPickList.ReturnThirdFieldValue;
Col[FocusIndex - 1].Value = obj_mdlPickList.ReturnFourthFieldValue;
}
//grdOrderDetails.Col = FocusIndex;
//grdOrderDetails.Focus();
}
}
private void PickListTown()
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.PickListID = "Town";
obj_pickList.ReturnFieldName = "TownID";
obj_pickList.ReturnSecondFieldValue = "TownName";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
if (obj_pickList.ReturnFieldValue == null) return;
txtTownID.Text = obj_pickList.ReturnFieldValue;
txtTownName.Text = obj_pickList.ReturnSecondFieldValue;
txtTerritoryID.Focus();
}
private void PickListCustomer()
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.WhereClause = "Customers";
obj_pickList.PickListID = "Business Partner";
obj_pickList.ReturnFieldName = "Partner ID";
obj_pickList.ReturnSecondFieldValue = "Partner Name";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
if (obj_pickList.ReturnFieldValue == null) return;
txtCustomerId.Text = obj_pickList.ReturnFieldValue;
txtCustomerName.Text = obj_pickList.ReturnSecondFieldValue;
txtContactPersonId.Focus();
}
private void btnDocFinder_Click(object sender, EventArgs e)
{
obj_pickList.WhereClause = null;
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.PickListID = "Agreements";
obj_pickList.ReturnFieldName = "Doc No";
obj_pickList.WhereClause = " @Draft = 0 , @FY= " + cmbFY.Text + "";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
if (obj_pickList.ReturnFieldValue != null)
{
ds_Agreements = obj_bllAgreement.SelectAgreementByID(txtDocNo.Text, false, cmbFY.Text);
cmbStatus.Text = ds_Agreements.Tables[0].Columns["Status"].ToString();
mskDocDate.Text = ds_Agreements.Tables[0].Columns["DocDate"].ToString();
mskPostingDate.Text = ds_Agreements.Tables[0].Columns["PostDate"].ToString();
chkOneTime.Checked = Convert.ToBoolean(ds_Agreements.Tables[0].Columns["OneTime"].ToString());
txtSupplierID.Text = ds_Agreements.Tables[0].Columns["BPID"].ToString();
txtRefNo.Text = ds_Agreements.Tables[0].Columns["RefNo"].ToString();
mskCompanyDate.Text = ds_Agreements.Tables[0].Columns["Date"].ToString();
txtCustomerID.Text = ds_Agreements.Tables[0].Columns["CustomerID"].ToString();
mskStartDate.Text = ds_Agreements.Tables[0].Columns["StartDate"].ToString();
mskEndDate.Text = ds_Agreements.Tables[0].Columns["EndDate"].ToString();
txtRemarks.Text = ds_Agreements.Tables[0].Columns["Remarks"].ToString();
ds_Agreements = obj_bllAgreement.FillAgreementGrid(txtDocNo.Text, false, cmbFY.Text);
grdAgreementDetails.DataSource = ds_Agreements.Tables[0];
grdAgreementDetails.Focus();
}
}
private void PickListVender()
{
if (cmbBusinessType.Text != "")
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.WhereClause = cmbBusinessType.Text;
obj_pickList.PickListID = "Business Partner";
obj_pickList.ReturnFieldName = "Partner ID";
obj_pickList.ReturnSecondFieldValue = "Partner Name";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
if (obj_pickList.ReturnFieldValue == null) return;
txtVendorId.Text = obj_pickList.ReturnFieldValue;
txtVenderName.Text = obj_pickList.ReturnSecondFieldValue;
txtCustomerId.Focus();
}
else
{
MessageBox.Show("Please select Business Type", "Babar Medicine Company - ERP", MessageBoxButtons.OK, MessageBoxIcon.Error);
cmbBusinessType.Focus();
}
}
private void btnFindInvoiceID_Click(object sender, EventArgs e)
{
frmPickList pickList = new frmPickList(obj_pickList);
obj_pickList.WhereClause = "@DSSId= " + obj_mdlSaleInvoice.DSSID + ",@OCGroupId= " + obj_mdlSaleInvoice.OCGroupID + "";
obj_pickList.PickListID = "Sale Invoice";
obj_pickList.ReturnFieldName = "Invoice Id";
obj_pickList.ReturnSecondFieldValue = "InvoiceDate";
GlobalVar.g_pickListMultiSelection = false;
pickList.ShowDialog();
txtInvoiceId.Text = obj_pickList.ReturnFieldValue;
DataSet ds_LoadInvoiceDetail = new DataSet();
ds_LoadInvoiceDetail = obj_bllSaleInvoice.FindSaleInvoice(obj_mdlSaleInvoice, txtInvoiceId.Text);
ds_InvoiceDetail = ds_LoadInvoiceDetail;
txtBrickID.Text = obj_mdlSaleInvoice.BrickId;
txtBrickName.Text = obj_mdlSaleInvoice.BrickName;
SaleInvoiceMode = obj_mdlSaleInvoice.SaleInvoiceMode;
mskInvoiceDate.Text=obj_mdlSaleInvoice.InvoiceDate.ToString() ;
txtCustomerId.Text=obj_mdlSaleInvoice.CustomerId ;
txtCustomerName.Text = obj_mdlSaleInvoice.CustomerName;
txtEmployeeId.Text= obj_mdlSaleInvoice.TerritoryId ;
txtEmployeeName.Text = obj_mdlSaleInvoice.TerritoryName;
txtSaleManId.Text= obj_mdlSaleInvoice.SalesManID ;
txtSaleManName.Text = obj_mdlSaleInvoice.SalesManName;
txtDelManId.Text= obj_mdlSaleInvoice.PatientId ;
txtDelManName.Text = obj_mdlSaleInvoice.PatientName;
mskDueDate.Text = obj_mdlSaleInvoice.DueDate.ToString();
txtGrossAmt.Text=obj_mdlSaleInvoice.GrossAmount ;
txtDiscount.Text=obj_mdlSaleInvoice.Discount ;
txtSaleTax.Text= obj_mdlSaleInvoice.SaleTax ;
txtNetAmount.Text=obj_mdlSaleInvoice.NetAmount ;
txtRemarks.Text=obj_mdlSaleInvoice.Remarks ;
txtRefNo.Text=obj_mdlSaleInvoice.RefNo ;
SaleInvoiceMode = "N";
obj_mdlSaleInvoice.SaleInvoiceMode="N";
obj_mdlSaleInvoice.RefDate=obj_mdlSaleInvoice.RefDate ;
//c1_grdInvoice.DataSource = ds_InvoiceDetail.Tables[0];
g_FormMode = gc_NavigationMode;
Ls_SetFormMode();
FormatInvDetialGrid();
txtInvoiceId.Focus();
}
