private void Load_CostingResultSheet()
{
if (gvItemList.CurrentRow.Index != -1)
{
if (gvItemList.CurrentRow.Cells["ItemCode"].Value != null)
{
if (objMTN.MTNItemType == MTN.ItemType.Finish_Product)
{
MTNFinishProduct obj = new MTNFinishProduct();
obj = objMTNFinishProduct_DL.Get(objMTN.MTNNo, Convert.ToString(gvItemList.CurrentRow.Cells["ItemCode"].Value));
frmCostingResults_FinishedProduct objForm = new frmCostingResults_FinishedProduct(obj);
objForm.ShowDialog(this);
objForm.StartPosition = FormStartPosition.CenterParent;
}
if (objMTN.MTNItemType == MTN.ItemType.Basic_Product)
{
MTNBasicProduct obj = new MTNBasicProduct();
obj = objMTNBasicProduct_DL.Get(objMTN.MTNNo, Convert.ToString(gvItemList.CurrentRow.Cells["ItemCode"].Value));
frmCostingResults_BasicProduct objForm = new frmCostingResults_BasicProduct(obj);
objForm.ShowDialog(this);
objForm.StartPosition = FormStartPosition.CenterParent;
}
bindItemList.DataSource = objMTNDL.GetDataView(objMTN.MTNNo);
}
}
}
public int Update_Cost(MTNBasicProduct obj, long OriginalMTNNO, String OriginalBasicProductCode)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MTNUnitRate", obj.UnitRate_Budget),
new SqlParameter("@Original_MTNNO", OriginalMTNNO),
new SqlParameter("@Original_MTNBasicProductID", OriginalBasicProductCode)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_MTNBasicProduct_Cost", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Add(MTNBasicProduct obj, String StoreID, long GRNNO)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MTNNO", obj.MTN.MTNNo),
new SqlParameter("@MTNBasicProductID", obj.BasicProduct.BasicProductCode),
new SqlParameter("@MTNDescription", obj.Description),
new SqlParameter("@MTNTransferQty", obj.TransferQty),
new SqlParameter("@MTNUnitRate", obj.UnitRate),
new SqlParameter("@StoreID", obj.MTN.MTNStore.StoreID)
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_MTNBasicProduct_BY_GRN", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Add(MTNBasicProduct obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MTNNO", obj.MTN.MTNNo),
new SqlParameter("@MTNBasicProductID", obj.BasicProduct.BasicProductCode),
new SqlParameter("@MTNBatchNo", obj.Batch),
new SqlParameter("@MTNDescription", obj.Description),
new SqlParameter("@MTNTransferQty", obj.TransferQty),
new SqlParameter("@MTNUnitRate", obj.UnitRate),
new SqlParameter("@MTNRceivedQty", obj.ReceivedQty)
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_MTNBasicProduct", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public MTNBasicProduct Get(long MTNNO, String BasicProductCode)
{
BasicProduct_DL objBasicProduct_DL = new BasicProduct_DL(Connection);
MTN_DL objMTN_DL = new MTN_DL(Connection);
MTNBasicProduct objMTNBasicProduct = new MTNBasicProduct();
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MTNNO", MTNNO),
new SqlParameter("@BasicProductCode", BasicProductCode)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MTNBasicProductByID", paramList);
if (dt.Rows.Count > 0)
{
objMTNBasicProduct.BasicProduct = objBasicProduct_DL.Get(Convert.ToString(dt.Rows[0]["MTNBasicProductID"]));
objMTNBasicProduct.Batch = "No";
objMTNBasicProduct.MTN = objMTN_DL.Get(Convert.ToInt64(dt.Rows[0]["MTNNO"]));
objMTNBasicProduct.ReceivedQty = Convert.ToDecimal(dt.Rows[0]["MTNRceivedQty"]);
if (dt.Rows[0]["MTNUnitRate"] != DBNull.Value)
{
objMTNBasicProduct.UnitRate = Convert.ToDecimal(dt.Rows[0]["MTNUnitRate"]);
}
if (dt.Rows[0]["MTNTransferQty"] != DBNull.Value)
{
objMTNBasicProduct.TransferQty = Convert.ToDecimal(dt.Rows[0]["MTNTransferQty"]);
}
}
return(objMTNBasicProduct);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Update(MTNBasicProduct obj, long OriginalMTNNO, String OriginalBasicProductCode)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MTNNO", obj.MTN.MTNNo),
new SqlParameter("@MTNBasicProductID", obj.BasicProduct.BasicProductCode),
new SqlParameter("@MTNBatchNo", obj.Description),
new SqlParameter("@MTNDescription", obj.TransferQty),
new SqlParameter("@MTNTransferQty", obj.UnitRate),
new SqlParameter("@MTNUnitRate", obj.MTN.MTNStore.StoreID),
new SqlParameter("@MTNRceivedQty", obj.MTN.MTNStore.StoreID),
new SqlParameter("@Original_MTNNO", obj.MTN.MTNStore.StoreID),
new SqlParameter("@Original_MTNBasicProductID", obj.MTN.MTNStore.StoreID)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_MTNBasicProduct", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
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 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);
}
}
public frmCostingResults_BasicProduct(MTNBasicProduct obj)
{
InitializeComponent();
objMTNBasicProduct = obj;
}
