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 int Issue(MRFinishProduct obj, String StoreID)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MRNO", obj.MR.MRNO),
new SqlParameter("@MRItemCode", obj.FinishProduct.FinishProductCode),
new SqlParameter("@StoreID", StoreID),
new SqlParameter("@MRIssuedQty", obj.IssuedQty)
};
return(Execute.RunSP_Int(Connection, "SPUPDATE_MRFinishProduct_Issue", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public MRFinishProductCollec Get(long MRNO)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MRNO", MRNO)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MRFinishProducts_ByMRNO", paramList);
MRFinishProductCollec objMRFinishProductCollec = new MRFinishProductCollec();
for (int i = 0; i < dt.Rows.Count; i++)
{
MRFinishProduct objMRFinishProduct = new MRFinishProduct();
objMRFinishProduct.FinishProduct = objFinishProduct_DL.Get(Convert.ToString(dt.Rows[i]["MRFinishProductID"]));
objMRFinishProduct.Description = Convert.ToString(dt.Rows[i]["MRDescription"]);
objMRFinishProduct.MR = objMR_DL.Get(Convert.ToInt64(dt.Rows[i]["MRNO"]));
objMRFinishProduct.MRBINNo = Convert.ToString(dt.Rows[i]["MRBINNo"]);
objMRFinishProduct.ReqdQty = Convert.ToDecimal(dt.Rows[i]["ReqdQty"]);
objMRFinishProduct.IssuedQty = Convert.ToDecimal(dt.Rows[i]["IssuedQty"]);
objMRFinishProduct.UnitCode = "Nos";
if (dt.Rows[i]["MRUnitRate"] != DBNull.Value)
{
objMRFinishProduct.UniRate = Convert.ToDecimal(dt.Rows[i]["MRUnitRate"]);
}
else
{
objMRFinishProduct.UniRate = 0;
}
objMRFinishProductCollec.Add(objMRFinishProduct);
}
return(objMRFinishProductCollec);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Add(MRFinishProduct obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MRNO", obj.MR.MRNO),
new SqlParameter("@MRFinishProductID", obj.FinishProduct.FinishProductCode),
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_MRFinishProduct", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Update(MRFinishProduct obj, long OriginalMRNO, String OriginalFinishProductCode)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MRNO", obj.MR.MRNO),
new SqlParameter("@MRFinishProductID", obj.FinishProduct.FinishProductCode),
new SqlParameter("@MRDescription", obj.Description),
new SqlParameter("@MRReqdQty", obj.ReqdQty),
new SqlParameter("@MRIssuedQty", obj.IssuedQty),
new SqlParameter("@MRBINNo", obj.MRBINNo),
new SqlParameter("@Original_MRNO", OriginalMRNO),
new SqlParameter("@Original_MRFinishProductID", OriginalFinishProductCode)
};
return(Execute.RunSP_RowsEffected(Connection, "SPGET_MRBasicProduct", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public MRFinishProduct Get(long MRNO, String FinishProductCode)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MRNO", MRNO),
new SqlParameter("@FinishProductCode", FinishProductCode)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MRFinishProductCode", paramList);
MRFinishProduct objMRFinishProduct = new MRFinishProduct();
objMRFinishProduct.FinishProduct = objFinishProduct_DL.Get(Convert.ToString(dt.Rows[0]["MRFinishProductID"]));
objMRFinishProduct.Description = Convert.ToString(dt.Rows[0]["MRDescription"]);
objMRFinishProduct.MR = objMR_DL.Get(Convert.ToInt64(dt.Rows[0]["MRNO"]));
objMRFinishProduct.MRBINNo = Convert.ToString(dt.Rows[0]["MRBINNo"]);
objMRFinishProduct.ReqdQty = Convert.ToDecimal(dt.Rows[0]["MRReqdQty"]);
objMRFinishProduct.IssuedQty = Convert.ToDecimal(dt.Rows[0]["MRIssuedQty"]);
//objMRFinishProduct.UniRate = Convert.ToDecimal(dr.MRUnitRate);
if (dt.Rows[0]["MRIssuedQty"] != null)
{
objMRFinishProduct.UniRate = Convert.ToDecimal(dt.Rows[0]["MRIssuedQty"]);
}
else
{
objMRFinishProduct.UniRate = 0;
}
return(objMRFinishProduct);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public MRFinishProductCollec Get()
{
try
{
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MRFinishProduct");
MRFinishProductCollec objMRFinishProductCollec = new MRFinishProductCollec();
for (int i = 0; i < dt.Rows.Count; i++)
{
MRFinishProduct objMRFinishProduct = new MRFinishProduct();
objMRFinishProduct.FinishProduct = objFinishProduct_DL.Get(Convert.ToString(dt.Rows[i]["MRFinishProductID"]));
objMRFinishProduct.Description = Convert.ToString(dt.Rows[i]["MRDescription"]);
objMRFinishProduct.MR = objMR_DL.Get(Convert.ToInt64(dt.Rows[i]["MRIssuedQty"]));
objMRFinishProduct.MRBINNo = Convert.ToString(dt.Rows[i]["MRIssuedQty"]);
objMRFinishProduct.ReqdQty = Convert.ToDecimal(dt.Rows[i]["MRIssuedQty"]);
objMRFinishProduct.IssuedQty = Convert.ToDecimal(dt.Rows[i]["MRIssuedQty"]);
//objMRFinishProduct.UniRate = Convert.ToDecimal(dr.MRUnitRate);
if (dt.Rows[i]["MRIssuedQty"] != null)
{
objMRFinishProduct.UniRate = Convert.ToDecimal(dt.Rows[i]["MRIssuedQty"]);
}
else
{
objMRFinishProduct.UniRate = 0;
}
objMRFinishProductCollec.Add(objMRFinishProduct);
}
return(objMRFinishProductCollec);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
private void IssueFinishFinished()
{
if (cmbStore.Items.Count > 0)
{
Store objStore = (Store)cmbStore.SelectedItem;
if (this.ItemSelect)
{
if (objMR.MRType == MR.Type.FinishProduct)
{
bool isZero = false;
bool Transfer = true;
int Stock = 0;
int zerocount = 0;
foreach (DataGridViewRow dr in gvItemList.Rows)
{
MRFinishProduct objMRFinish = new MRFinishProduct();
objMRFinish = (MRFinishProduct)dr.DataBoundItem;
Stock = objMRBasicProduct_DL.Get_FGStockByStore(objStore.StoreID, objMRFinish.FinishProduct.FinishProductCode, objMRFinish.IssuedQty);
if (Stock == 0 && objMRFinish.IssuedQty != 0)
{
MessageBox.Show(this, objMRFinish.FinishProduct.FinishProductCode + " Stock is lower than Issued Quantity,Please enter lower quantity", "Stock is not Enough", MessageBoxButtons.OK, MessageBoxIcon.Information);
Transfer = false;
break;
}
if (objMRFinish.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)
{
MRFinishProduct objMRFinish = new MRFinishProduct();
objMRFinish = (MRFinishProduct)dr.DataBoundItem;
objMRFinishProduct_DL.Issue(objMRFinish, 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)
{
MRFinishProduct objMRFinish = new MRFinishProduct();
objMRFinish = (MRFinishProduct)dr.DataBoundItem;
objMRFinishProduct_DL.Issue(objMRFinish, 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);
}
}
}
}
}
}
}
}
}
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;
MRMaterial objMRMat = new MRMaterial();
MRBasicProduct objMRBasic = new MRBasicProduct();
MRFinishProduct objMRFinish = new MRFinishProduct();
try
{
if (this.ItemSelect)
{
if (cmbMRType.SelectedItem.Equals("Material"))
{
objMRMat.Description = txtDescription.Text;
objMRMat.Material = objMaterialDL.Get(cmbItem.SelectedValue.ToString());
objMRMat.ReqdQty = Convert.ToDecimal(txtQty.Text);
if (objMRMaterial.Material.MaterialCode != objMRMat.Material.MaterialCode)
{
foreach (MRMaterial obj in objMRMaterialCollec)
{
if (obj.Material.MaterialCode == objMRMat.Material.MaterialCode)
{
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)
{
objMRMaterialCollec.Delete(objMRMaterial);
objMRMaterialCollec.Add(objMRMat);
ClearItem();
}
}
else
{
objMRMaterialCollec.Delete(objMRMaterial);
objMRMaterialCollec.Add(objMRMat);
ClearItem();
}
bindItemList.DataSource = objMRMaterialCollec;
bindItemList.ResetBindings(false);
}
else if (cmbMRType.SelectedItem.Equals("Basic Products"))
{
objMRBasic.BasicProduct = objBasicProductDL.Get(cmbItem.SelectedValue.ToString());
objMRBasic.Description = txtDescription.Text;
objMRBasic.ReqdQty = Convert.ToDecimal(txtQty.Text);
if (objMRBasicProduct.BasicProduct.BasicProductCode != objMRBasic.BasicProduct.BasicProductCode)
{
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.Delete(objMRBasicProduct);
objMRBasicProductCollec.Add(objMRBasic);
ClearItem();
}
}
else
{
objMRBasicProductCollec.Delete(objMRBasicProduct);
objMRBasicProductCollec.Add(objMRBasic);
ClearItem();
}
bindItemList.DataSource = objMRBasicProductCollec;
bindItemList.ResetBindings(false);
}
else if (cmbMRType.SelectedItem.Equals("Finish Products"))
{
objMRFinish.Description = txtDescription.Text;
objMRFinish.FinishProduct = objFinishProductDL.Get(cmbItem.SelectedValue.ToString());
objMRFinish.ReqdQty = Convert.ToDecimal(txtQty.Text);
if (objMRFinishProduct.FinishProduct.FinishProductCode != objMRFinish.FinishProduct.FinishProductCode)
{
foreach (MRFinishProduct obj in objMRFinishhProductCollec)
{
if (obj.FinishProduct.FinishProductCode == objMRFinish.FinishProduct.FinishProductCode)
{
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)
{
objMRFinishhProductCollec.Delete(objMRFinishProduct);
objMRFinishhProductCollec.Add(objMRFinish);
ClearItem();
}
}
else
{
objMRFinishhProductCollec.Delete(objMRFinishProduct);
objMRFinishhProductCollec.Add(objMRFinish);
ClearItem();
}
bindItemList.DataSource = objMRFinishhProductCollec;
bindItemList.ResetBindings(false);
}
}
else
{
if (cmbMRType.SelectedItem.Equals("Material"))
{
objMRMat.Description = txtDescription.Text;
objMRMat.Material = objMaterialDL.Get(cmbItem.SelectedValue.ToString());
objMRMat.ReqdQty = Convert.ToDecimal(txtQty.Text);
if (objMRMaterialCollec.Count > 0)
{
foreach (MRMaterial obj in objMRMaterialCollec)
{
if (obj.Material.MaterialCode == objMRMat.Material.MaterialCode)
{
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)
{
objMRMaterialCollec.Add(objMRMat);
ClearItem();
}
}
else
{
objMRMaterialCollec.Add(objMRMat);
ClearItem();
}
bindItemList.DataSource = objMRMaterialCollec;
bindItemList.ResetBindings(false);
}
else if (cmbMRType.SelectedItem.Equals("Basic Products"))
{
objMRBasic.BasicProduct = objBasicProductDL.Get(cmbItem.SelectedValue.ToString());
objMRBasic.Description = txtDescription.Text;
objMRBasic.ReqdQty = Convert.ToDecimal(txtQty.Text);
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);
}
else if (cmbMRType.SelectedItem.Equals("Finish Products"))
{
objMRFinish.Description = txtDescription.Text;
objMRFinish.FinishProduct = objFinishProductDL.Get(cmbItem.SelectedValue.ToString());
objMRFinish.ReqdQty = Convert.ToDecimal(txtQty.Text);
if (objMRFinishhProductCollec.Count > 0)
{
foreach (MRFinishProduct obj in objMRFinishhProductCollec)
{
if (obj.FinishProduct.FinishProductCode == objMRFinish.FinishProduct.FinishProductCode)
{
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)
{
objMRFinishhProductCollec.Add(objMRFinish);
ClearItem();
}
}
else
{
objMRFinishhProductCollec.Add(objMRFinish);
ClearItem();
}
bindItemList.DataSource = objMRFinishhProductCollec;
bindItemList.ResetBindings(false);
}
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
objMRMat = null;
}
}
}
