public static bool Save(SqlConnection connection, Cost_Adjustment_Model model)
{
bool returnValue = true;
StringBuilder sQuery = new StringBuilder();
try
{
sQuery.Append(@"INSERT INTO a_Cost_Adjustment
(CostAdjustNumber
,idItem
,InitialCost
,InitialQuantity
,AdjustedCostPerUnit
,AdjustedQuantity
,AdjustedAmount
,DocumentNumber
,Transaction_Date
,Remarks
,user_id_chg_by)
VALUES
(@CostAdjustNumber
,@idItem
,@InitialCost
,@InitialQuantity
,@AdjustedCostPerUnit
,@AdjustedQuantity
,@AdjustedAmount
,@DocumentNumber
,@Transaction_Date
,@Remarks
,@user_id_chg_by )");
connection.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = sQuery.ToString();
cmd.CommandType = CommandType.Text;
SqlParameter CostAdjustNumber = new SqlParameter
{
ParameterName = "@CostAdjustNumber",
SqlDbType = SqlDbType.NVarChar,
Value = model.CostAdjustNumber
};
cmd.Parameters.Add(CostAdjustNumber);
SqlParameter idItem = new SqlParameter
{
ParameterName = "@idItem",
SqlDbType = SqlDbType.Int,
Value = model.idItem
};
cmd.Parameters.Add(idItem);
SqlParameter InitialCost = new SqlParameter
{
ParameterName = "@InitialCost",
SqlDbType = SqlDbType.Decimal,
Value = model.InitialCost
};
cmd.Parameters.Add(InitialCost);
SqlParameter InitialQuantity = new SqlParameter
{
ParameterName = "@InitialQuantity",
SqlDbType = SqlDbType.Int,
Value = model.InitialQuantity
};
cmd.Parameters.Add(InitialQuantity);
SqlParameter AdjustedCostPerUnit = new SqlParameter
{
ParameterName = "@AdjustedCostPerUnit",
SqlDbType = SqlDbType.Decimal,
Value = model.AdjustedCostPerUnit
};
cmd.Parameters.Add(AdjustedCostPerUnit);
SqlParameter AdjustedQuantity = new SqlParameter
{
ParameterName = "@AdjustedQuantity",
SqlDbType = SqlDbType.Int,
Value = model.AdjustedQuantity
};
cmd.Parameters.Add(AdjustedQuantity);
SqlParameter AdjustedAmount = new SqlParameter
{
ParameterName = "@AdjustedAmount",
SqlDbType = SqlDbType.Decimal,
Value = model.AdjustedAmount
};
cmd.Parameters.Add(AdjustedAmount);
SqlParameter DocumentNumber = new SqlParameter
{
ParameterName = "@DocumentNumber",
SqlDbType = SqlDbType.NVarChar,
Value = model.DocumentNumber
};
cmd.Parameters.Add(DocumentNumber);
SqlParameter Transaction_Date = new SqlParameter
{
ParameterName = "@Transaction_Date",
SqlDbType = SqlDbType.DateTime,
Value = model.Transaction_Date
};
cmd.Parameters.Add(Transaction_Date);
SqlParameter Remarks = new SqlParameter
{
ParameterName = "@Remarks",
SqlDbType = SqlDbType.NVarChar,
Value = model.Remarks
};
cmd.Parameters.Add(Remarks);
SqlParameter user_id_chg_by = new SqlParameter
{
ParameterName = "@user_id_chg_by",
SqlDbType = SqlDbType.NVarChar,
Value = model.user_id_chg_by
};
cmd.Parameters.Add(user_id_chg_by);
if (cmd.ExecuteNonQuery() >= 1)
{
returnValue = true;
}
cmd.Dispose();
cmd.Parameters.Clear();
}
connection.Close();
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
return(returnValue);
}
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>");
}
}
public static List <Cost_Adjustment_Model> RetreiveData(SqlConnection connection, string CostAdjustNumber)
{
StringBuilder sQuery = new StringBuilder();
sQuery.Append(@"SELECT idCostAdjust
,CostAdjustNumber
,idItem
,InitialCost
,InitialQuantity
,AdjustedCostPerUnit
,AdjustedQuantity
,AdjustedAmount
,DocumentNumber
,Transaction_Date
,Remarks
,user_id_chg_by
FROM a_Cost_Adjustment
WHERE CostAdjustNumber = @CostAdjustNumber
");
var lmodel = new List <Cost_Adjustment_Model>();
connection.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = sQuery.ToString();
cmd.CommandType = CommandType.Text;
SqlParameter parm2 = new SqlParameter
{
ParameterName = "@CostAdjustNumber",
SqlDbType = SqlDbType.NVarChar,
Value = CostAdjustNumber
};
cmd.Parameters.Add(parm2);
var oreader = cmd.ExecuteReader();
while (oreader.Read())
{
Cost_Adjustment_Model oModel = new Cost_Adjustment_Model
{
idCostAdjust = (int)oreader["idCostAdjust"],
CostAdjustNumber = (string)oreader["CostAdjustNumber"],
idItem = (int)oreader["idItem"],
InitialCost = (decimal)oreader["InitialCost"],
InitialQuantity = (int)oreader["InitialQuantity"],
AdjustedCostPerUnit = (decimal)oreader["AdjustedCostPerUnit"],
AdjustedQuantity = (int)oreader["AdjustedQuantity"],
AdjustedAmount = (decimal)oreader["AdjustedAmount"],
DocumentNumber = (string)oreader["DocumentNumber"],
Transaction_Date = (DateTime)oreader["Transaction_Date"],
Remarks = (string)oreader["Remarks"],
user_id_chg_by = (string)oreader["user_id_chg_by"]
};
lmodel.Add(oModel);
}
oreader.Close();
cmd.Dispose();
}
connection.Close();
return(lmodel);
}
