} //========== end of the mtd
//public void AddIncomeAdjustmentVolumeSearch(string MISCODE, string ACCTCODE, string ACCOUNTNUMBER, string CUSTNAME, double BALANCE, double AVERAGE, double INTEREST, string PRODUCTCODE, string CATEGORY, string CURRENCY)
public void AddIncomeAdjustmentVolumeSearch(AddIncomeAdjustmentVolumeSearchModel addv)
{
//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_VolumeAdd", 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 = "miscode",
Value = addv.MISCODE,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Acctcode",
Value = addv.ACCTCODE,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "AccountNumber",
Value = addv.ACCOUNTNUMBER,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Custname",
Value = addv.CUSTNAME,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Balance",
Value = addv.BALANCE,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Average",
Value = addv.AVERAGE,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Intrest",
Value = addv.INTEREST,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "ProductCode",
Value = addv.PRODUCTCODE,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Category",
Value = addv.CATEGORY,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Currency",
Value = addv.CURRENCY,
});
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
//public HttpResponseMessage AddIncomeAdjustmentVol(HttpRequestMessage request, string MISCODE, string ACCTCODE, string ACCOUNTNUMBER, string CUSTNAME, string BALANCE, string AVERAGE, string INTEREST, string PRODUCTCODE, string CATEGORY, string CURRENCY)
public HttpResponseMessage AddIncomeAdjustmentVol(HttpRequestMessage request, [FromBody] AddIncomeAdjustmentVolumeSearchModel addvolumemodel)
{
return(GetHttpResponse(request, () =>
{
IncomeAdjustmentVolumeSearchMtd obj = new IncomeAdjustmentVolumeSearchMtd();
//obj.AddIncomeAdjustmentVolumeSearch(MISCODE, ACCTCODE, ACCOUNTNUMBER, CUSTNAME, BALANCE, AVERAGE, INTEREST, PRODUCTCODE, CATEGORY, CURRENCY);
obj.AddIncomeAdjustmentVolumeSearch(addvolumemodel);
return request.CreateResponse(HttpStatusCode.OK);
}));
}
