protected void btnSearchCA_Click(object sender, EventArgs e)
{
var ldata = Cost_Adjustment.RetreiveData(oCon, txtSearchCA.Text);
txtCostAdjAmt.Text = ldata[0].AdjustedAmount.ToString();
txtCostAdjPerUnit.Text = ldata[0].AdjustedCostPerUnit.ToString();
txtCostAdjQty.Text = ldata[0].AdjustedQuantity.ToString();
txtCostPerUnit.Text = ldata[0].InitialCost.ToString();
txtDocNumber.Text = ldata[0].DocumentNumber.ToString();
txtOnHandCost.Text = ldata[0].InitialCost.ToString();
txtOnHandQty.Text = ldata[0].InitialQuantity.ToString();
txtCARemarks.Text = ldata[0].Remarks.ToString();
var idItem = Item_Master.RetrieveData(oCon, "", "", "", ldata[0].idItem);
txtItemSearch.Text = idItem.Rows[0][3].ToString();
lblTransactionDate.Visible = true;
lblTransactionDate_.Visible = true;
lblTransactionDate.Text = ldata[0].Transaction_Date.ToString();
lblCostAdj.Visible = true;
lblCostAdj_.Visible = true;
lblCostAdj.Text = ldata[0].CostAdjustNumber.ToString();
}
protected void btnSaveCostAdj_Click(object sender, EventArgs e)
{
string CostAdjNum = Cost_Adjustment.GetLastCostAdjNum(oCon);
if (CostAdjNum == null)
{
CostAdjNum = "CF000000";
}
CostAdjNum = CostAdjNum.Substring(2);
int CostAdjNum_ = int.Parse(CostAdjNum) + 1;
string CostAdjNumber = "CF" + CostAdjNum_.ToString("000000");
Cost_Adjustment_Model Cost_Adjustment_Model = new Cost_Adjustment_Model
{
CostAdjustNumber = CostAdjNumber,
idItem = Convert.ToInt32(Session["idItem"].ToString()),
InitialCost = Convert.ToDecimal(txtCostPerUnit.Text),
InitialQuantity = Convert.ToInt32(txtOnHandQty.Text),
AdjustedCostPerUnit = Convert.ToDecimal(txtCostAdjPerUnit.Text),
AdjustedQuantity = Convert.ToInt32(txtCostAdjQty.Text),
AdjustedAmount = Convert.ToDecimal(txtCostAdjAmt.Text),
DocumentNumber = txtDocNumber.Text,
Transaction_Date = DateTime.Now,
Remarks = txtCARemarks.Text,
user_id_chg_by = Session["User_Domain"].ToString()
};
bool save = Cost_Adjustment.Save(oCon, Cost_Adjustment_Model);
if (save == true)
{
bool updateCost = Item_Serial.UpdateCost(oCon, Convert.ToInt32(Session["idItem"].ToString()), Convert.ToDecimal(txtCostAdjPerUnit.Text));
if (updateCost == true)
{
Item_Master.RecomputeItemCost(oCon, Convert.ToInt32(Session["idItem"].ToString()));
Trans_History_Model trans_History_Model = new Trans_History_Model
{
Trans_Code = "COF",
Item_Number = txtItemSearch.Text,
Site = "WH-JMS",
UM = "UT",
Doc_No = txtDocNumber.Text,
Serial_No = "",
Reason_Code = "",
Trans_Date = DateTime.Now,
Order_No = "",
Invoice_No = "",
Reference_No = "",
Trans_Qty = Convert.ToInt32(txtCostAdjQty.Text),
Trans_Amt = Convert.ToDecimal(txtCostAdjAmt.Text),
Remarks = txtCARemarks.Text,
user_domain = Session["User_Domain"].ToString()
};
Trans_History.Save(oCon, trans_History_Model);
HttpContext.Current.Response.Write("<script>alert(" + ControlChars.Quote + "Saving Complete! Cost Adjustment # : " + CostAdjNumber + ControlChars.Quote + ");</script>");
ClearAdj();
}
else
{
HttpContext.Current.Response.Write("<script>alert(" + ControlChars.Quote + "Error in updating cost" + ControlChars.Quote + ");</script>");
}
}
else
{
HttpContext.Current.Response.Write("<script>alert(" + ControlChars.Quote + "Error in saving cost adjustment" + ControlChars.Quote + ");</script>");
}
}
