/// <summary> /// Function to fill Datagridview /// </summary> public void GridFill() { try { DataTable dtblPurchaseOrderRegister = new DataTable(); PurchaseOrderMasterSP spPurchaseOrderMaster = new PurchaseOrderMasterSP(); 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; dtblPurchaseOrderRegister = spPurchaseOrderMaster.PurchaseOrderMasterViewAll(strInvoiceNo, decLedgerId, FromDate, ToDate, strCondition); dgvPurchaseOrderRegister.DataSource = dtblPurchaseOrderRegister; 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); } }
public void PurchaseOrderMasterEdit(PurchaseOrderMasterInfo purchaseordermasterinfo) { PurchaseOrderMasterSP SPPurchaseOrderMaster = new PurchaseOrderMasterSP(); try { SPPurchaseOrderMaster.PurchaseOrderMasterEdit(purchaseordermasterinfo); } catch (Exception ex) { MessageBox.Show("PoBll 19:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public void PurchaseOrderCancel(decimal decOrderMasterId) { PurchaseOrderMasterSP SPPurchaseOrderMaster = new PurchaseOrderMasterSP(); try { SPPurchaseOrderMaster.PurchaseOrderCancel(decOrderMasterId); } catch (Exception ex) { MessageBox.Show("PoBll 12:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public DataSet PurchaseOrderReportPrinting(decimal decCompanyId, string strInvoiceNo, decimal decLedgerId, decimal decVouchertypeId, DateTime FromDate, DateTime ToDate, string strStatus) { DataSet ds = new DataSet(); PurchaseOrderMasterSP SPPurchaseOrderMaster = new PurchaseOrderMasterSP(); try { ds = SPPurchaseOrderMaster.PurchaseOrderReportPrinting(decCompanyId, strInvoiceNo, decLedgerId, decVouchertypeId, FromDate, ToDate, strStatus); } catch (Exception ex) { MessageBox.Show("PoBll 24:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(ds); }
public decimal ExchangeRateIdByCurrencyId(decimal decCurrencyId) { PurchaseOrderMasterSP SPPurchaseOrderMaster = new PurchaseOrderMasterSP(); decimal decCount = 0; try { decCount = SPPurchaseOrderMaster.ExchangeRateIdByCurrencyId(decCurrencyId); } catch (Exception ex) { MessageBox.Show("PoBll 23:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(decCount); }
public List <DataTable> PurchaseOrderOverDueReminder(DateTime FromDate, DateTime ToDate, string strCondition, DateTime dueOn, string decLedgerId) { PurchaseOrderMasterSP SPPurchaseOrderMaster = new PurchaseOrderMasterSP(); List <DataTable> ListObj = new List <DataTable>(); try { ListObj = SPPurchaseOrderMaster.PurchaseOrderOverDueReminder(FromDate, ToDate, strCondition, dueOn, decLedgerId); } catch (Exception ex) { MessageBox.Show("PoBll 22:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(ListObj); }
public decimal PurchaseOrderMasterAdd(PurchaseOrderMasterInfo purchaseordermasterinfo) { PurchaseOrderMasterSP SPPurchaseOrderMaster = new PurchaseOrderMasterSP(); decimal decIdentity = 0; try { decIdentity = SPPurchaseOrderMaster.PurchaseOrderMasterAdd(purchaseordermasterinfo); } catch (Exception ex) { MessageBox.Show("PoBll 21:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(decIdentity); }
public List <DataTable> PurchaseOrderMasterViewByOrderMasterId(decimal decOrderMasterId) { PurchaseOrderMasterSP SPPurchaseOrderMaster = new PurchaseOrderMasterSP(); List <DataTable> ListObj = new List <DataTable>(); try { ListObj = SPPurchaseOrderMaster.PurchaseOrderMasterViewByOrderMasterId(decOrderMasterId); } catch (Exception ex) { MessageBox.Show("PoBll 11:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(ListObj); }
public bool PurchaseOrderNumberCheckExistence(string strinvoiceNo, decimal decPurchaseorderMasterId, decimal decVoucherTypeId) { PurchaseOrderMasterSP SPPurchaseOrderMaster = new PurchaseOrderMasterSP(); bool isEdit = false; try { isEdit = SPPurchaseOrderMaster.PurchaseOrderNumberCheckExistence(strinvoiceNo, decPurchaseorderMasterId, decVoucherTypeId); } catch (Exception ex) { MessageBox.Show("PoBll 18:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(isEdit); }
public decimal PurchaseOrderMasterDelete(decimal PurchaseOrderMasterId) { PurchaseOrderMasterSP SPPurchaseOrderMaster = new PurchaseOrderMasterSP(); decimal decResult = 0; try { decResult = SPPurchaseOrderMaster.PurchaseOrderMasterDelete(PurchaseOrderMasterId); } catch (Exception ex) { MessageBox.Show("PoBll 17:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(decResult); }
public DataSet PurchaseOrderPrinting(decimal decPurcahseOrderMasterId) { DataSet ds = new DataSet(); PurchaseOrderMasterSP SPPurchaseOrderMaster = new PurchaseOrderMasterSP(); try { ds = SPPurchaseOrderMaster.PurchaseOrderPrinting(decPurcahseOrderMasterId); } catch (Exception ex) { MessageBox.Show("PoBll 16:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(ds); }
public decimal DueDays(DateTime dtStartDate, DateTime dtEndDate) { PurchaseOrderMasterSP SPPurchaseOrderMaster = new PurchaseOrderMasterSP(); decimal decDueDays = 0; try { decDueDays = SPPurchaseOrderMaster.DueDays(dtStartDate, dtEndDate); } catch (Exception ex) { MessageBox.Show("PoBll 15:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(decDueDays); }
public bool PurchaseOrderCancelCheckStatus(decimal decVoucherTypeId) { PurchaseOrderMasterSP SPPurchaseOrderMaster = new PurchaseOrderMasterSP(); bool isTrue = false; try { isTrue = SPPurchaseOrderMaster.PurchaseOrderCancelCheckStatus(decVoucherTypeId); } catch (Exception ex) { MessageBox.Show("PoBll 13:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(isTrue); }
public List <DataTable> PurchaseOrdeReportViewAll(string strInvoiceNo, decimal decLedgerId, decimal decVouchertypeId, DateTime FromDate, DateTime ToDate, string strStatus) { PurchaseOrderMasterSP SPPurchaseOrderMaster = new PurchaseOrderMasterSP(); List <DataTable> ListObj = new List <DataTable>(); try { ListObj = SPPurchaseOrderMaster.PurchaseOrdeReportViewAll(strInvoiceNo, decLedgerId, decVouchertypeId, FromDate, ToDate, strStatus); } catch (Exception ex) { MessageBox.Show("PoBll 26:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(ListObj); }
public string VoucherNoMax(decimal decVoucherTypeId) { PurchaseOrderMasterSP SPPurchaseOrderMaster = new PurchaseOrderMasterSP(); string max = "0"; try { max = SPPurchaseOrderMaster.VoucherNoMax(decVoucherTypeId); } catch (Exception ex) { MessageBox.Show("PoBll 20:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(max); }
public PurchaseOrderMasterInfo PurchaseOrderMasterView(decimal purchaseOrderMasterId) { PurchaseOrderMasterInfo purchaseordermasterinfo = new PurchaseOrderMasterInfo(); PurchaseOrderMasterSP SPPurchaseOrderMaster = new PurchaseOrderMasterSP(); try { purchaseordermasterinfo = SPPurchaseOrderMaster.PurchaseOrderMasterView(purchaseOrderMasterId); } catch (Exception ex) { MessageBox.Show("PoBll 1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(purchaseordermasterinfo); }
/// <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) { PurchaseOrderMasterSP spPurchaseOrderMaster = new PurchaseOrderMasterSP(); DataSet dsPurchaseOrderReport = spPurchaseOrderMaster.PurchaseOrderReportPrinting(1, strInvoiceNo, decLedgerId, decVoucherTypeId, this.dtpFromDate.Value, this.dtpToDate.Value, strStatus); frmReport frmRepor = new frmReport(); frmRepor.MdiParent = formMDI.MDIObj; frmRepor.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> /// 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> /// Function to fill gridview /// </summary> public void GridFill() { try { PurchaseOrderMasterSP spPurchaseOrderMaster = new PurchaseOrderMasterSP(); 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; dtblPurchaseOrderRegister = spPurchaseOrderMaster.PurchaseOrdeReportViewAll(strInvoiceNo, decLedgerId, decVoucherTypeId, FromDate, ToDate, strStatus); if (dtblPurchaseOrderRegister.Rows.Count > 0) { decimal decTotal = 0; for (int i = 0; i < dtblPurchaseOrderRegister.Rows.Count; i++) { if (dtblPurchaseOrderRegister.Rows[i]["totalAmount"].ToString() != null) { decTotal = decTotal + Convert.ToDecimal(dtblPurchaseOrderRegister.Rows[i]["totalAmount"].ToString()); } } decTotal = Math.Round(decTotal, 2); txtTotalAmount.Text = decTotal.ToString(); } else { txtTotalAmount.Text = "0.00"; } dgvPurchaseOrderReport.DataSource = dtblPurchaseOrderRegister; 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); } }