//public void UpdateIncomeAdjustmentVolumeSearch(Int64 ID, string MISCODE, string ACCTCODE, int PERIOD, int YEAR, string ACCOUNTNUMBER, string PRODUCTCODE, string CATEGORY, string CURRENCY, string CUSTNAME, string CAPTION, string ACCOUNTNUMBER1)
public void UpdateIncomeAdjustmentVolumeSearch(UpdateIncomeAdjustmentVolumeSearchModel updatev)
{
//param = param.Replace("FORWARDSLASHXTER", "/");
//param = param.Replace("DOTXTER", ".");
using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
{
var cmd = new System.Data.SqlClient.SqlCommand("income_adjustment_volumeupdate", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
//cmd.Parameters.Add("@result", System.Data.SqlDbType.TinyInt).Direction = System.Data.ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "id",
Value = updatev.ID,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "miscode",
Value = updatev.MISCODE,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Acctcode",
Value = updatev.ACCTCODE,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "period",
Value = updatev.PERIOD,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "YEAR",
Value = updatev.YEAR,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "accountno",
Value = updatev.ACCOUNTNUMBER,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "prodcode",
Value = updatev.PRODUCTCODE,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "category",
Value = updatev.CATEGORY,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Currency",
Value = updatev.CURRENCY,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Custname",
Value = updatev.CUSTNAME,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Caption",
Value = updatev.CAPTION,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "accountno1",
Value = updatev.ACCOUNTNUMBER1,
});
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
//public HttpResponseMessage UpdateIncomeAdjustmentVol(HttpRequestMessage request, int ID, string MISCODE, string ACCTCODE, int PERIOD, int YEAR, string ACCOUNTNUMBER, string PRODUCTCODE, string CATEGORY, string CURRENCY, string CUSTNAME, string CAPTION, string ACCOUNTNUMBER1)
public HttpResponseMessage UpdateIncomeAdjustmentVol(HttpRequestMessage request, [FromBody] UpdateIncomeAdjustmentVolumeSearchModel updatevolumemodel)
{
return(GetHttpResponse(request, () =>
{
//IncomeAdjustmentVolumeSearchMtd obj = new IncomeAdjustmentVolumeSearchMtd();
//obj.UpdateIncomeAdjustmentVolumeSearch(updatevolumemodel);
OtherInfo latestsetup = new OtherInfo();
int currentyear = latestsetup.GetLatestIncomeSetUp().Year;
int currentperiod = latestsetup.GetLatestIncomeSetUp().CurrentPeriod;
if (updatevolumemodel.YEAR == currentyear && updatevolumemodel.PERIOD == currentperiod)
{
IncomeAdjustmentVolumeSearchMtd obj = new IncomeAdjustmentVolumeSearchMtd();
obj.UpdateIncomeAdjustmentVolumeSearch(updatevolumemodel);
}
return request.CreateResponse(HttpStatusCode.OK);
}));
}
