/// <summary>
/// Function to fill Datagridview
/// </summary>
public void gridfill()
{
try
{
DataTable dtbl = new DataTable();
string strCriteria = string.Empty;
if (rbtnAll.Checked)
{
strCriteria = "All";
}
if (rbtnMax.Checked)
{
strCriteria = "Maximum Level";
}
if (rbtnMin.Checked)
{
strCriteria = "Minimum Level";
}
if (rbtnNegativestock.Checked)
{
strCriteria = "Negative Stock";
}
if (rbtnReorder.Checked)
{
strCriteria = "Reorder Level";
}
ReminderSP SpRemainder = new ReminderSP();
dtbl = SpRemainder.StockSearch(Convert.ToDecimal(cmbGroup.SelectedValue),
Convert.ToDecimal(cmbProduct.SelectedValue), Convert.ToDecimal(cmbBrand.SelectedValue),
Convert.ToDecimal(cmbSize.SelectedValue), Convert.ToDecimal(cmbModelNo.SelectedValue),
Convert.ToDecimal(cmbTax.SelectedValue), Convert.ToDecimal(cmbGodown.SelectedValue),
Convert.ToDecimal(cmbRack.SelectedValue), strCriteria);
dgvStock.DataSource = dtbl;
}
catch (Exception ex)
{
MessageBox.Show("ST:11" + 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;
}
}
/// <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 Datagridview
/// </summary>
public void gridfill()
{
try
{
DataTable dtbl = new DataTable();
string strCriteria = string.Empty;
if (rbtnAll.Checked)
{
strCriteria = "All";
}
if (rbtnMax.Checked)
{
strCriteria = "Maximum Level";
}
if (rbtnMin.Checked)
{
strCriteria = "Minimum Level";
}
if (rbtnNegativestock.Checked)
{
strCriteria = "Negative Stock";
}
if (rbtnReorder.Checked)
{
strCriteria = "Reorder Level";
}
ReminderSP SpRemainder = new ReminderSP();
dtbl = SpRemainder.StockSearch(Convert.ToDecimal(cmbGroup.SelectedValue),
Convert.ToDecimal(cmbProduct.SelectedValue), Convert.ToDecimal(cmbBrand.SelectedValue),
Convert.ToDecimal(cmbSize.SelectedValue), Convert.ToDecimal(cmbModelNo.SelectedValue),
Convert.ToDecimal(cmbTax.SelectedValue), Convert.ToDecimal(cmbGodown.SelectedValue),
Convert.ToDecimal(cmbRack.SelectedValue), strCriteria);
dgvStock.DataSource = dtbl;
}
catch (Exception ex)
{
MessageBox.Show("ST:11" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}