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