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