public void insertfromOpexStaffExpDiffINTORawExpensesFixed_2(OpexStaffExpDiffModel_2 opexstaffexpdiff)
{
using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
{
var cmd = new System.Data.SqlClient.SqlCommand("spp_ExpenseGLR_Insert", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "GL_Code",
Value = opexstaffexpdiff.GL_Code,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Difference",
Value = opexstaffexpdiff.Difference,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "MisCode",
Value = opexstaffexpdiff.miscode,
});
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
public HttpResponseMessage UpdateOpexRawExpensesFixed_2(HttpRequestMessage request, [FromBody] OpexStaffExpDiffModel_2 opexstaffexpdeiff)
{
return(GetHttpResponse(request, () =>
{
//var ratios = _MPRCoreService.UpdateRatios(ratiosModel);
//return request.CreateResponse<Ratios>(HttpStatusCode.OK, ratios);
var comm = "";
HttpResponseMessage res = null;
OpexMtd obj = new OpexMtd();
obj.insertfromOpexStaffExpDiffINTORawExpensesFixed_2(opexstaffexpdeiff);
comm = "Operation Successful.";
res = request.CreateResponse(HttpStatusCode.OK, comm);
return res;
}));
}
