private void LoadForm(string Id) { DataTable dt = new DataTable(); try { dt = PurchaseOrderBll.GetProductsToReceive("ByQuotation", Id); foreach (DataRow dr in dt.Rows) { txtPOrderNo.Text = dr["PrOrderNo"].ToString(); hdnSupCode.Value = dr["SupplierCode"].ToString(); txtSupplier.Text = dr["SupplierName"].ToString(); HiddenProductGroup.Value = dr["GroupId"].ToString(); txtProduct.Text = dr["ProductName"].ToString(); txtUnit.Text = dr["UnitName"].ToString(); txtBrand.Text = dr["Brand"].ToString(); //txtBalQTY.Text = dr["BalQty"].ToString(); txtOrderQTY.Text = dr["OrderedQty"].ToString(); hdnBarCode.Value = dr["BarCode"].ToString(); txtChalanNo.Text = rChallanBll.GetNewRChalanNo(dr["SupplierCode"].ToString(), DateTime.Parse((txtDate.Text))); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
protected void BtnApprove_Click(object sender, EventArgs e) { if (ddlPurchaseOrder.SelectedValue != "0") { List <string> Ids = new List <string>(); foreach (DataRow dr in stdtApproved.Rows) { Ids.Add(dr["Id"].ToString()); } if (Ids.Count > 0) { if (PurchaseOrderBll.ApprovePurchaseOrder(Ids)) { lblMessage.Text = "<font color='green'>Purchase Requisition Order " + ddlPurchaseOrder.SelectedValue + " has been approved successfully!</font>"; PurchaseOrderBll.MailToAllEnlistedSupplier(Ids); stdtApproved.Rows.Clear(); grdApproved.DataSource = stdtApproved; grdApproved.DataBind(); } else { lblMessage.Text = "<font color='red'>Error in approving purchase requisition order!</font"; } //MailToAllEnlistedSupplier } else { // please select ... } } }
private void LoadPendingOrdersToApprove() { stdtToApprove = PurchaseOrderBll.GetPurchaseOrderProducts(ddlPurchaseOrder.SelectedValue); grdPurchaseOrderToApprove.DataSource = stdtToApprove; grdPurchaseOrderToApprove.DataBind(); stdtApproved = stdtToApprove.Clone(); }
private void LoadProducts(string PrOrderNo) { ddlProduct.DataSource = PurchaseOrderBll.GetUnGivenProducts(PrOrderNo); ddlProduct.DataValueField = "BarCode"; ddlProduct.DataTextField = "ProductName"; ddlProduct.DataBind(); ddlProduct.Items.Insert(0, new ListItem("Select One", "0")); }
private void FillPurchaseOrder() { ddlPurchaseOrder.DataSource = PurchaseOrderBll.GetPurchaseOrderList(); ddlPurchaseOrder.DataValueField = "PrOrderNo"; ddlPurchaseOrder.DataTextField = "PrOrderNo"; ddlPurchaseOrder.DataBind(); ddlPurchaseOrder.Items.Insert(0, new ListItem("Select One", "0")); }
protected void ddlProduct_SelectedIndexChanged(object sender, EventArgs e) { string BarCode = ddlProduct.SelectedValue; string PrOrderNo = ddlPurchaseOrder.SelectedValue; string SupCode = ddlSupplier.SelectedValue; SetQuotationNo(PrOrderNo, BarCode, SupCode); txtOrderedQty.Text = PurchaseOrderBll.GetSelectedProduct(PrOrderNo, BarCode); }
protected void txtOrderDate_TextChanged(object sender, EventArgs e) { DateTime date = DateTime.Today; try { date = DateTime.Parse(txtOrderDate.Text); } catch { } txtOrderNo.Text = PurchaseOrderBll.GetNewPurchaseOrderNo(date); }
/// <summary> /// Function to fill Datagridview /// </summary> public void GridFill() { PurchaseOrderBll BllPurchaseOrder = new PurchaseOrderBll(); try { List <DataTable> ListObjPurchaseOrderRegister = new List <DataTable>(); if (txtOrderNo.Text.Trim() == string.Empty) { strInvoiceNo = string.Empty; } else { strInvoiceNo = txtOrderNo.Text; } if (cmbCashOrParty.SelectedIndex == 0 || cmbCashOrParty.SelectedIndex == -1) { decLedgerId = -1; } else { decLedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()); } if (rbtnAll.Checked) { strCondition = "All"; } if (rbtnPendingOrder.Checked) { strCondition = "Pending"; } if (rbtnOverdue.Checked) { strCondition = "Due"; } if (rbtnCancelled.Checked) { strCondition = "Cancelled"; } DateTime FromDate = this.dtpFromDate.Value; DateTime ToDate = this.dtpToDate.Value; ListObjPurchaseOrderRegister = BllPurchaseOrder.PurchaseOrderMasterViewAll(strInvoiceNo, decLedgerId, FromDate, ToDate, strCondition); dgvPurchaseOrderRegister.DataSource = ListObjPurchaseOrderRegister[0]; if (dgvPurchaseOrderRegister.Columns.Count > 0) { dgvPurchaseOrderRegister.Columns["dgvtxtBillAmount"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; } } catch (Exception ex) { MessageBox.Show("POREG2:" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //loadDatagrid(); FillProductsToPurchase("Consumable Product"); //CleargrdProductToPurchaseSelected(); // FillProductGroup(); txtOrderDate.Text = DateTime.Today.ToShortDateString(); txtOrderNo.Text = PurchaseOrderBll.GetNewPurchaseOrderNo(DateTime.Today); } }
private string GetChalanNo(string Id) { DataTable dt = new DataTable(); string ChalanNO = ""; dt = PurchaseOrderBll.GetProductsToReceive("ByQuotation", Id); foreach (DataRow dr in dt.Rows) { hdnBarCode.Value = dr["BarCode"].ToString(); ChalanNO = rChallanBll.GetNewRChalanNo(dr["SupplierCode"].ToString(), DateTime.Now); } return(ChalanNO); }
private void FillPurchaseOrder() { DataTable dt = new DataTable(); dt = PurchaseOrderBll.GetPurchaseOrderToApproveList(); grdPendingPurchaseOrders.DataSource = dt; grdPendingPurchaseOrders.DataBind(); ddlPurchaseOrder.DataSource = dt; ddlPurchaseOrder.DataValueField = "PrOrderNo"; ddlPurchaseOrder.DataTextField = "PrOrderNo"; ddlPurchaseOrder.DataBind(); ddlPurchaseOrder.Items.Insert(0, new ListItem("Select One", "0")); }
//private void CleargrdProductToPurchaseSelected() //{ // grdProductToPurchaseSelected.DataSource = null; // grdProductToPurchaseSelected.DataBind(); //} //private void loadDatagrid() //{ // String strConnString = ConfigurationManager.ConnectionStrings["ERPSSLADO"].ConnectionString; // SqlConnection con = new SqlConnection(strConnString); // SqlCommand cmd = new SqlCommand(); // cmd.CommandType = CommandType.StoredProcedure; // cmd.CommandText = "PRQ_GetRequisitionProducts"; // cmd.Parameters.Add("@AssetType", SqlDbType.VarChar).Value = ddlGoodsType.Text.Trim(); // cmd.Parameters.Add("@Type", SqlDbType.VarChar).Value = "Combined"; // cmd.Connection = con; // SqlDataAdapter da = new SqlDataAdapter(cmd); // DataTable dt = new DataTable(); // da.Fill(dt); // try // { // con.Open(); // //grdProductToPurchase.EmptyDataText = "No Records Found"; // grdProductToPurchase.DataSource = dt; // grdProductToPurchase.DataBind(); // } // catch (Exception ex) // { // throw ex; // } // finally // { // con.Close(); // con.Dispose(); // } //} private void FillProductsToPurchase(string AssetType) { DataTable dt = PurchaseOrderBll.GetRequisitionProducts("Combined", AssetType); if (dt.Rows.Count > 0) { staticDt = dt; staticDtSelected = staticDt.Clone(); grdProductToPurchase.DataSource = dt; grdProductToPurchase.DataBind(); } else { //lblMessage.Text = "<font color='red'>No Record Found</font>"; } }
/// <summary> /// Function to fill VoucherType combo box /// </summary> public void VoucherTypeCombofill() { PurchaseOrderBll BllPurchaseOrder = new PurchaseOrderBll(); try { ListObj = BllPurchaseOrder.VoucherTypeCombofillforPurchaseOrderReport(); cmbVoucherType.DataSource = ListObj[0]; cmbVoucherType.ValueMember = "voucherTypeId"; cmbVoucherType.DisplayMember = "voucherTypeName"; cmbVoucherType.SelectedIndex = 0; } catch (Exception ex) { MessageBox.Show("PORP:3" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
protected void btnWorkOrderDone_Click(object sender, EventArgs e) { if (QuotationBll.CompleteWorkOrder(ddlPurchaseOrder.SelectedValue, ddlSupplier.SelectedValue, ddlProduct.SelectedValue, txtRemarks.Text)) { btnWorkOrderDone.Visible = false; DataTable dt3 = PurchaseOrderBll.GetPurchaseOrderProducts(ddlPurchaseOrder.SelectedValue); if (PurchaseOrderBll.MailToSupplier(ddlSupplier.SelectedValue, ddlPurchaseOrder.SelectedValue, dt3)) { } lblWorkOrder.Text = "<font color='green'>Work order has been given to this supplier.</font>"; FillPurchaseOrder(); } else { lblWorkOrder.Text = "<font color='red'>Error in generating work order!.</font>"; } }
protected void BtnPurchaseByQuotation_Click(object sender, EventArgs e) { try { GridViewRow row = grdProductToPurchase.Rows[grdProductToPurchase.SelectedIndex]; string Id = row.Cells[1].Text; foreach (DataRow dr in staticDt.Rows) { try { if (dr["Id"].ToString() == Id) { // Hashtable ht = new Hashtable(); ht.Add("PrOrderNo", txtOrderNo.Text); ht.Add("OrderType", "Combined"); ht.Add("CompanyCode", dr["CompanyCode"].ToString()); ht.Add("ReqNo", ""); ht.Add("ReqQty", dr["ReqQty"].ToString()); ht.Add("OrderQty", dr["PurchaseQty"].ToString()); ht.Add("OrderDate", txtOrderDate.Text); ht.Add("PurchaseType", "ByQuotation"); ht.Add("OCode", ((SessionUser)Session["SessionUser"]).OCode); ht.Add("BarCode", dr["BarCode"].ToString()); DataTable dt = new DataTable(); dt = PurchaseOrderBll.AddNewPurchaseOrder(ht); lblMessage.Text = "<font color='green'>Purchase order has been added successfully!</font>"; // dr.Delete(); } } catch { lblMessage.Text = "<font color='red'>Error in adding purchase order!</font>"; } } grdProductToPurchase.DataSource = staticDt; grdProductToPurchase.DataBind(); } catch { } }
/// <summary> /// On 'Print' button click to print the data /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnPrint_Click(object sender, EventArgs e) { try { if (dgvPurchaseOrderReport.Rows.Count > 0) { PurchaseOrderBll BllPurchaseOrder = new PurchaseOrderBll(); DataSet dsPurchaseOrderReport = BllPurchaseOrder.PurchaseOrderReportPrinting(1, strInvoiceNo, decLedgerId, decVoucherTypeId, this.dtpFromDate.Value, this.dtpToDate.Value, strStatus); frmReport frmReport = new frmReport(); frmReport.MdiParent = formMDI.MDIObj; frmReport.PurchaseOrderReportPrinting(dsPurchaseOrderReport, txtTotalAmount.Text); } else { Messages.InformationMessage("No data found"); } } catch (Exception ex) { MessageBox.Show("PORP:5" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill gridview /// </summary> public void GridFill() { try { PurchaseOrderBll BllPurchaseOrder = new PurchaseOrderBll(); if (txtVoucherNo.Text.Trim() == string.Empty) { strInvoiceNo = "-1"; } else { strInvoiceNo = txtVoucherNo.Text; } if (cmbCashOrParty.SelectedIndex == 0 || cmbCashOrParty.SelectedIndex == -1) { decLedgerId = -1; } else { decLedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()); } if (cmbVoucherType.SelectedIndex == 0 || cmbVoucherType.SelectedIndex == -1) { decVoucherTypeId = -1; } else { decVoucherTypeId = Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString()); } if (cmbStatus.SelectedIndex == 0 || cmbStatus.SelectedIndex == -1) { strStatus = "All"; } else { strStatus = cmbStatus.SelectedItem.ToString(); } DateTime FromDate = this.dtpFromDate.Value; DateTime ToDate = this.dtpToDate.Value; ListObjPurchaseOrderRegister = BllPurchaseOrder.PurchaseOrdeReportViewAll(strInvoiceNo, decLedgerId, decVoucherTypeId, FromDate, ToDate, strStatus); if (ListObjPurchaseOrderRegister[0].Rows.Count > 0) { decimal decTotal = 0; for (int i = 0; i < ListObjPurchaseOrderRegister[0].Rows.Count; i++) { if (ListObjPurchaseOrderRegister[0].Rows[i]["totalAmount"].ToString() != null) { decTotal = decTotal + Convert.ToDecimal(ListObjPurchaseOrderRegister[0].Rows[i]["totalAmount"].ToString()); } } decTotal = Math.Round(decTotal, 2); txtTotalAmount.Text = decTotal.ToString(); } else { txtTotalAmount.Text = "0.00"; } dgvPurchaseOrderReport.DataSource = ListObjPurchaseOrderRegister[0]; if (dgvPurchaseOrderReport.Columns.Count > 0) { dgvPurchaseOrderReport.Columns["dgvtxtTotalAmount"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; } } catch (Exception ex) { MessageBox.Show("PORP:4" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
protected void BtnSave_Click(object sender, EventArgs e) { try { string challanNo = txtChalanNo.Text.Trim(); //string CType = hiddenCompanyType.Value; string CType = "CENTRAL"; if (CType == "CENTRAL") { Inv_BuyCentral buyCentral = buyCentralBll.GetBuyCentralByCompanyAndBarcode(hdnBarCode.Value, ddlCompanyCode.SelectedValue.ToString()); if (buyCentral == null) { // Insert New Inv_BuyCentral newBuyCentral = new Inv_BuyCentral(); newBuyCentral.ChallanNo = txtChalanNo.Text; newBuyCentral.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue); newBuyCentral.CompanyCode = HiddenCompanyCode.Value; newBuyCentral.CompanyName = HiddenCompanyName.Value; newBuyCentral.BarCode = hdnBarCode.Value; newBuyCentral.ProductId = int.Parse(hdnBarCode.Value.ToString()); newBuyCentral.ProductGroup = int.Parse(HiddenProductGroup.Value.ToString()); newBuyCentral.ProductName = txtProduct.Text; newBuyCentral.Brand = txtBrand.Text; //newBuyCentral.StyleSize = rchallan.StyleSize; //newBuyCentral.FloorName = rchallan.FloorName; newBuyCentral.UnitName = txtUnit.Text; newBuyCentral.ReceiveQuantity = Convert.ToInt32(txtRecQty.Text.Trim()); //newBuyCentral.CPU = rchallan.CPU; //newBuyCentral.RPU = rchallan.RPU; //newBuyCentral.ExpireDate = rchallan.ExpireDate; //newBuyCentral.BalanceQuanity = rchallan.BalanceQty; try { newBuyCentral.PurchaseDate = DateTime.Parse(txtDate.Text); } catch { newBuyCentral.PurchaseDate = DateTime.Today; } newBuyCentral.EditDate = DateTime.Now; newBuyCentral.EditUser = ((SessionUser)Session["SessionUser"]).UserId; newBuyCentral.OCode = ((SessionUser)Session["SessionUser"]).OCode; buyCentralBll.Insert(newBuyCentral); } else { buyCentral.BalanceQuanity = buyCentral.BalanceQuanity + Convert.ToInt32(txtRecQty.Text.Trim()); //buyCentral.CPU = rchallan.CPU; //buyCentral.RPU = rchallan.RPU; //buyCentral.ExpireDate = rchallan.ExpireDate; buyCentral.ReceiveQuantity = buyCentral.ReceiveQuantity + Convert.ToInt32(txtRecQty.Text.Trim()); buyCentralBll.Update(buyCentral, Convert.ToInt32(buyCentral.Id)); } Inv_RChallan rchallan = new Inv_RChallan(); rchallan.ChallanNo = txtChalanNo.Text; rchallan.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue); rchallan.CompanyCode = HiddenCompanyCode.Value; rchallan.CompanyName = HiddenCompanyName.Value; rchallan.Barcode = hdnBarCode.Value; rchallan.ProductId = int.Parse(hdnBarCode.Value.ToString()); rchallan.ProductGroup = int.Parse(HiddenProductGroup.Value.ToString()); rchallan.ProductName = txtProduct.Text; rchallan.Brand = txtBrand.Text; //rchallan.StyleSize = rchallan.StyleSize; //rchallan.FloorName = rchallan.FloorName; rchallan.UnitName = txtUnit.Text; rchallan.ReceiveQuantity = Convert.ToInt32(txtRecQty.Text.Trim()); //rchallan.CPU = rchallan.CPU; //rchallan.RPU = rchallan.RPU; //rchallan.ExpireDate = rchallan.ExpireDate; //rchallan.BalanceQuanity = rchallan.BalanceQty; try { rchallan.PurchaseDate = DateTime.Parse(txtDate.Text); } catch { rchallan.PurchaseDate = DateTime.Today; } rchallan.EditDate = DateTime.Now; rchallan.EditUser = ((SessionUser)Session["SessionUser"]).UserId; rchallan.Ocode = ((SessionUser)Session["SessionUser"]).OCode; rChallanBll.Insert(rchallan); PurchaseOrderBll.PurchaseDone(txtPOrderNo.Text); LoadPurchaseOrders(); // lblMessage.Text = "<font color='green'>Purchase information posted successfully</font>"; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information posted successfully')", true); GenerateReport(); ClearForm(); } else // obsolete // hiddenCompanyType = General { Inv_Buy buy = buyBll.GetBuyByCompanyAndBarcode(hdnBarCode.Value, ddlCompanyCode.SelectedValue.ToString()); if (buy == null) { // Insert New Inv_Buy invBuy = new Inv_Buy(); invBuy.ChallanNo = txtChalanNo.Text; invBuy.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue); invBuy.CompanyCode = HiddenCompanyCode.Value; invBuy.CompanyName = HiddenCompanyName.Value; invBuy.BarCode = hdnBarCode.Value; invBuy.ProductId = int.Parse(hdnBarCode.Value.ToString()); invBuy.ProductGroup = int.Parse(HiddenProductGroup.Value.ToString()); invBuy.ProductName = txtProduct.Text; invBuy.Brand = txtBrand.Text; //newBuyCentral.StyleSize = rchallan.StyleSize; //newBuyCentral.FloorName = rchallan.FloorName; invBuy.UnitName = txtUnit.Text; invBuy.ReceiveQuantity = Convert.ToInt32(txtRecQty.Text.Trim()); //newBuyCentral.CPU = rchallan.CPU; //newBuyCentral.RPU = rchallan.RPU; //newBuyCentral.ExpireDate = rchallan.ExpireDate; //newBuyCentral.BalanceQuanity = rchallan.BalanceQty; try { invBuy.PurchaseDate = DateTime.Parse(txtDate.Text); } catch { invBuy.PurchaseDate = DateTime.Today; } invBuy.EditDate = DateTime.Now; invBuy.EditUser = ((SessionUser)Session["SessionUser"]).UserId; invBuy.OCode = ((SessionUser)Session["SessionUser"]).OCode; buyBll.Insert(invBuy); } else { buy.BalanceQuanity = buy.BalanceQuanity + Convert.ToInt32(txtRecQty.Text.Trim()); //buy.CPU = rchallan.CPU; //buy.RPU = rchallan.RPU; //buy.ExpireDate = rchallan.ExpireDate; buy.ReceiveQuantity = buy.ReceiveQuantity + Convert.ToInt32(txtRecQty.Text.Trim()); buyBll.Update(buy, Convert.ToInt32(buy.Id)); } Inv_RChallan rchallan = new Inv_RChallan(); rchallan.ChallanNo = txtChalanNo.Text; rchallan.CompanyId = Convert.ToInt32(ddlCompanyCode.SelectedValue); rchallan.CompanyCode = HiddenCompanyCode.Value; rchallan.CompanyName = HiddenCompanyName.Value; rchallan.Barcode = hdnBarCode.Value; rchallan.ProductId = int.Parse(hdnBarCode.Value.ToString()); rchallan.ProductGroup = int.Parse(HiddenProductGroup.Value.ToString()); rchallan.ProductName = txtProduct.Text; rchallan.Brand = txtBrand.Text; //rchallan.StyleSize = rchallan.StyleSize; //rchallan.FloorName = rchallan.FloorName; rchallan.UnitName = txtUnit.Text; rchallan.ReceiveQuantity = Convert.ToInt32(txtRecQty.Text.Trim()); //rchallan.CPU = rchallan.CPU; //rchallan.RPU = rchallan.RPU; //rchallan.ExpireDate = rchallan.ExpireDate; //rchallan.BalanceQuanity = rchallan.BalanceQty; try { rchallan.PurchaseDate = DateTime.Parse(txtDate.Text); } catch { rchallan.PurchaseDate = DateTime.Today; } rchallan.EditDate = DateTime.Now; rchallan.EditUser = ((SessionUser)Session["SessionUser"]).UserId; rchallan.Ocode = ((SessionUser)Session["SessionUser"]).OCode; rChallanBll.Insert(rchallan); PurchaseOrderBll.PurchaseDone(txtPOrderNo.Text); LoadPurchaseOrders(); //lblMessage.Text = "<font color='green'>Purchase information posted successfully</font>"; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Purchase information posted successfully')", true); } ClearForm(); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
/// <summary> /// Showing Reminder If Any one have /// </summary> public void ShowReminderIfAny() { try { string Purchasereminder = string.Empty; string Salesreminder = string.Empty; string Personalreminder = string.Empty; string NegativeStkreminder = string.Empty; string MinStkreminder = string.Empty; string MaxStkreminder = string.Empty; string ReordrStkreminder = string.Empty; string ShortExpiryReminder = string.Empty; List <DataTable> ListObj = new List <DataTable>(); PurchaseOrderBll BllPurchaseOrder = new PurchaseOrderBll(); if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmOverduePurchaseOrder", "View")) { ListObj = BllPurchaseOrder.PurchaseOrderOverDueReminder(PublicVariables._dtFromDate, PublicVariables._dtToDate, "Due", PublicVariables._dtCurrentDate, "All"); if (ListObj[0].Rows.Count > 0) { if (ListObj[0].Rows.Count == 1) { Purchasereminder = Purchasereminder + "1 Overdue purchase order\n\n"; } else { Purchasereminder = Purchasereminder + ListObj[0].Rows.Count + " Overdue purchase orders\n\n"; } } } SalesOrderBll bllSalesOrder = new SalesOrderBll(); if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmOverdueSalesOrder", "View")) { ListObj = bllSalesOrder.SalesOrderOverDueReminder(PublicVariables._dtFromDate, PublicVariables._dtToDate, "Due", PublicVariables._dtCurrentDate, "All"); if (ListObj[0].Rows.Count > 0) { if (ListObj[0].Rows.Count == 1) { Salesreminder = Salesreminder + "1 Overdue sales order\n\n"; } else { Salesreminder = Salesreminder + ListObj[0].Rows.Count + " Overdue sales orders\n\n"; } } } RemainderBll bllRemainder = new RemainderBll(); if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmPersonalReminder", "Delete") || CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmPersonalReminder", "Update") || CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmPersonalReminder", "Save")) { string FromDate = Convert.ToString(PublicVariables._dtCurrentDate); string ToDate = Convert.ToString(PublicVariables._dtCurrentDate); ListObj = bllRemainder.ReminderSearch(FromDate, ToDate); if (ListObj[0].Rows.Count > 0) { if (ListObj[0].Rows.Count == 1) { Personalreminder = Personalreminder + "1 personal reminder \n\n"; } else { Personalreminder = Personalreminder + ListObj[0].Rows.Count + " Personal reminders\n\n"; } } } if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmShortExpiry", "View")) { ListObj = bllRemainder.ShortExpiryReminder(0, 0, 0, 0, 0, 0, 0, 0); if (ListObj[0].Rows.Count > 0) { if (ListObj[0].Rows.Count == 1) { ShortExpiryReminder = ShortExpiryReminder + "1 Product batch is going to expire"; } else { ShortExpiryReminder = ShortExpiryReminder + ListObj[0].Rows.Count + " Product batches going to expire"; } } } if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmStock", "View")) { ListObj = bllRemainder.StockSearch(0, 0, 0, 0, 0, 0, 0, 0, "Negative Stock"); if (ListObj[0].Rows.Count > 0) { if (ListObj[0].Rows.Count == 1) { NegativeStkreminder = NegativeStkreminder + "1 Negative stock product \n\n"; } else { NegativeStkreminder = NegativeStkreminder + ListObj[0].Rows.Count + " Negative stock products\n\n"; } } ListObj = bllRemainder.StockSearch(0, 0, 0, 0, 0, 0, 0, 0, "Minimum Level"); if (ListObj[0].Rows.Count > 0) { if (ListObj[0].Rows.Count == 1) { MinStkreminder = MinStkreminder + "1 Minimum stock product \n\n"; } else { MinStkreminder = MinStkreminder + ListObj[0].Rows.Count + " Minimum stock products \n\n"; } } ListObj = bllRemainder.StockSearch(0, 0, 0, 0, 0, 0, 0, 0, "Maximum Level"); if (ListObj[0].Rows.Count > 0) { if (ListObj[0].Rows.Count == 1) { MaxStkreminder = MaxStkreminder + "1 Maximum stock product \n\n"; } else { MaxStkreminder = MaxStkreminder + ListObj[0].Rows.Count + " Maximum stock products \n\n"; } } ListObj = bllRemainder.StockSearch(0, 0, 0, 0, 0, 0, 0, 0, "Reorder Level"); if (ListObj[0].Rows.Count > 0) { if (ListObj[0].Rows.Count == 1) { ReordrStkreminder = ReordrStkreminder + "1 Reorder Level product \n\n"; } else { ReordrStkreminder = ReordrStkreminder + ListObj[0].Rows.Count + " Reorder Level products \n\n"; } } } if (Salesreminder.Trim() != string.Empty || Purchasereminder.Trim() != string.Empty || Personalreminder.Trim() != string.Empty || NegativeStkreminder.Trim() != string.Empty || MinStkreminder.Trim() != string.Empty || MaxStkreminder.Trim() != string.Empty || ReordrStkreminder.Trim() != string.Empty) { frmReminderPopUp frmReminder = new frmReminderPopUp(); frmReminderPopUp isOpen = Application.OpenForms["frmReminderPopUp"] as frmReminderPopUp; if (isOpen == null) { frmReminder.WindowState = FormWindowState.Normal; frmReminder.MdiParent = formMDI.MDIObj; frmReminder.BringToFront(); frmReminder.ChangeLabel(Salesreminder, Purchasereminder, Personalreminder, ShortExpiryReminder, NegativeStkreminder, MinStkreminder, MaxStkreminder, ReordrStkreminder); } } } catch (Exception ex) { MessageBox.Show("CCD : 13 " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }