private void cmbMRType_SelectedIndexChanged(object sender, EventArgs e)
{
Material objMat = new Material();
BasicProduct objBasic = new BasicProduct();
FinishProduct objFinish = new FinishProduct();
bindItemList.DataSource = null;
objMRFinishhProductCollec.Clear();
objMRMaterialCollec.Clear();
objMRBasicProductCollec.Clear();
try
{
if (cmbMRType.SelectedItem.Equals("Material"))
{
cmbItem.DataSource = objMaterialDL.GetDataView();
cmbItem.DisplayMember = "Material";
cmbItem.ValueMember = "MaterialCode";
objMat = objMaterialDL.Get(cmbItem.SelectedValue.ToString());
if (objMat != null)
{
lblUnit.Text = objMat.MatUnit.UnitCode;
}
}
else if (cmbMRType.SelectedItem.Equals("Basic Products"))
{
cmbItem.DataSource = objBasicProductDL.GetDataView(true);
cmbItem.DisplayMember = "Code";
cmbItem.ValueMember = "BasicProductCode";
objBasic = objBasicProductDL.Get(cmbItem.SelectedValue.ToString());
if (objBasic != null)
{
lblUnit.Text = objBasic.BasicProductUnit.UnitCode;
}
}
else if (cmbMRType.SelectedItem.Equals("Finish Products"))
{
cmbItem.DataSource = objFinishProductDL.GetDataView(1);
cmbItem.DisplayMember = "Code";
cmbItem.ValueMember = "FinishProductCode";
objFinish = objFinishProductDL.Get(cmbItem.SelectedValue.ToString());
if (objFinish != null)
{
lblUnit.Text = objFinish.FinishProductPackingType.PackingTitle;
}
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (cmbFinishProduct.Items.Count <= 0 || txtQuantity.Text.Equals(""))
{
MessageBox.Show(this, "Please Select a Product and enter the Quantity", "Empty Fields", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
if (ItemSelect)
{
objDispatchProductCollec.Delete(objDispatchProduct);
}
bool ItemInList = true;
objFinishProduct = objFinishProductDL.Get(cmbFinishProduct.SelectedValue.ToString());
foreach (DispatchProducts obj in objDispatchProductCollec)
{
if (obj.DispatchFinishProduct.FinishProductCode == objFinishProduct.FinishProductCode)
{
MessageBox.Show(this, "This Product Already added to List, Please select the item from list and update", "Item Already Added", MessageBoxButtons.OK, MessageBoxIcon.Error);
ItemInList = false;
break;
}
}
if (ItemInList)
{
DispatchProducts objTemp = new DispatchProducts();
objTemp.DispatchFinishProduct = objFinishProduct;
objTemp.DispatchQty = Convert.ToDecimal(txtQuantity.Text);
objDispatchProductCollec.Add(objTemp);
ItemInList = true;
ClearItem();
}
else
{
if (ItemSelect)
{
objDispatchProductCollec.Add(objDispatchProduct);
}
}
bindProductList.DataSource = objDispatchProductCollec;
bindProductList.ResetBindings(false);
}
}
catch (FormatException fex)
{
MessageBox.Show(this, "Quantity should be a Numaric value", "Invalid Type", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void cmbItem_SelectedIndexChanged(object sender, EventArgs e)
{
txtGRNUnitCost.Text = "0.00";
cmbGRNNO.Text = "";
txtAvailableQty.Text = "0.00";
txtStockHoldingCost.Text = "0.00";
txtGRNQty.Text = "0.00";
Material objMat = new Material();
BasicProduct objBasic = new BasicProduct();
FinishProduct objFinish = new FinishProduct();
Store objStore = new Store();
try
{
String ItemCode = "";
txtUnit.Text = "";
if (cmbItem.Items.Count > 0 && cmbItem.SelectedValue != null)
{
ItemCode = cmbItem.SelectedValue.ToString();
}
if (cmbStoreFrom.Items.Count > 0)
{
objStore = (Store)cmbStoreFrom.SelectedItem;
}
if (!ItemCode.Equals(""))
{
if (cmbMTNType.SelectedItem.Equals("Material"))
{
cmbGRNNO.DataSource = objGRNDL.Get_GEN_BY_Material(ItemCode, objStore.StoreID);
objMat = objMaterialDL.Get(ItemCode);
txtUnit.Text = objMat.MatUnit.UnitName;
}
else if (cmbMTNType.SelectedItem.Equals("Basic Product"))
{
cmbGRNNO.DataSource = objGRNDL.Get_GEN_BY_BasicProduct(ItemCode, objStore.StoreID);
objBasic = objBasicProductDL.Get(ItemCode);
txtUnit.Text = objBasic.BasicProductUnit.UnitName;
}
else if (cmbMTNType.SelectedItem.Equals("Finish Product"))
{
cmbGRNNO.DataSource = objGRNDL.Get_GEN_BY_FinishProduct(ItemCode, objStore.StoreID);
objFinish = objFinishProductDL.Get(ItemCode);
txtUnit.Text = objFinish.FinishProductPackingType.PackingTitle;
}
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void cmbItem_SelectedIndexChanged(object sender, EventArgs e)
{
Material objMat = new Material();
BasicProduct objBasic = new BasicProduct();
FinishProduct objFinish = new FinishProduct();
try
{
if (cmbMRType.SelectedItem.Equals("Material"))
{
if (cmbItem.SelectedValue != null)
{
objMat = objMaterialDL.Get(cmbItem.SelectedValue.ToString());
if (objMat != null)
{
lblUnit.Text = objMat.MatUnit.UnitCode;
}
else
{
lblUnit.Text = "";
}
}
}
else if (cmbMRType.SelectedItem.Equals("Basic Products"))
{
objBasic = objBasicProductDL.Get(cmbItem.SelectedValue.ToString());
if (objBasic.BasicProductCode != null)
{
lblUnit.Text = objBasic.BasicProductUnit.UnitCode;
}
else
{
lblUnit.Text = "";
}
}
else if (cmbMRType.SelectedItem.Equals("Finish Products"))
{
objFinish = objFinishProductDL.Get(cmbItem.SelectedValue.ToString());
if (objFinish.FinishProductCode != null)
{
lblUnit.Text = objFinish.FinishProductPackingType.PackingTitle;
}
else
{
lblUnit.Text = "";
}
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void cmbFinishProduct_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
objFinishProduct = objFinishProductDL.Get(cmbFinishProduct.SelectedValue.ToString());
lblUnit.Text = objFinishProduct.FinishProductPackingType.PackingTitle;
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public int Update(FinishProduct objFinishProduct, String OriginalCode)
{
try
{
if (objFinishProduct.FinishProductFormula == null)
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@FinishProductCode", objFinishProduct.FinishProductCode),
new SqlParameter("@BasicProductCode", objFinishProduct.BasicProduct.BasicProductCode),
new SqlParameter("@FinishProdutFormulaID", null),
new SqlParameter("@FinishProdutPackingTypeID", objFinishProduct.FinishProductPackingType.PackingID),
new SqlParameter("@FinishProdutDescription", objFinishProduct.FinishProductDescription),
new SqlParameter("@FinishProdutBasicQty", objFinishProduct.BasicProductQty),
new SqlParameter("@FinishProdutAvgCost", objFinishProduct.FinishProductAvgCost),
new SqlParameter("@FinishProdutStatus", objFinishProduct.FinishProductStatus),
new SqlParameter("@PrimaryFinishProductCode", objFinishProduct.FinishProductCode),
new SqlParameter("@PrimaryFinishProductQty", objFinishProduct.PrimaryFinishProductQty),
new SqlParameter("@FinishProductType", objFinishProduct.FinishProductType),
new SqlParameter("@SKUID", objFinishProduct.SKUID),
new SqlParameter("@Original_FinishProductCode", OriginalCode)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_FinishProduct", paramList));
}
else
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@FinishProdutCode", objFinishProduct.FinishProductCode),
new SqlParameter("@BasicProductCode", objFinishProduct.BasicProduct.BasicProductCode),
new SqlParameter("@FinishProdutFormulaID", objFinishProduct.FinishProductFormula.FormulaID),
new SqlParameter("@FinishProdutPackingTypeID", objFinishProduct.FinishProductPackingType.PackingID),
new SqlParameter("@FinishProdutDescription", objFinishProduct.FinishProductDescription),
new SqlParameter("@FinishProdutBasicQty", objFinishProduct.BasicProductQty),
new SqlParameter("@FinishProdutAvgCost", objFinishProduct.FinishProductAvgCost),
new SqlParameter("@FinishProdutStatus", objFinishProduct.FinishProductStatus),
new SqlParameter("@PrimaryFinishProductCode", objFinishProduct.FinishProductCode),
new SqlParameter("@PrimaryFinishProductQty", objFinishProduct.PrimaryFinishProductQty),
new SqlParameter("@FinishProductType", objFinishProduct.FinishProductType),
new SqlParameter("@SKUID", objFinishProduct.SKUID),
new SqlParameter("@Original_FinishProductCode", OriginalCode)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_FinishProduct", paramList));
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
Store objStore = new Store();
objStore.StoreID = CurrStore;
objDepTo = objDepartmentDL.Get(25);
objDepFrom = objDepartmentDL.Get(25);
//objMTN.MTNDate = DateTime.Now;
//objMTN.MTNApprovedBy = null;
objMTN.MTNDepartmentFrom = objDepFrom;
objMTN.MTNDepartmentTo = objDepTo;
objMTN.MTNEnterdBy = CurrentUser.UserEmp;
objMTN.MTNStatus = MTN.Status.Initial;
objMTN.MTNType = MTN.Type.Dispose;
objMTN.MTNStore = objStore;
objMTN.MTNItemType = MTN.ItemType.Finish_Product;
objMTN.MTNItemType = MTN.ItemType.Finish_Product;
objMTN.MTNNo = objMTNDL.Add_FinishedGoodsReturns(objMTN);
//objMTN.MTNNo =
//objMTNDL.Add(objMTN);
if (objMTN.MTNNo > 0)
{
foreach (DataGridViewRow dr in dgvProduct.Rows)
{
String tempproductCode = dr.Cells[0].Value.ToString();
String tempproduct = dr.Cells[1].Value.ToString();
long tempqty = Convert.ToInt64(dr.Cells[2].Value.ToString());
string tempstore = dr.Cells[3].Value.ToString();
objFinishProduct = objFinishProductDL.Get(tempproductCode);
//objMTNFinish.Batch = "No";
//objMTNFinish.Description = "No";
objMTNFinish.FinishProduct = objFinishProduct;
objMTNFinish.MTN = objMTN;
objMTNFinish.ReceivedQty = 0;
objMTNFinish.UnitRate = 0;
objMTNFinish.UnitRate_Budget = 0;
objMTNFinish.TransferQty = tempqty;
objMTNFinisProductDL.Add(objMTNFinish);
}
MessageBox.Show(this, "Successfully Saved, MTN No is " + objMTN.MTNNo, "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
private void cmbItem_SelectedIndexChanged(object sender, EventArgs e)
{
//txtGRNUnitCost.Text = "0.0";
// cmbGRNNO.Text = "";
Material objMat = new Material();
BasicProduct objBasic = new BasicProduct();
FinishProduct objFinish = new FinishProduct();
Store objStore = new Store();
Stock_DL objStockDL = new Stock_DL(ConnectionStringClass.GetConnection());
try
{
String ItemCode = "";
txtUnit.Text = "";
txtAvailableQty.Text = "";
if (cmbItem.Items.Count > 0 && cmbItem.SelectedValue != null)
{
ItemCode = cmbItem.SelectedValue.ToString();
objStore = (Store)cmbStoreFrom.SelectedItem;
if (cmbMTNType.SelectedItem.Equals("Material"))
{
objMat = objMaterialDL.Get(ItemCode);
txtUnit.Text = objMat.MatUnit.UnitName;
//txtGRNUnitCost.Text = objStockDL.GetAVGUnitPrice_Material(objStore.StoreID, ItemCode).ToString();
txtAvailableQty.Text = objStockDL.GetAvailableQty(objStore.StoreID, ItemCode, Stock.Type.Material).ToString();
}
else if (cmbMTNType.SelectedItem.Equals("Basic Product"))
{
objBasic = objBasicProductDL.Get(ItemCode);
txtUnit.Text = objBasic.BasicProductUnit.UnitName;
//txtGRNUnitCost.Text = objStockDL.GetAVGUnitPrice_BasicProduct(objStore.StoreID, ItemCode).ToString();
txtAvailableQty.Text = objStockDL.GetAvailableQty(objStore.StoreID, ItemCode, Stock.Type.BasicProduct).ToString();
}
else if (cmbMTNType.SelectedItem.Equals("Finish Product"))
{
objFinish = objFinishProductDL.Get(ItemCode);
txtUnit.Text = objFinish.FinishProductPackingType.PackingTitle;
//txtGRNUnitCost.Text = objStockDL.GetAVGUnitPrice_FinishProduct(objStore.StoreID, ItemCode).ToString();
txtAvailableQty.Text = objStockDL.GetAvailableQty(objStore.StoreID, ItemCode, Stock.Type.FinishProduct).ToString();
}
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void dgvProductListTertiary_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
objFinishProductTer = objFinishProductDL.Get(dgvProductListTertiary.CurrentRow.Cells["TertiaryProductCode"].Value.ToString());
txtProductCodeTer.Text = objFinishProductTer.FinishProductCode;
txtDescriptionTer.Text = objFinishProductTer.FinishProductDescription;
txtSecondaryQty.Text = objFinishProductTer.PrimaryFinishProductQty.ToString();
txtPeiceRateTer.Text = objFinishProductTer.FinishProductAvgCost.ToString();
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void dgvActivity_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
FinishProduct objFinishProduct = new FinishProduct();
objFinishProduct = objFinishProduct_DL.Get(dgvActivityz.CurrentRow.Cells["PrimaryFinishProduct"].Value.ToString());
objBatchActivity = objBatchActivity_DL.GetByID(Convert.ToInt32(dgvActivityz.CurrentRow.Cells["BatchActID"].Value));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
public string Save_STDBatch()
{
try
{
objStdBatch.STDBatchDescription = txtRemarks.Text;
objStdBatch.STDBatchInstructedBy = CurrentUser.UserEmp;
objStdBatch.STDBatchSize = Convert.ToDecimal(txtBatchSize.Text);
objStdBatch.STDInstructedDate = DateTime.Now;
objStdBatch.STDDuration = Convert.ToDecimal(txtBatchDuration.Text);
if (cmbProductType.SelectedIndex == 0 || cmbProductType.SelectedIndex == 1)
{
BasicProduct objBasic = objBasicProductDL.Get(cmbProductCode.SelectedValue.ToString());
objStdBatch.STDBatchBasicProduct = objBasic;
objStdBatch.STDBatchFinishProduct = new FinishProduct();
objStdBatch.STDBatchType = "Basic";
objStdBatch.STDBatchID = objSTDBatchDL.Add_Basic(objStdBatch);
}
else if (cmbProductType.SelectedIndex == 2)
{
FinishProduct objFinish = objFinishProductDL.Get(cmbProductCode.SelectedValue.ToString());
objStdBatch.STDBatchBasicProduct = new BasicProduct();
objStdBatch.STDBatchFinishProduct = objFinish;
objStdBatch.STDBatchType = "Finish";
}
return(objStdBatch.STDBatchID);
}
catch (FormatException fex)
{
MessageBox.Show(this, "Invalid Data, Please check Standard Batch Size and Duration", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return("No");
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return("No");
}
}
private void dgvActivity_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
FinishProduct objFinishProduct = new FinishProduct();
objFinishProduct = objFinishProduct_DL.Get(dgvActivity.CurrentRow.Cells["SecondaryFinishProduct"].Value.ToString());
objBatchActivity = objBatchActivity_DL.GetByID(Convert.ToInt32(dgvActivity.CurrentRow.Cells["BatchActID"].Value));
btnSendToStore.Enabled = true;
txtProductCode.Text = objFinishProduct.FinishProductCode;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void cmbFinishPart_SelectedIndexChanged(object sender, EventArgs e)
{
FormulaFinishProduct objFormulaFinishProduct = new FormulaFinishProduct();
try
{
if (cmbFinishPart.SelectedIndex != -1)
{
txtFinishProductQty.Text = "0.00";
lblFinishUnit.Text = "";
SelectFinish = false;
if (cmbFinishProducts.Items.Count > 0 && cmbFinishProducts.SelectedItem != null)
{
FinishProduct objFinishProduct = objFinishProductDL.Get(cmbFinishProducts.SelectedValue.ToString());
lblFinishUnit.Text = objFinishProduct.FinishProductPackingType.PackingTitle;
if (objFormula.FormulaID != 0)
{
objFormulaFinishProduct = objFormulaFinishProductDL.Get(objFormula.FormulaID, objFinishProduct.FinishProductCode, cmbFinishPart.SelectedItem.ToString());
if (objFormulaFinishProduct.Formula != null)
{
txtFinishProductQty.Text = objFormulaFinishProduct.FormulaProductQty.ToString();
//cmbFinishPart.SelectedItem = objFormulaFinishProduct.FormulaPart.Trim();
SelectFinish = true;
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
objFormulaFinishProduct = null;
}
}
private void dgvActivity_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
FinishProduct objFinishProduct = new FinishProduct();
objFinishProduct = objFinishProduct_DL.Get(dgvActivity.CurrentRow.Cells["SecondaryFinishProduct"].Value.ToString());
objBatchActivity = objBatchActivity_DL.GetByID(Convert.ToInt32(dgvActivity.CurrentRow.Cells["BatchActID"].Value));
Load_BatchLabourDetails();
Load_BatchMachineDetails();
txtProductCode.Text = objFinishProduct.FinishProductCode;
txtTransferQty.Text = objBatchActivity.StopQty.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void cmbItem_SelectedIndexChanged(object sender, EventArgs e)
{
FinishProduct objMat = new FinishProduct();
try
{
if (cmbItem.SelectedValue != null)
{
objMat = objFinishProduct_DL.Get(cmbItem.SelectedValue.ToString());
if (objMat != null)
{
//
}
else
{
lblUnit.Text = "";
}
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public int Add(FinishProduct objFinishProduct)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@FinishProductCode", objFinishProduct.FinishProductCode),
new SqlParameter("@BasicProductCode", objFinishProduct.BasicProduct.BasicProductCode),
new SqlParameter("@FinishProdutPackingTypeID", objFinishProduct.FinishProductPackingType.PackingID),
new SqlParameter("@FinishProdutDescription", objFinishProduct.FinishProductDescription),
new SqlParameter("@FinishProdutBasicQty", objFinishProduct.BasicProductQty),
new SqlParameter("@FinishProdutAvgCost", objFinishProduct.FinishProductAvgCost),
new SqlParameter("@FinishProdutStatus", objFinishProduct.FinishProductStatus),
new SqlParameter("@PrimaryFinishProductCode", objFinishProduct.PrimaryFinishProductCode),
new SqlParameter("@PrimaryFinishProductQty", objFinishProduct.PrimaryFinishProductQty),
new SqlParameter("@FinishProductType", objFinishProduct.FinishProductType)
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_FinishProduct", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public FinishProduct Get(String FinishProductCode)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@FinishProductCode", FinishProductCode)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_FinishProductByID", paramList);
FinishProduct objFinishProduct = new FinishProduct();
if (dt.Rows.Count > 0)
{
objFinishProduct.BasicProduct = objBasicProduct_DL.Get(Convert.ToString(dt.Rows[0]["BasicProductCode"]));
objFinishProduct.BasicProductQty = Convert.ToDecimal(dt.Rows[0]["FinishProdutBasicQty"]);
objFinishProduct.FinishProductAvgCost = Convert.ToDecimal(dt.Rows[0]["FinishProdutAvgCost"]);
objFinishProduct.FinishProductCode = Convert.ToString(dt.Rows[0]["FinishProductCode"]);
objFinishProduct.FinishProductDescription = Convert.ToString(dt.Rows[0]["FinishProdutDescription"]);
if (dt.Rows[0]["FinishProdutFormulaID"] != null)
{
objFinishProduct.FinishProductFormula = objFormula_DL.Get(Convert.ToInt32(dt.Rows[0]["FinishProdutFormulaID"]));
}
objFinishProduct.FinishProductPackingType = objPackingType_DL.Get(Convert.ToInt64(dt.Rows[0]["FinishProdutPackingTypeID"]));
objFinishProduct.FinishProductStatus = Convert.ToBoolean(dt.Rows[0]["FinishProdutStatus"]);
objFinishProduct.FinishProductType = Convert.ToString(dt.Rows[0]["FinishProductType"]);
objFinishProduct.PrimaryFinishProductQty = Convert.ToDecimal(dt.Rows[0]["PrimaryFinishProductQty"]);
}
return(objFinishProduct);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public FinishProductCollec Get()
{
try
{
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_FinishProduct_DataView");
FinishProductCollec objCollec = new FinishProductCollec();
for (int i = 0; i < dt.Rows.Count; i++)
{
FinishProduct objFinishProduct = new FinishProduct();
objFinishProduct.BasicProduct = objBasicProduct_DL.Get(Convert.ToString(dt.Rows[i]["BasicProductCode"]));
objFinishProduct.BasicProductQty = Convert.ToDecimal(dt.Rows[i]["FinishProdutBasicQty"]);
objFinishProduct.FinishProductAvgCost = Convert.ToDecimal(dt.Rows[i]["FinishProdutAvgCost"]);
objFinishProduct.FinishProductCode = Convert.ToString(dt.Rows[i]["FinishProductCode"]);
objFinishProduct.FinishProductDescription = Convert.ToString(dt.Rows[i]["FinishProductDescription"]);
objFinishProduct.FinishProductFormula = objFormula_DL.Get(Convert.ToInt32(dt.Rows[i]["FinishProdutFormulaID"]));
objFinishProduct.FinishProductPackingType = objPackingType_DL.Get(Convert.ToInt64(dt.Rows[i]["FinishProdutPackingTypeID"]));
objFinishProduct.FinishProductStatus = Convert.ToBoolean(dt.Rows[i]["FinishProductStatus"]);
objFinishProduct.FinishProductType = Convert.ToString(dt.Rows[i]["FinishProductType"]);
objFinishProduct.PrimaryFinishProductQty = Convert.ToDecimal(dt.Rows[i]["PrimaryFinishProductQty"]);
objFinishProduct.SKUID = Convert.ToInt32(dt.Rows[i]["SKUID"]);
objCollec.Add(objFinishProduct);
}
return(objCollec);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
private void cmbBasicProductCode_SelectedIndexChanged(object sender, EventArgs e)
{
txtPackType.Visible = false;
lblPackType.Visible = false;
txtBasicProduct.Visible = false;
txtBasicQty.Visible = false;
lblBasic.Visible = false;
lblBasicQty.Visible = false;
txtBasicProduct.Text = "";
txtBasicQty.Text = "";
txtCatergory.Text = "";
txtPackType.Text = "";
txtProductCode.Text = "";
txtProductName.Text = "";
txtProductType.Text = "";
txtProductUnit.Text = "";
txtSubCatergory.Text = "";
txtFinishProductQty.Text = "0.00";
txtBasicProductQty.Text = "0.00";
txtMaterialQty.Text = "0.00";
cmbFinishPart.SelectedIndex = -1;
cmbBasicPart.SelectedIndex = -1;
cmbMaterialPart.SelectedIndex = -1;
try
{
if (cmbProductCode.Items.Count > 0 && cmbProductCode.SelectedItem != null)
{
if (cmbProductType.SelectedIndex == 0)
{
objBasicProduct = objBasicProductDL.Get(cmbProductCode.SelectedValue.ToString());
txtCatergory.Text = objBasicProduct.BasicProductCategory.Category;
txtProductCode.Text = objBasicProduct.BasicProductCode;
txtProductName.Text = objBasicProduct.BasicProductDescription;
txtProductType.Text = objBasicProduct.BasicProductType;
txtProductUnit.Text = objBasicProduct.BasicProductUnit.UnitCode;
txtSubCatergory.Text = objBasicProduct.BasicProductSubCategory.Category;
objFormula = objBasicProduct.BasicProductFormula;
if (objBasicProduct.BasicProductFormula.FormulaID == 0)
{
objFormula.FormulaInstructedBy = CurrentUser.UserEmp;
objFormula.FormulaInstructedDate = DateTime.Now;
objFormula.FormulaQty = 1000;
objFormula.FormulaUnit = objBasicProduct.BasicProductUnit;
long formulaID = objFormulaDL.Add(objFormula);
if (formulaID > 0)
{
objFormula.FormulaID = formulaID;
objBasicProduct.BasicProductFormula = objFormula;
objBasicProductDL.Update(objBasicProduct, objBasicProduct.BasicProductCode);
}
else
{
MessageBox.Show(this, "There are was an error occured while initializing the Formula, Please Try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
bindItemList.DataSource = objFormulaDL.GetDataView_Items(objBasicProduct.BasicProductFormula.FormulaID);
}
else if (cmbProductType.SelectedIndex == 1)
{
objBasicProduct = objBasicProductDL.Get(cmbProductCode.SelectedValue.ToString());
txtCatergory.Text = objBasicProduct.BasicProductCategory.Category;
txtProductCode.Text = objBasicProduct.BasicProductCode;
txtProductName.Text = objBasicProduct.BasicProductDescription;
txtProductType.Text = objBasicProduct.BasicProductType;
txtProductUnit.Text = objBasicProduct.BasicProductUnit.UnitCode;
txtSubCatergory.Text = objBasicProduct.BasicProductSubCategory.Category;
objFormula = objBasicProduct.BasicProductFormula;
if (objBasicProduct.BasicProductFormula.FormulaID == 0)
{
objFormula.FormulaInstructedBy = CurrentUser.UserEmp;
objFormula.FormulaInstructedDate = DateTime.Now;
objFormula.FormulaQty = 1000;
objFormula.FormulaUnit = objBasicProduct.BasicProductUnit;
long formulaID = objFormulaDL.Add(objFormula);
if (formulaID > 0)
{
objFormula.FormulaID = formulaID;
objBasicProduct.BasicProductFormula = objFormula;
objBasicProductDL.Update(objBasicProduct, objBasicProduct.BasicProductCode);
}
else
{
MessageBox.Show(this, "There are was an error occured while initializing the Formula, Please Try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
bindItemList.DataSource = objFormulaDL.GetDataView_Items(objBasicProduct.BasicProductFormula.FormulaID);
}
else if (cmbProductType.SelectedIndex == 2)
{
objFinishProduct = objFinishProductDL.Get(cmbProductCode.SelectedValue.ToString());
txtPackType.Visible = true;
lblPackType.Visible = true;
txtBasicProduct.Visible = true;
txtBasicQty.Visible = true;
lblBasic.Visible = true;
lblBasicQty.Visible = true;
txtCatergory.Text = objFinishProduct.BasicProduct.BasicProductCategory.Category;
txtPackType.Text = objFinishProduct.FinishProductPackingType.PackingTitle;
txtProductCode.Text = objFinishProduct.FinishProductCode;
txtProductName.Text = objFinishProduct.FinishProductDescription;
txtProductType.Text = "Finish";
txtProductUnit.Text = "N/A";
txtBasicProduct.Text = objFinishProduct.BasicProduct.Code;
txtBasicQty.Text = objFinishProduct.BasicProductQty.ToString();
txtSubCatergory.Text = objFinishProduct.BasicProduct.BasicProductSubCategory.Category;
objFormula = objFinishProduct.FinishProductFormula;
if (objFormula.FormulaID == 0)
{
objFormula.FormulaInstructedBy = CurrentUser.UserEmp;
objFormula.FormulaInstructedDate = DateTime.Now;
objFormula.FormulaQty = 1000;
long formulaID = objFormulaDL.Add_FG(objFormula);
if (formulaID > 0)
{
objFormula.FormulaID = formulaID;
objFinishProduct.FinishProductFormula = objFormula;
objFinishProductDL.Update(objFinishProduct, objFinishProduct.FinishProductCode);
}
else
{
MessageBox.Show(this, "There are was an error occured while initializing the Formula, Please Try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
bindItemList.DataSource = objFormulaDL.GetDataView_Items(objFinishProduct.FinishProductFormula.FormulaID);
}
bindBasicProduct.DataSource = objFormulaBasicProductDL.GetDataView_FormulaID(objFormula.FormulaID);
bindFinishProduct.DataSource = objFormulaFinishProductDL.GetDataView_FormulaID(objFormula.FormulaID);
bindMaterialList.DataSource = objFormulaMaterialDL.GetDataView_FormulaID(objFormula.FormulaID);
}
else
{
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
MTNMaterial objMTNMat = new MTNMaterial();
MTNBasicProduct objMTNBasic = new MTNBasicProduct();
MTNFinishProduct objMTNFinish = new MTNFinishProduct();
Department objDepFrom = new Department();
Department objDepTo = new Department();
Store objStore = new Store();
Material objMaterial = new Material();
FinishProduct objFinishProduct = new FinishProduct();
BasicProduct objBasicProduct = new BasicProduct();
GRN objGRN = new GRN();
try
{
String ItemCode = "";
if (cmbItem.Items.Count > 0 && cmbItem.SelectedValue != null)
{
ItemCode = cmbItem.SelectedValue.ToString();
}
if (cmbDepartmentFrom.Items.Count > 0)
{
objDepFrom = (Department)cmbDepartmentFrom.SelectedItem;
objDepTo = (Department)cmbDepartmentFrom.SelectedItem;
}
if (cmbStoreFrom.Items.Count > 0)
{
objStore = (Store)cmbStoreFrom.SelectedItem;
}
objMTN.MTNDepartmentFrom = objDepFrom;
objMTN.MTNDepartmentTo = objDepTo;
objMTN.MTNEnterdBy = CurrentUser.UserEmp;
objMTN.MTNStatus = MTN.Status.Initial;
objMTN.MTNType = MTN.Type.Dispose;
objMTN.MTNStore = objStore;
if (cmbMTNType.SelectedItem.Equals("Basic Product"))
{
objMTN.MTNItemType = MTN.ItemType.Basic_Product;
objMTN.MTNNo = objMTNDL.Add_Other(objMTN);
if (objMTN.MTNNo > 0)
{
foreach (DataRow dr in dt.Rows)
{
objBasicProduct = objBasicProductDL.Get(dr["ItemCode"].ToString());
objMTNBasic.Batch = "";
objMTNBasic.Description = dr["Remarks"].ToString();
objMTNBasic.BasicProduct = objBasicProduct;
objMTNBasic.MTN = objMTN;
objMTNBasic.TransferQty = Convert.ToDecimal(dr["Qty"].ToString());
objMTNBasicProductDL.Add(objMTNBasic);
}
}
}
else if (cmbMTNType.SelectedItem.Equals("Material"))
{
objMTN.MTNItemType = MTN.ItemType.Material;
objMTN.MTNNo = objMTNDL.Add_Other(objMTN);
if (objMTN.MTNNo > 0)
{
foreach (DataRow dr in dt.Rows)
{
objMaterial = objMaterialDL.Get(dr["ItemCode"].ToString());
objMTNMat.Batch = "";
objMTNMat.Description = dr["Remarks"].ToString();
objMTNMat.Material = objMaterial;
objMTNMat.MTN = objMTN;
objMTNMat.TransferQty = Convert.ToDecimal(dr["Qty"]);
objMTNMaterialDL.Add(objMTNMat);
}
}
}
else if (cmbMTNType.SelectedItem.Equals("Finish Product"))
{
objMTN.MTNItemType = MTN.ItemType.Finish_Product;
objMTN.MTNNo = objMTNDL.Add_Other(objMTN);
if (objMTN.MTNNo > 0)
{
foreach (DataRow dr in dt.Rows)
{
objFinishProduct = objFinishProductDL.Get((cmbItem.SelectedValue.ToString()));
objMTNFinish.Batch = "";
objMTNFinish.Description = dr["Remarks"].ToString();
objMTNFinish.FinishProduct = objFinishProduct;
objMTNFinish.MTN = objMTN;
objMTNFinish.TransferQty = Convert.ToDecimal(dr["Qty"]);
objMTNFinisProductDL.Add(objMTNFinish);
}
}
}
int x = Approve();
if (x > 0)
{
MessageBox.Show(this, "Stock Reduced", "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnItemAdd_Click(object sender, EventArgs e)
{
if (cmbItem.Items.Count <= 0)
{
MessageBox.Show(this, "There are no Items in the List,Selected a Store does not have any Stock", "Empty Item List", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (txtQty.Text.Equals(""))
{
MessageBox.Show(this, "Please enter quantity you want to Transfer", "Empty Field", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (Convert.ToDecimal(txtAvailableQty.Text) < Convert.ToDecimal(txtQty.Text))
{
MessageBox.Show(this, "Insufficient Available Quantity, Please check the quantity that you enterd", "Insufficient Stock", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
try
{
String ItemCode = "";
if (cmbItem.Items.Count > 0 && cmbItem.SelectedValue != null)
{
ItemCode = cmbItem.SelectedValue.ToString();
bool IsInList = false;
if (ItemSelect)
{
foreach (DataRow dr in dt.Rows)
{
if (ItemCode == dr["ItemCode"].ToString())
{
dt.Rows.Remove(dr);
ItemSelect = false;
break;
}
}
}
foreach (DataRow dr in dt.Rows)
{
if (ItemCode == dr["ItemCode"].ToString())
{
MessageBox.Show(this, "Selected Item Already in the List,Please Select the record and Update", "Item Already Added", MessageBoxButtons.OK, MessageBoxIcon.Information);
IsInList = true;
break;
}
}
if (!IsInList)
{
if (cmbMTNType.SelectedItem.Equals("Material"))
{
objMaterial = objMaterialDL.Get(ItemCode);
objMTNMaterial.Batch = "";
objMTNMaterial.Description = txtRemarks.Text;
objMTNMaterial.Material = objMaterial;
objMTNMaterial.MTN = new MTN();
objMTNMaterial.ReceivedQty = 0;
objMTNMaterial.TransferQty = Convert.ToDecimal(txtQty.Text);
objMTNMaterial.UnitRate = 0;
dt.Rows.Add(objMTNMaterial.Material.MaterialCode, objMTNMaterial.Material.MaterialNameCode, objMTNMaterial.Description, objMTNMaterial.TransferQty, objMTNMaterial.Material.MatUnit.UnitCode);
bindMTNList.DataSource = dt;
}
else if (cmbMTNType.SelectedItem.Equals("Basic Product"))
{
objBasicProduct = objBasicProductDL.Get(ItemCode);
objMtnBasic.BasicProduct = objBasicProduct;
objMtnBasic.Batch = "";
objMtnBasic.Description = txtRemarks.Text;
objMtnBasic.MTN = new MTN();
objMtnBasic.ReceivedQty = 0;
objMtnBasic.TransferQty = Convert.ToDecimal(txtQty.Text);
objMtnBasic.UnitRate = 0;
dt.Rows.Add(objMtnBasic.BasicProduct.BasicProductCode, objMtnBasic.BasicProduct.Code, objMtnBasic.Description, objMtnBasic.TransferQty, objMtnBasic.BasicProduct.BasicProductUnit.UnitCode);
bindMTNList.DataSource = dt;
}
else if (cmbMTNType.SelectedItem.Equals("Finish Product"))
{
objFinishProduct = objFinishProductDL.Get(ItemCode);
objMTNFinish.Batch = "";
objMTNFinish.Description = txtRemarks.Text;
objMTNFinish.FinishProduct = objFinishProduct;
objMTNFinish.MTN = new MTN();
objMTNFinish.ReceivedQty = 0;
objMTNFinish.TransferQty = Convert.ToDecimal(txtQty.Text);
objMTNFinish.UnitRate = 0;
dt.Rows.Add(objMTNFinish.FinishProduct.FinishProductCode, objMTNFinish.FinishProduct.Code, objMTNFinish.Description, objMTNFinish.TransferQty, objMTNFinish.FinishProduct.FinishProductPackingType.PackingTitle);
bindMTNList.DataSource = dt;
}
ClearItem();
}
}
}
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
{
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
MTNMaterial objMTNMat = new MTNMaterial();
MTNBasicProduct objMTNBasic = new MTNBasicProduct();
MTNFinishProduct objMTNFinish = new MTNFinishProduct();
Department objDepFrom = new Department();
Department objDepTo = new Department();
Store objStore = new Store();
Material objMaterial = new Material();
FinishProduct objFinishProduct = new FinishProduct();
BasicProduct objBasicProduct = new BasicProduct();
GRN objGRN = new GRN();
try
{
if (cmbGRNNO.Items.Count > 0 && cmbGRNNO.SelectedValue != null)
{
objGRN.GRNNo = Convert.ToInt64(cmbGRNNO.SelectedValue);
}
String ItemCode = "";
if (cmbItem.Items.Count > 0 && cmbItem.SelectedValue != null)
{
ItemCode = cmbItem.SelectedValue.ToString();
}
if (cmbDepartmentFrom.Items.Count > 0)
{
objDepFrom = objDepartmentDL.Get(Convert.ToInt64(cmbDepartmentFrom.SelectedValue));
}
if (cmbDepartmentTo.Items.Count > 0)
{
objDepTo = objDepartmentDL.Get(Convert.ToInt64(cmbDepartmentTo.SelectedValue));
}
if (cmbStoreFrom.Items.Count > 0)
{
objStore = (Store)cmbStoreFrom.SelectedItem;
}
if (!ItemCode.Equals("") && !objGRN.GRNNo.Equals("") && objDepTo != null && objDepFrom != null)
{
if (txtQty.Text.Equals(""))
{
MessageBox.Show(this, "Please enter Valid Quantity for Transfer", "Empty Field", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
if (Convert.ToDecimal(txtQty.Text) > Convert.ToDecimal(txtAvailableQty.Text))
{
MessageBox.Show(this, "Available Quantity is " + txtAvailableQty.Text + ",Transfer quantity cannot be more than available", "Available Quantity Exceed", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
objMTN.MTNDepartmentFrom = objDepFrom;
objMTN.MTNDepartmentTo = objDepTo;
objMTN.MTNEnterdBy = CurrentUser.UserEmp;
objMTN.MTNStatus = MTN.Status.Initial;
objMTN.MTNType = MTN.Type.General;
objMTN.MTNStore = objStore;
if (cmbMTNType.SelectedItem.Equals("Basic Product"))
{
objMTN.MTNItemType = MTN.ItemType.Basic_Product;
objMTN.MTNNo = objMTNDL.Add(objMTN);
if (objMTN.MTNNo > 0)
{
objBasicProduct = objBasicProductDL.Get((cmbItem.SelectedValue.ToString()));
objMTNBasic.Batch = "No";
objMTNBasic.Description = txtRemarks.Text;
objMTNBasic.BasicProduct = objBasicProduct;
objMTNBasic.MTN = objMTN;
objMTNBasic.TransferQty = Convert.ToDecimal(txtQty.Text);
objMTNBasic.UnitRate = Convert.ToDecimal(txtGRNUnitCost.Text) + Convert.ToDecimal(txtStockHoldingCost.Text);
objMTNBasicProductDL.Add(objMTNBasic);
MessageBox.Show(this, "Successfully Saved, MTN No is " + objMTN.MTNNo, "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else if (cmbMTNType.SelectedItem.Equals("Material"))
{
objMTN.MTNItemType = MTN.ItemType.Material;
objMTN.MTNNo = objMTNDL.Add(objMTN);
if (objMTN.MTNNo > 0)
{
objMaterial = objMaterialDL.Get(cmbItem.SelectedValue.ToString());
objMTNMat.Batch = "No";
objMTNMat.Description = txtRemarks.Text;
objMTNMat.Material = objMaterial;
objMTNMat.MTN = objMTN;
objMTNMat.TransferQty = Convert.ToDecimal(txtQty.Text);
objMTNMat.UnitRate = Convert.ToDecimal(txtGRNUnitCost.Text) + Convert.ToDecimal(txtStockHoldingCost.Text);
objMTNMaterialDL.Add(objMTNMat);
MessageBox.Show(this, "Successfully Saved, MTN No is " + objMTN.MTNNo, "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else if (cmbMTNType.SelectedItem.Equals("Finish Product"))
{
objMTN.MTNItemType = MTN.ItemType.Finish_Product;
objMTN.MTNNo = objMTNDL.Add(objMTN);
if (objMTN.MTNNo > 0)
{
objFinishProduct = objFinishProductDL.Get((cmbItem.SelectedValue.ToString()));
objMTNFinish.Batch = "No";
objMTNFinish.Description = txtRemarks.Text;
objMTNFinish.FinishProduct = objFinishProduct;
objMTNFinish.MTN = objMTN;
objMTNFinish.TransferQty = Convert.ToDecimal(txtQty.Text);
objMTNFinish.UnitRate = Convert.ToDecimal(txtGRNUnitCost.Text) + Convert.ToDecimal(txtStockHoldingCost.Text);
objMTNFinisProductDL.Add(objMTNFinish);
MessageBox.Show(this, "Successfully Saved, MTN No is " + objMTN.MTNNo, "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
}
else
{
MessageBox.Show(this, "Please check Item, Department and GRN that you selected", "Selection Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
