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>"); } }