private void gvItemList_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex >= 0)
{
if (cmbMRType.SelectedItem.Equals("Material"))
{
objMRMaterial = (MRMaterial)gvItemList.Rows[e.RowIndex].DataBoundItem;
txtDescription.Text = objMRMaterial.Description;
txtQty.Text = objMRMaterial.ReqdQty.ToString();
cmbItem.SelectedValue = objMRMaterial.Material.MaterialCode;
}
else if (cmbMRType.SelectedItem.Equals("Basic Products"))
{
objMRBasicProduct = (MRBasicProduct)gvItemList.Rows[e.RowIndex].DataBoundItem;
txtDescription.Text = objMRBasicProduct.Description;
txtQty.Text = objMRBasicProduct.ReqdQty.ToString();
cmbItem.SelectedValue = objMRBasicProduct.BasicProduct.BasicProductCode;
}
else if (cmbMRType.SelectedItem.Equals("Finish Products"))
{
objMRFinishProduct = (MRFinishProduct)gvItemList.Rows[e.RowIndex].DataBoundItem;
txtDescription.Text = objMRFinishProduct.Description;
txtQty.Text = objMRFinishProduct.ReqdQty.ToString();
cmbItem.SelectedItem = objMRFinishProduct.FinishProduct.FinishProductCode;
}
ItemSelect = true;
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public MRBasicProductCollec Get(long MRNO)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MRNO", MRNO)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MRBasicProduct_By_MR", paramList);
MRBasicProductCollec objMRBasicCollec = new MRBasicProductCollec();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
MRBasicProduct objMRBasicProduct = new MRBasicProduct();
objMRBasicProduct.BasicProduct = objBasicProduct_DL.Get(Convert.ToString(dt.Rows[i]["MRMaterialCode"]));
objMRBasicProduct.Description = Convert.ToString(dt.Rows[i]["MRDescription"]);
objMRBasicProduct.MR = objMR_DL.Get(Convert.ToInt64(dt.Rows[i]["MRNO"]));
objMRBasicProduct.MRBINNo = Convert.ToString(dt.Rows[i]["MRBINNo"]);
objMRBasicProduct.ReqdQty = Convert.ToDecimal(dt.Rows[i]["MRReqdQty"]);
objMRBasicProduct.IssuedQty = Convert.ToDecimal(dt.Rows[i]["MRIssuedQty"]);
objMRBasicProduct.UnitCode = objMRBasicProduct.BasicProduct.BasicProductUnit.UnitCode;
objMRBasicProduct.Item = objMRBasicProduct.BasicProduct.BasicProductCode + " - " + objMRBasicProduct.BasicProduct.BasicProductDescription;
objMRBasicProduct.ItemCode = objMRBasicProduct.BasicProduct.BasicProductCode;
if (dt.Rows[i]["MRUnitRate"] != null)
{
objMRBasicProduct.UniRate = Convert.ToDecimal(dt.Rows[i]["MRUnitRate"]);
}
else
{
objMRBasicProduct.UniRate = 0;
}
objMRBasicCollec.Add(objMRBasicProduct);
}
}
return(objMRBasicCollec);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Issue(MRBasicProduct obj, String StoreID)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MRNO", obj.MR.MRNO),
new SqlParameter("@MRItemCode", obj.ItemCode),
new SqlParameter("@MRIssuedQty", obj.IssuedQty),
new SqlParameter("@StoreID", StoreID)
};
return(Execute.RunSP_Int(Connection, "SPUPDATE_MRBasicProduct_Issue", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Add(MRBasicProduct obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MRNO", obj.MR.MRNO),
new SqlParameter("@MRBasicProductID", obj.BasicProduct.BasicProductCode),
new SqlParameter("@MRDescription", obj.Description),
new SqlParameter("@MRReqdQty", obj.ReqdQty),
new SqlParameter("@MRIssuedQty", obj.IssuedQty),
new SqlParameter("@MRBINNo", obj.MRBINNo)
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_MRBasicProduct", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public MRBasicProduct Get(long MRNO, String BasicProductCode)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MRNO", MRNO),
new SqlParameter("@BasicProductCode", BasicProductCode)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MRBasicProductByID", paramList);
MRBasicProduct objMRBasicProduct = new MRBasicProduct();
objMRBasicProduct.BasicProduct = objBasicProduct_DL.Get(Convert.ToString(dt.Rows[0]["MRBasicProductID"]));
objMRBasicProduct.Description = Convert.ToString(dt.Rows[0]["MRDate"]);
objMRBasicProduct.MR = objMR_DL.Get(Convert.ToInt64(dt.Rows[0]["MRNO"]));
objMRBasicProduct.MRBINNo = Convert.ToString(dt.Rows[0]["MRBINNo"]);
objMRBasicProduct.ReqdQty = Convert.ToDecimal(dt.Rows[0]["MRReqdQty"]);
objMRBasicProduct.IssuedQty = Convert.ToDecimal(dt.Rows[0]["MRIssuedQty"]);
if (dt.Rows[0]["MRDate"] != null)
{
objMRBasicProduct.UniRate = Convert.ToDecimal(dt.Rows[0]["MRUnitRate"]);
}
else
{
objMRBasicProduct.UniRate = 0;
}
return(objMRBasicProduct);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Update(MRBasicProduct obj, long OriginalMRNO, String OriginalBasicProductCode)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MRNO", obj.MR.MRNO),
new SqlParameter("@MRBasicProductID", obj.BasicProduct.BasicProductCode),
new SqlParameter("@MRDescription", obj.Description),
new SqlParameter("@MRReqdQty", obj.ReqdQty),
new SqlParameter("@MRIssuedQty", obj.IssuedQty),
new SqlParameter("@MRBINNo", obj.MRBINNo),
new SqlParameter("@MRUnitRate", obj.UniRate),
new SqlParameter("@Original_MRNO", OriginalMRNO),
new SqlParameter("@Original_MRBasicProductID", OriginalBasicProductCode),
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_MRBasicProduct", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public MRBasicProductCollec Get()
{
try
{
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MRBasicProduct");
MRBasicProductCollec objMRBasicCollec = new MRBasicProductCollec();
for (int i = 0; i < dt.Rows.Count; i++)
{
MRBasicProduct objMRBasicProduct = new MRBasicProduct();
objMRBasicProduct.BasicProduct = objBasicProduct_DL.Get(Convert.ToString(dt.Rows[i]["MRBasicProductID"]));
objMRBasicProduct.Description = Convert.ToString(dt.Rows[i]["MRDescription"]);
objMRBasicProduct.MR = objMR_DL.Get(Convert.ToInt64(dt.Rows[i]["MRNO"]));
objMRBasicProduct.MRBINNo = Convert.ToString(dt.Rows[i]["MRBINNo"]);
objMRBasicProduct.ReqdQty = Convert.ToDecimal(dt.Rows[i]["MRReqdQty"]);
objMRBasicProduct.IssuedQty = Convert.ToDecimal(dt.Rows[i]["MRIssuedQty"]);
if (dt.Rows[i]["MRUnitRate"] != null)
{
objMRBasicProduct.UniRate = Convert.ToDecimal(dt.Rows[i]["MRUnitRate"]);
}
else
{
objMRBasicProduct.UniRate = 0;
}
objMRBasicCollec.Add(objMRBasicProduct);
}
return(objMRBasicCollec);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
private void btnItemAdd_Click(object sender, EventArgs e)
{
if (txtQty.Text.Equals(""))
{
MessageBox.Show(this, "Please fill the quantity field", "Empty Field", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
bool ItemList = false;
MRBasicProduct objMRBasic = new MRBasicProduct();
try
{
if (ItemSelect)
{
objMRBasic.Description = txtDescription.Text;
objMRBasic.BasicProduct = objBasicProduct_DL.Get(cmbItem.SelectedValue.ToString());
objMRBasic.ReqdQty = Convert.ToDecimal(txtQty.Text);
objMRBasic.MRBINNo = "N/A";
objMRBasic.Item = objMRBasic.BasicProduct.BasicProductCode + "-" + objMRBasic.BasicProduct.BasicProductDescription;
objMRBasic.ItemCode = objMRBasic.BasicProduct.BasicProductCode;
if (objMRBasicProduct.BasicProduct.BasicProductCode != objMRBasic.BasicProduct.BasicProductCode)
{
foreach (MRBasicProduct obj in objMRBasicProductCollec)
{
if (objMRBasicProduct.BasicProduct.BasicProductCode == objMRBasic.BasicProduct.BasicProductCode)
{
MessageBox.Show(this,
"This item already in the list,Please Select the item from List and Update",
"Item in the List",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
ItemList = true;
break;
}
}
if (!ItemList)
{
objMRBasicProductCollec.Delete(objMRBasicProduct);
objMRBasicProductCollec.Add(objMRBasic);
ClearItem();
}
}
else
{
objMRBasicProductCollec.Delete(objMRBasicProduct);
objMRBasicProductCollec.Add(objMRBasic);
ClearItem();
}
bindItemList.DataSource = objMRBasicProductCollec;
bindItemList.ResetBindings(false);
}
else
{
objMRBasic.Description = txtDescription.Text;
objMRBasic.BasicProduct = objBasicProduct_DL.Get(cmbItem.SelectedValue.ToString());
objMRBasic.ReqdQty = Convert.ToDecimal(txtQty.Text);
objMRBasic.MRBINNo = "N/A";
objMRBasic.Item = objMRBasic.BasicProduct.BasicProductCode + "-" + objMRBasic.BasicProduct.BasicProductDescription;
objMRBasic.ItemCode = objMRBasic.BasicProduct.BasicProductCode;
objMRBasic.UnitCode = objMRBasic.BasicProduct.BasicProductUnit.UnitCode;
if (objMRBasicProductCollec.Count > 0)
{
foreach (MRBasicProduct obj in objMRBasicProductCollec)
{
if (obj.BasicProduct.BasicProductCode == objMRBasic.BasicProduct.BasicProductCode)
{
MessageBox.Show(this, "This item already in the list,Please Select the item from List and Update", "Item in the List", MessageBoxButtons.OK, MessageBoxIcon.Information);
ItemList = true;
break;
}
}
if (!ItemList)
{
objMRBasicProductCollec.Add(objMRBasic);
ClearItem();
}
}
else
{
objMRBasicProductCollec.Add(objMRBasic);
ClearItem();
}
bindItemList.DataSource = objMRBasicProductCollec;
bindItemList.ResetBindings(false);
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
objMRBasic = null;
}
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (rdbMaterial.Checked == true)
{
MRMaterial obj = new MRMaterial();
bool duplicate = false;
obj.Material = objMaterialDL.Get(dgvItemList.CurrentRow.Cells["ItemCode"].Value.ToString());
obj.ReqdQty = Convert.ToDecimal(dgvItemList.CurrentRow.Cells["ReqQty"].Value);
obj.IssuedQty = 0;
obj.Description = "Batch Material Requisition";
obj.MRBINNo = "N/A";
obj.MaterialCode = obj.Material.MaterialCode;
obj.MaterialName = obj.Material.MaterialDescription;
foreach (MRMaterial _obj in objMRMaterialCollec)
{
if (_obj.MaterialCode == obj.MaterialCode)
{
duplicate = true;
break;
}
}
for (int i = 0; i < dgvItemRequested.Rows.Count; i++)
{
if (dgvItemRequested.Rows[i].Cells["MaterialCode"].Value.ToString() == obj.MaterialCode)
{
duplicate = true;
break;
}
}
if (duplicate == false)
{
objMRMaterialCollec.Add(obj);
}
dgvItem_toRequest.AutoGenerateColumns = false;
objSourceItems_toRequest.DataSource = objMRMaterialCollec;
dgvItem_toRequest.DataSource = objSourceItems_toRequest;
objSourceItems_toRequest.ResetBindings(true);
}
else
{
MRBasicProduct obj = new MRBasicProduct();
obj.BasicProduct = objBasicProductDL.Get(dgvItemList.CurrentRow.Cells["ItemCode"].Value.ToString());
obj.ReqdQty = Convert.ToDecimal(dgvItemList.CurrentRow.Cells["ReqQty"].Value);
obj.ItemCode = obj.BasicProduct.BasicProductCode;
obj.Item = obj.BasicProduct.BasicProductDescription;
obj.Description = "No";
obj.MRBINNo = "No";
objMRBasicProductCollec.Add(obj);
dgvItem_toRequest_BP.AutoGenerateColumns = false;
objSourceItems_toRequest.DataSource = objMRBasicProductCollec;
dgvItem_toRequest_BP.DataSource = objSourceItems_toRequest;
objSourceItems_toRequest.ResetBindings(true);
}
}
private void IssueSemiFinished()
{
if (cmbStore.Items.Count > 0)
{
Store objStore = (Store)cmbStore.SelectedItem;
if (this.ItemSelect)
{
if (objMR.MRType == MR.Type.BasicProduct)
{
bool isZero = false;
bool Transfer = true;
int Stock = 0;
int zerocount = 0;
foreach (DataGridViewRow dr in gvItemList.Rows)
{
MRBasicProduct objMRSemi = new MRBasicProduct();
objMRSemi = (MRBasicProduct)dr.DataBoundItem;
Stock = objMRBasicProduct_DL.Get_StockByStore(objStore.StoreID, objMRSemi.BasicProduct.BasicProductCode, objMRSemi.IssuedQty);
if (Stock == 0 && objMRSemi.IssuedQty != 0)
{
MessageBox.Show(this, objMRSemi.BasicProduct.BasicProductCode + " Stock is lower than Issued Quantity,Please enter lower quantity", "Stock is not Enough", MessageBoxButtons.OK, MessageBoxIcon.Information);
Transfer = false;
break;
}
if (objMRSemi.IssuedQty == 0)
{
isZero = true;
zerocount++;
}
}
if (Transfer)
{
DialogResult drRes;
if (zerocount >= gvItemList.Rows.Count)
{
MessageBox.Show(this, "Please enter a Issue Quantity", "Empty Field", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
if (isZero)
{
drRes = MessageBox.Show(this, "One more items does not have a quantity, Do you want to continue\n\nClick Yes to continue", "Empty Quantities", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
if (drRes == DialogResult.Yes)
{
foreach (DataGridViewRow dr in gvItemList.Rows)
{
MRBasicProduct objMRSemi = new MRBasicProduct();
objMRSemi = (MRBasicProduct)dr.DataBoundItem;
objMRBasicProduct_DL.Issue(objMRSemi, objStore.StoreID);
}
objMR.MRIssuedBy = CurrentUser.UserEmp.EmployeeID;
objMR.MRStatus = MR.Status.Issued;
int x = objMRDL.Update_Issue(objMR);
if (x > 0)
{
bindItemList.DataSource = null;
Clear();
if (objStore != null)
{
bindMRList.DataSource = objMRDL.GetDataView(objStore.StoreID, MR.Status.Approved);
}
}
}
}
else
{
foreach (DataGridViewRow dr in gvItemList.Rows)
{
MRBasicProduct objMRSemi = new MRBasicProduct();
objMRSemi = (MRBasicProduct)dr.DataBoundItem;
objMRBasicProduct_DL.Issue(objMRSemi, objStore.StoreID);
}
objMR.MRIssuedBy = CurrentUser.UserEmp.EmployeeID;
objMR.MRStatus = MR.Status.Issued;
int x = objMRDL.Update_Issue(objMR);
if (x > 0)
{
bindItemList.DataSource = null;
Clear();
if (objStore != null)
{
bindMRList.DataSource = objMRDL.GetDataView(objStore.StoreID, MR.Status.Approved);
}
}
}
}
}
}
}
}
}
