public GRNFinishProductsCollec Get()
{
try
{
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_GRNFinishProduct");
GRNFinishProductsCollec objGRNFinishProductsCollec = new GRNFinishProductsCollec();
for (int i = 0; i < dt.Rows.Count; i++)
{
GRNFinishProducts objGRNFinishProduct = new GRNFinishProducts();
objGRNFinishProduct.FinishProducts = objFinishProduct_DL.Get(Convert.ToString(dt.Rows[i]["FinishProductCode"]));
objGRNFinishProduct.GRN = objGRN_DL.Get(Convert.ToInt64(dt.Rows[i]["GRNNO"]));
objGRNFinishProduct.GrossQty = Convert.ToDecimal(dt.Rows[i]["GrossQty"]);
objGRNFinishProduct.NetQty = Convert.ToDecimal(dt.Rows[i]["NetQty"]);
objGRNFinishProduct.Remarks = Convert.ToString(dt.Rows[i]["Remarks"]);
objGRNFinishProduct.UnitPrice = Convert.ToDecimal(dt.Rows[i]["UnitPrice"]);
objGRNFinishProductsCollec.Add(objGRNFinishProduct);
}
return(objGRNFinishProductsCollec);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
BasicProduct objBasic = new BasicProduct();
FinishProduct objFinishProduct = new FinishProduct();
Material objMaterial = new Material();
GRNMaterials objGRNMaterialsTemp = new GRNMaterials();
GRNBasicProducts objGRNBasicProductTemp = new GRNBasicProducts();
GRNFinishProducts objGRNFinishProductTemp = new GRNFinishProducts();
bool ItemInList = false;
try
{
if (txtNetQty.Text.Equals("") || txtUnitCost.Text.Equals(""))
{
MessageBox.Show(this, "Please Fill all fields", "Empty Fields", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
bool Quantity = true;
if (Quantity)
{
if (objGRN.GRNType == GRN.Type.Material)
{
if (ItemSelect)
{
objGRNMaterialsCollec.Delete(objGRNMaterials);
}
objMaterial = objMaterialDL.Get(cmbItem.SelectedValue.ToString());
objGRNMaterialsTemp.Material = objMaterial;
objGRNMaterialsTemp.GrossQty = Convert.ToDecimal(txtNetQty.Text);
objGRNMaterialsTemp.NetQty = Convert.ToDecimal(txtNetQty.Text);
objGRNMaterialsTemp.Remarks = txtRemarks.Text;
objGRNMaterialsTemp.UnitPrice = Convert.ToDecimal(txtUnitCost.Text);
foreach (GRNMaterials obj in objGRNMaterialsCollec)
{
if (obj.Material.MaterialCode == objMaterial.MaterialCode)
{
MessageBox.Show(this, "This item already added to the list, You can't add same item repeatedly to a GRN. If you want GRN same item again Please create a another GRN", "Item already Added", MessageBoxButtons.OK, MessageBoxIcon.Information);
ItemInList = true;
break;
}
}
if (!ItemInList)
{
objGRNMaterialsCollec.Add(objGRNMaterialsTemp);
bindItemList.DataSource = objGRNMaterialsCollec;
ClearItem();
}
ItemInList = false;
bindItemList.ResetBindings(false);
}
else if (objGRN.GRNType == GRN.Type.BasicProduct)
{
if (ItemSelect)
{
objGRNBasicProductCollec.Delete(objGRNBasicProduct);
}
objBasic = objBasicProductDL.Get(cmbItem.SelectedValue.ToString());
objGRNBasicProductTemp.GrossQty = Convert.ToDecimal(txtNetQty.Text);
objGRNBasicProductTemp.BasicProduct = objBasic;
objGRNBasicProductTemp.NetQty = Convert.ToDecimal(txtNetQty.Text);
objGRNBasicProductTemp.Remarks = txtRemarks.Text;
objGRNBasicProductTemp.UnitPrice = Convert.ToDecimal(txtUnitCost.Text);
foreach (GRNBasicProducts obj in objGRNBasicProductCollec)
{
if (obj.BasicProduct.BasicProductCode == objBasic.BasicProductCode)
{
MessageBox.Show(this, "This item already added to the list, You can't add same item repeatedly to a GRN. If you want GRN same item again Please create a another GRN", "Item already Added", MessageBoxButtons.OK, MessageBoxIcon.Information);
ItemInList = true;
break;
}
}
if (!ItemInList)
{
objGRNBasicProductCollec.Add(objGRNBasicProductTemp);
bindItemList.DataSource = objGRNBasicProductCollec;
ClearItem();
}
ItemInList = false;
bindItemList.ResetBindings(false);
}
else if (objGRN.GRNType == GRN.Type.FinishProduct)
{
if (ItemSelect)
{
objGRNFinishProductCollec.Delete(objGRNFinishProduct);
}
objFinishProduct = objFinishProductDL.Get(cmbItem.SelectedValue.ToString());
objGRNFinishProductTemp.GrossQty = Convert.ToDecimal(txtNetQty.Text);
objGRNFinishProductTemp.FinishProducts = objFinishProduct;
objGRNFinishProductTemp.NetQty = Convert.ToDecimal(txtNetQty.Text);
objGRNFinishProductTemp.Remarks = txtRemarks.Text;
objGRNFinishProductTemp.UnitPrice = Convert.ToDecimal(txtUnitCost.Text);
foreach (GRNFinishProducts obj in objGRNFinishProductCollec)
{
if (obj.FinishProducts.FinishProductCode == objFinishProduct.FinishProductCode)
{
MessageBox.Show(this, "This item already added to the list, You can't add same item repeatedly to a GRN. If you want GRN same item again Please create a another GRN", "Item already Added", MessageBoxButtons.OK, MessageBoxIcon.Information);
ItemInList = true;
break;
}
}
if (!ItemInList)
{
objGRNFinishProductCollec.Add(objGRNFinishProductTemp);
bindItemList.DataSource = objGRNFinishProductCollec;
ClearItem();
}
ItemInList = false;
bindItemList.ResetBindings(false);
}
}
}
}
catch (FormatException fex)
{
MessageBox.Show(this, fex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
objMaterial = null;
objBasic = null;
objFinishProduct = null;
}
}