public GRNBasicProductsCollec Get()
{
try
{
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_GRNBasicProduct");
GRNBasicProductsCollec objGRNBasicProductsCollec = new GRNBasicProductsCollec();
for (int i = 0; i < dt.Rows.Count; i++)
{
GRNBasicProducts objGRNBasicProduct = new GRNBasicProducts();
objGRNBasicProduct.BasicProduct = objBasicProduct_DL.Get(Convert.ToString(dt.Rows[i]["BasicProductCode"]));
objGRNBasicProduct.GRN = objGRN_DL.Get(Convert.ToInt64(dt.Rows[i]["GRNNO"]));
objGRNBasicProduct.GrossQty = Convert.ToDecimal(dt.Rows[i]["GrossQty"]);
objGRNBasicProduct.NetQty = Convert.ToDecimal(dt.Rows[i]["NetQty"]);
objGRNBasicProduct.Remarks = Convert.ToString(dt.Rows[i]["Remarks"]);
objGRNBasicProduct.UnitPrice = Convert.ToDecimal(dt.Rows[i]["UnitPrice"]);
objGRNBasicProductsCollec.Add(objGRNBasicProduct);
}
return(objGRNBasicProductsCollec);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public GRNBasicProducts Get(long GRNNO, String BasicProductCode)
{
try
{
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_GRNBasicProduct_ByID");
GRNBasicProducts objGRNBasicProduct = new GRNBasicProducts();
objGRNBasicProduct.BasicProduct = objBasicProduct_DL.Get(Convert.ToString(dt.Rows[0]["BasicProductCode"]));
objGRNBasicProduct.GRN = objGRN_DL.Get(Convert.ToInt64(dt.Rows[0]["GRNNO"]));
objGRNBasicProduct.GrossQty = Convert.ToDecimal(dt.Rows[0]["GrossQty"]);
objGRNBasicProduct.NetQty = Convert.ToDecimal(dt.Rows[0]["NetQty"]);
objGRNBasicProduct.Remarks = Convert.ToString(dt.Rows[0]["Remarks"]);
objGRNBasicProduct.UnitPrice = Convert.ToDecimal(dt.Rows[0]["UnitPrice"]);
return(objGRNBasicProduct);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
private void gvItemList_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex >= 0)
{
if (objGRN.GRNType == GRN.Type.Material)
{
objGRNMaterials = (GRNMaterials)gvItemList.Rows[e.RowIndex].DataBoundItem;
cmbItem.SelectedValue = objGRNMaterials.Material.MaterialCode;
txtNetQty.Text = objGRNMaterials.NetQty.ToString();
txtRemarks.Text = objGRNMaterials.Remarks;
txtUnitCost.Text = objGRNMaterials.UnitPrice.ToString();
ItemSelect = true;
btnSave.Text = "Save";
}
else if (objGRN.GRNType == GRN.Type.BasicProduct)
{
objGRNBasicProduct = (GRNBasicProducts)gvItemList.Rows[e.RowIndex].DataBoundItem;
cmbItem.SelectedValue = objGRNBasicProduct.BasicProduct.BasicProductCode;
txtNetQty.Text = objGRNBasicProduct.NetQty.ToString();
txtRemarks.Text = objGRNBasicProduct.Remarks;
txtUnitCost.Text = objGRNBasicProduct.UnitPrice.ToString();
ItemSelect = true;
btnSave.Text = "Save";
}
else if (objGRN.GRNType == GRN.Type.FinishProduct)
{
objGRNFinishProduct = (GRNFinishProducts)gvItemList.Rows[e.RowIndex].DataBoundItem;
cmbItem.SelectedValue = objGRNFinishProduct.FinishProducts.FinishProductCode;
txtNetQty.Text = objGRNFinishProduct.NetQty.ToString();
txtRemarks.Text = objGRNFinishProduct.Remarks;
txtUnitCost.Text = objGRNFinishProduct.UnitPrice.ToString();
ItemSelect = true;
btnSave.Text = "Save";
}
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public int Add(GRNBasicProducts obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@GRNNO", obj.GRN.GRNNo),
new SqlParameter("@BasicProductCode", obj.BasicProduct.BasicProductCode),
new SqlParameter("@GrossQty", obj.GrossQty),
new SqlParameter("@NetQty", obj.NetQty),
new SqlParameter("@UnitPrice", obj.UnitPrice),
new SqlParameter("@Remarks", obj.Remarks)
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_GRNBasicProduct", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Update(GRNBasicProducts obj, long GRNNO, String BasicProductCode)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@GRNNO", obj.GRN.GRNNo),
new SqlParameter("@BasicProductCode", obj.BasicProduct.BasicProductCode),
new SqlParameter("@GrossQty", obj.GrossQty),
new SqlParameter("@NetQty", obj.NetQty),
new SqlParameter("@UnitPrice", obj.UnitPrice),
new SqlParameter("@Remarks", obj.Remarks),
new SqlParameter("@Original_GRNNO", GRNNO),
new SqlParameter("@Original_BasicProductCode", BasicProductCode)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_GRNBasicProduct", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
private void cmbGRNNO_SelectedIndexChanged(object sender, EventArgs e)
{
GRNMaterials objGRNMat = new GRNMaterials();
GRNBasicProducts objGRNBasic = new GRNBasicProducts();
GRNFinishProducts objGRNFinish = new GRNFinishProducts();
GRNMaterials_DL objGRNMatDL = new GRNMaterials_DL(ConnectionStringClass.GetConnection());
GRNBasicProducts_DL objGRNBasicDL = new GRNBasicProducts_DL(ConnectionStringClass.GetConnection());
GRNFinishProducts_DL objGRNFinishDL = new GRNFinishProducts_DL(ConnectionStringClass.GetConnection());
GRN_DL objGRNDL = new GRN_DL(ConnectionStringClass.GetConnection());
try
{
long GRNNO = 0;
if (cmbGRNNO.Items.Count > 0 && cmbGRNNO.SelectedValue != null)
{
GRNNO = Convert.ToInt64(cmbGRNNO.SelectedValue);
}
String ItemCode = "";
if (cmbItem.Items.Count > 0 && cmbItem.SelectedValue != null)
{
ItemCode = cmbItem.SelectedValue.ToString();
}
if (!ItemCode.Equals("") && !GRNNO.Equals(""))
{
if (cmbMTNType.SelectedItem.Equals("Material"))
{
objGRNMat = objGRNMatDL.Get(GRNNO, ItemCode);
if (objGRNMat != null)
{
txtGRNUnitCost.Text = objGRNMat.UnitPrice.ToString();
txtAvailableQty.Text = objGRNMatDL.Get_AvailableQty(GRNNO, ItemCode).ToString();
txtGRNQty.Text = objGRNMat.NetQty.ToString();
//txtStockHoldingCost.Text = objGRNDL.Get_StockHoldingCost(GRNNO, objGRNMat.UnitPrice).ToString();
}
}
else if (cmbMTNType.SelectedItem.Equals("Basic Product"))
{
objGRNBasic = objGRNBasicDL.Get(GRNNO, ItemCode);
if (objGRNBasic != null)
{
txtGRNUnitCost.Text = objGRNBasic.UnitPrice.ToString();
txtAvailableQty.Text = objGRNBasicDL.Get_AvailableQty(GRNNO, ItemCode).ToString();
txtGRNQty.Text = objGRNBasic.NetQty.ToString();
//txtStockHoldingCost.Text = objGRNDL.Get_StockHoldingCost(GRNNO, objGRNBasic.UnitPrice).ToString();
}
}
else if (cmbMTNType.SelectedItem.Equals("Finish Product"))
{
objGRNFinish = objGRNFinishDL.Get(GRNNO, ItemCode);
if (objGRNFinish != null)
{
txtGRNUnitCost.Text = objGRNFinish.UnitPrice.ToString();
txtAvailableQty.Text = objGRNFinishDL.Get_AvailableQty(GRNNO, ItemCode).ToString();
txtGRNQty.Text = objGRNFinish.NetQty.ToString();
// txtStockHoldingCost.Text = objGRNDL.Get_StockHoldingCost(GRNNO, objGRNFinish.UnitPrice).ToString();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
objGRNMat = null;
objGRNBasic = null;
objGRNFinish = null;
objGRNMatDL = null;
objGRNBasicDL = null;
objGRNFinishDL = null;
}
}
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;
}
}
