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