private void LoadReorderLevelData()
{
lvReorderList.Items.Clear();
CReorderLevelBO oReorderLevelBO = new CReorderLevelBO();
CResult oResult = new CResult();
CReorderLevel oReorderLevel = new CReorderLevel();
oResult = oReorderLevelBO.ReadAllReorderLevelData(oReorderLevel);
if (oResult.IsSuccess)
{
foreach (CReorderLevel obj in oResult.Data as ArrayList)
{
ListViewItem oItem = new ListViewItem();
oItem.Text = obj.OID.ToString();
oItem.SubItems.Add(obj.Item_ID).ToString();
oItem.SubItems.Add(obj.Location_ID).ToString();
oItem.SubItems.Add(obj.Branch_Name).ToString();
oItem.SubItems.Add(obj.Item_Name).ToString();
oItem.SubItems.Add(obj.Location_Name).ToString();
oItem.SubItems.Add(obj.Quantity).ToString();
oItem.SubItems.Add(obj.Remarks).ToString();
lvReorderList.Items.Add(oItem);
}
}
else
{
MessageBox.Show(oResult.ErrMsg.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private CReorderLevel GetToSaveData()
{
CReorderLevel oReorderLevel = new CReorderLevel();
oReorderLevel.OID = txtID.Text;
oReorderLevel.Branch_ID = currentBranch.CompBrn_OId.Trim().ToString();
oReorderLevel.Item_ID = cmbItemName.SelectedValue.ToString();
oReorderLevel.Location_ID = cmbLocation.SelectedValue.ToString();
oReorderLevel.Quantity = txtRQTY.Text;
oReorderLevel.Remarks = txtRemarks.Text;
return(oReorderLevel);
}
public CResult Import(CReorderLevel oReorderLevel)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Transaction = oConnManager.BeginTransaction();
try
{
cmd.CommandText = "sp_ReorderLevel_Import";
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@Cust_OID", oReorderLevel.OID);
//cmd.Parameters.AddWithValue("@Cust_Branch", "XXXXX");
cmd.Parameters.AddWithValue("@OID", oReorderLevel.OID);
cmd.Parameters.AddWithValue("@Cust_Branch", oReorderLevel.Branch_ID);
cmd.Parameters.AddWithValue("@ItemID", oReorderLevel.Item_ID);
cmd.Parameters.AddWithValue("@LocationID", oReorderLevel.Location_ID);
cmd.Parameters.AddWithValue("@Quantity", oReorderLevel.Quantity);
cmd.Parameters.AddWithValue("@Remarks", oReorderLevel.Remarks);
cmd.ExecuteNonQuery();
oConnManager.Commit();
oResult.IsSuccess = true;
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult ReadAllReorderLevelData(CReorderLevel oReorderLevel)
{
ArrayList oReorderLevelList = new ArrayList();
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "sp_ReadALLReOrdLvl";
cmd.CommandType = CommandType.StoredProcedure;
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
oReorderLevelList.Add(GetresultoReorderLevel(dr));
}
oResult.Data = oReorderLevelList;
oResult.IsSuccess = true;
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
private CReorderLevel GetresultoReorderLevel(DataRow dr)
{
CReorderLevel oReorderLevel = new CReorderLevel();
oReorderLevel.OID = dr[0].ToString();
oReorderLevel.Branch_Name = dr[8].ToString();
oReorderLevel.Branch_ID = dr["ReOrdLvl_Branch"].ToString();
oReorderLevel.Item_ID = dr[2].ToString();
oReorderLevel.Location_ID = dr[3].ToString();
oReorderLevel.Quantity = dr[4].ToString();
oReorderLevel.Remarks = dr[5].ToString();
oReorderLevel.Item_Name = dr[6].ToString();
oReorderLevel.Location_Name = dr[7].ToString();
return(oReorderLevel);
}
private void AlertForItemShortage()
{
CReorderLevelBO oReorderLevelBO = new CReorderLevelBO();
CResult oResultReorderLevel = new CResult();
CReorderLevel oReorderLevel = new CReorderLevel();
String ItemName = null;
oResultReorderLevel = oReorderLevelBO.ReadAllReorderLevelData(oReorderLevel);
if (oResultReorderLevel.IsSuccess)
{
foreach (CReorderLevel obj in oResultReorderLevel.Data as ArrayList)
{
oReorderLevel.Quantity = obj.Quantity;
CInventoryBO oInventoryBO = new CInventoryBO();
CResult oResultInventory = new CResult();
CInventory oInventory = new CInventory();
oInventory.Invt_BranchOID = obj.Branch_ID;
oInventory.Invt_LocOID = obj.Location_ID;
oInventory.Invt_ItemOID = obj.Item_ID;
oResultInventory = oInventoryBO.ReadForROL(oInventory);
if (oResultInventory.IsSuccess)
{
foreach (CInventory oInv in oResultInventory.Data as ArrayList)
{
if (int.Parse(oInv.Invt_QTY.ToString()) < int.Parse(oReorderLevel.Quantity.ToString()))
{
ItemName = ItemName + oInv.Invt_ItemName.ToString() + "\n";
// MessageBox.Show("Item", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
//MessageBox.Show("Shortage Of Following Items "+ItemName+"", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (ItemName != null)
{
frmPopup ofrmPopUp = new frmPopup(PopupSkins.AlertSkin);
ofrmPopUp.ShowPopup("Item Shortage!!", "Shortage Of Following Items-" + ItemName + "", 500, 2000, 500);
}
}
}
