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