public GRNMaterials Get(long GRNNO, String MaterialCode)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@GRNNO", GRNNO),
new SqlParameter("@MaterialCode", MaterialCode)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_GRNMaterials_ByID ");
GRNMaterials objGRNMaterial = new GRNMaterials();
objGRNMaterial.GRN = objGRN_DL.Get(Convert.ToInt64(dt.Rows[0]["GRNNO"]));
objGRNMaterial.GrossQty = Convert.ToDecimal(dt.Rows[0]["GrossQty"]);
objGRNMaterial.Material = objMaterial_DL.Get(Convert.ToString(dt.Rows[0]["MaterialCode"]));
objGRNMaterial.NetQty = Convert.ToDecimal(dt.Rows[0]["NetQty"]);
objGRNMaterial.Remarks = Convert.ToString(dt.Rows[0]["Remarks"]);
objGRNMaterial.UnitPrice = Convert.ToDecimal(dt.Rows[0]["UnitPrice"]);
return(objGRNMaterial);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public GRNMaterialsCollec Get()
{
try
{
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_GRNMaterials");
GRNMaterialsCollec objGRNMatCollec = new GRNMaterialsCollec();
for (int i = 0; i < dt.Rows.Count; i++)
{
GRNMaterials objGRNMaterial = new GRNMaterials();
objGRNMaterial.GRN = objGRN_DL.Get(Convert.ToInt64(dt.Rows[i]["GRNNO"]));
objGRNMaterial.GrossQty = Convert.ToDecimal(dt.Rows[i]["GrossQty"]);
objGRNMaterial.Material = objMaterial_DL.Get(Convert.ToString(dt.Rows[i]["MaterialCode"]));
objGRNMaterial.NetQty = Convert.ToDecimal(dt.Rows[i]["NetQty"]);
objGRNMaterial.Remarks = Convert.ToString(dt.Rows[i]["Remarks"]);
objGRNMaterial.UnitPrice = Convert.ToDecimal(dt.Rows[i]["UnitPrice"]);
objGRNMatCollec.Add(objGRNMaterial);
}
return(objGRNMatCollec);
}
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(GRNMaterials obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@GRNNO", obj.GRN.GRNNo),
new SqlParameter("@MaterialCode", obj.Material.MaterialCode),
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_GRNMaterials", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Update(GRNMaterials obj, long GRNNO, String MaterialCode)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@GRNNO", obj.GRN.GRNNo),
new SqlParameter("@MaterialCode", obj.Material.MaterialCode),
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_MaterialCode", MaterialCode)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_GRNMaterials", 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)
{
Material objMaterial = new Material();
GRNMaterials objGRNMaterialsTemp = new GRNMaterials();
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
{
if (txtNetQty.Text != "0")
{
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 = "N/A";
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);
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;
}
}
