/// <summary> /// Enables objects of other forms on form closing /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void frmPersonalReminder_FormClosing(object sender, FormClosingEventArgs e) { try { if (frmReminderPopupObj != null) { frmReminderPopupObj.Enabled = true; frmReminderPopupObj.Activate(); frmReminderPopupObj.BringToFront(); } } catch (Exception ex) { formMDI.infoError.ErrorString = "PREM23:" + ex.Message; } }
/// <summary> /// Enables the objects of other forms on form closing /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void frmStock_FormClosing(object sender, FormClosingEventArgs e) { try { if (frmReminderPopupObj != null) { frmReminderPopupObj.Enabled = true; frmReminderPopupObj.Activate(); frmReminderPopupObj.BringToFront(); } } catch (Exception ex) { MessageBox.Show("ST:21" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Enable sobject of other forms on form closing /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void frmOverduePurchaseOrder_FormClosing(object sender, FormClosingEventArgs e) { try { if (frmReminderPopupObj != null) { frmReminderPopupObj.Enabled = true; frmReminderPopupObj.Activate(); frmReminderPopupObj.BringToFront(); } } catch (Exception ex) { formMDI.infoError.ErrorString = "ODPO:7" + ex.Message; } }
/// <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); } }
/// <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; DataTable dtbl = new DataTable(); ReminderSP SpReminder = new ReminderSP(); if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmOverduePurchaseOrder", "View")) { PurchaseOrderMasterSP SpPurchaseOrderMaster = new PurchaseOrderMasterSP(); dtbl = SpPurchaseOrderMaster.PurchaseOrderOverDueReminder(PublicVariables._dtFromDate, PublicVariables._dtToDate, "Due", PublicVariables._dtCurrentDate, "All"); if (dtbl.Rows.Count > 0) { if (dtbl.Rows.Count == 1) Purchasereminder = Purchasereminder + "1 Overdue purchase order\n\n"; else Purchasereminder = Purchasereminder + dtbl.Rows.Count + " Overdue purchase orders\n\n"; } } if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmOverdueSalesOrder", "View")) { SalesOrderMasterSP SpSalesOrderMaster = new SalesOrderMasterSP(); dtbl = SpSalesOrderMaster.SalesOrderOverDueReminder(PublicVariables._dtFromDate, PublicVariables._dtToDate, "Due", PublicVariables._dtCurrentDate, "All"); if (dtbl.Rows.Count > 0) { if (dtbl.Rows.Count == 1) Salesreminder = Salesreminder + "1 Overdue sales order\n\n"; else Salesreminder = Salesreminder + dtbl.Rows.Count + " Overdue sales orders\n\n"; } } 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); dtbl = SpReminder.ReminderSearch(FromDate, ToDate); if (dtbl.Rows.Count > 0) { if (dtbl.Rows.Count == 1) Personalreminder = Personalreminder + "1 personal reminder \n\n"; else Personalreminder = Personalreminder + dtbl.Rows.Count + " Personal reminders\n\n"; } } if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmShortExpiry", "View")) { dtbl = SpReminder.ShortExpiryReminder(0, 0, 0, 0, 0, 0, 0, 0); if (dtbl.Rows.Count > 0) { if (dtbl.Rows.Count == 1) ShortExpiryReminder = ShortExpiryReminder + "1 Product batch is going to expire"; else ShortExpiryReminder = ShortExpiryReminder + dtbl.Rows.Count + " Product batches going to expire"; } } //frmStock if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmStock", "View")) { dtbl = SpReminder.StockSearch(0, 0, 0, 0, 0, 0, 0, 0, "Negative Stock"); if (dtbl.Rows.Count > 0) { if (dtbl.Rows.Count == 1) NegativeStkreminder = NegativeStkreminder + "1 Negative stock product \n\n"; else NegativeStkreminder = NegativeStkreminder + dtbl.Rows.Count + " Negative stock products\n\n"; } dtbl = SpReminder.StockSearch(0, 0, 0, 0, 0, 0, 0, 0, "Minimum Level"); if (dtbl.Rows.Count > 0) { if (dtbl.Rows.Count == 1) MinStkreminder = MinStkreminder + "1 Minimum stock product \n\n"; else MinStkreminder = MinStkreminder + dtbl.Rows.Count + " Minimum stock products \n\n"; } dtbl = SpReminder.StockSearch(0, 0, 0, 0, 0, 0, 0, 0, "Maximum Level"); if (dtbl.Rows.Count > 0) { if (dtbl.Rows.Count == 1) MaxStkreminder = MaxStkreminder + "1 Maximum stock product \n\n"; else MaxStkreminder = MaxStkreminder + dtbl.Rows.Count + " Maximum stock products \n\n"; } dtbl = SpReminder.StockSearch(0, 0, 0, 0, 0, 0, 0, 0, "Reorder Level"); if (dtbl.Rows.Count > 0) { if (dtbl.Rows.Count == 1) ReordrStkreminder = ReordrStkreminder + "1 Reorder Level product \n\n"; else ReordrStkreminder = ReordrStkreminder + dtbl.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); } }
/// <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; DataTable dtbl = new DataTable(); ReminderSP SpReminder = new ReminderSP(); if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmOverduePurchaseOrder", "View")) { PurchaseOrderMasterSP SpPurchaseOrderMaster = new PurchaseOrderMasterSP(); dtbl = SpPurchaseOrderMaster.PurchaseOrderOverDueReminder(PublicVariables._dtFromDate, PublicVariables._dtToDate, "Due", PublicVariables._dtCurrentDate, "All"); if (dtbl.Rows.Count > 0) { if (dtbl.Rows.Count == 1) { Purchasereminder = Purchasereminder + "1 Overdue purchase order\n\n"; } else { Purchasereminder = Purchasereminder + dtbl.Rows.Count + " Overdue purchase orders\n\n"; } } } if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmOverdueSalesOrder", "View")) { SalesOrderMasterSP SpSalesOrderMaster = new SalesOrderMasterSP(); dtbl = SpSalesOrderMaster.SalesOrderOverDueReminder(PublicVariables._dtFromDate, PublicVariables._dtToDate, "Due", PublicVariables._dtCurrentDate, "All"); if (dtbl.Rows.Count > 0) { if (dtbl.Rows.Count == 1) { Salesreminder = Salesreminder + "1 Overdue sales order\n\n"; } else { Salesreminder = Salesreminder + dtbl.Rows.Count + " Overdue sales orders\n\n"; } } } 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); dtbl = SpReminder.ReminderSearch(FromDate, ToDate); if (dtbl.Rows.Count > 0) { if (dtbl.Rows.Count == 1) { Personalreminder = Personalreminder + "1 personal reminder \n\n"; } else { Personalreminder = Personalreminder + dtbl.Rows.Count + " Personal reminders\n\n"; } } } if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmShortExpiry", "View")) { dtbl = SpReminder.ShortExpiryReminder(0, 0, 0, 0, 0, 0, 0, 0); if (dtbl.Rows.Count > 0) { if (dtbl.Rows.Count == 1) { ShortExpiryReminder = ShortExpiryReminder + "1 Product batch is going to expire"; } else { ShortExpiryReminder = ShortExpiryReminder + dtbl.Rows.Count + " Product batches going to expire"; } } } //frmStock if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, "frmStock", "View")) { dtbl = SpReminder.StockSearch(0, 0, 0, 0, 0, 0, 0, 0, "Negative Stock"); if (dtbl.Rows.Count > 0) { if (dtbl.Rows.Count == 1) { NegativeStkreminder = NegativeStkreminder + "1 Negative stock product \n\n"; } else { NegativeStkreminder = NegativeStkreminder + dtbl.Rows.Count + " Negative stock products\n\n"; } } dtbl = SpReminder.StockSearch(0, 0, 0, 0, 0, 0, 0, 0, "Minimum Level"); if (dtbl.Rows.Count > 0) { if (dtbl.Rows.Count == 1) { MinStkreminder = MinStkreminder + "1 Minimum stock product \n\n"; } else { MinStkreminder = MinStkreminder + dtbl.Rows.Count + " Minimum stock products \n\n"; } } dtbl = SpReminder.StockSearch(0, 0, 0, 0, 0, 0, 0, 0, "Maximum Level"); if (dtbl.Rows.Count > 0) { if (dtbl.Rows.Count == 1) { MaxStkreminder = MaxStkreminder + "1 Maximum stock product \n\n"; } else { MaxStkreminder = MaxStkreminder + dtbl.Rows.Count + " Maximum stock products \n\n"; } } dtbl = SpReminder.StockSearch(0, 0, 0, 0, 0, 0, 0, 0, "Reorder Level"); if (dtbl.Rows.Count > 0) { if (dtbl.Rows.Count == 1) { ReordrStkreminder = ReordrStkreminder + "1 Reorder Level product \n\n"; } else { ReordrStkreminder = ReordrStkreminder + dtbl.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) { formMDI.infoError.ErrorString = "CCD 13: " + ex.Message; } }