public HttpResponseMessage GetIncomeAdjustmentVolUsingParams(HttpRequestMessage request, int Id)
{
return(GetHttpResponse(request, () =>
{
IncomeAdjustmentVolumeSearchMtd obj = new IncomeAdjustmentVolumeSearchMtd();
IncomeAdjustmentVolumeSearchModel ddb = obj.GetIncomeAdjustmentById(Id);
return request.CreateResponse(HttpStatusCode.OK, ddb);
}));
}
} //========== end of the mtd
public Models.IncomeAdjustmentVolumeSearchModel GetIncomeAdjustmentById(int Id)
{
var ddb = new IncomeAdjustmentVolumeSearchModel();
using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
{
var cmd = new System.Data.SqlClient.SqlCommand("Income_adjustment_VolumeSearch_Id", 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 = Id,
});
con.Open();
//cmd.ExecuteNonQuery();
//cmd2.ExecuteNonQuery();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ddb.ID = reader["S/N"] != DBNull.Value ? int.Parse(reader["S/N"].ToString()) : 0;
ddb.Caption = reader["Caption"] != DBNull.Value ? reader["Caption"].ToString() : "default";
ddb.AccountNumber = reader["AccountNumber"] != DBNull.Value ? reader["AccountNumber"].ToString() : "default";
ddb.Refno = reader["Refno"] != DBNull.Value ? reader["Refno"].ToString() : "default";
ddb.customername = reader["customername"] != DBNull.Value ? reader["customername"].ToString() : "default";
ddb.EntryStatus = reader["EntryStatus"] != DBNull.Value ? reader["EntryStatus"].ToString() : "default";
ddb.sbuCode = reader["SBU Code"] != DBNull.Value ? reader["SBU Code"].ToString() : "default";
ddb.MIS_Code = reader["MIS Code"] != DBNull.Value ? reader["MIS Code"].ToString() : "default";
ddb.accountofficercode = reader["accountofficercode"] != DBNull.Value ? reader["accountofficercode"].ToString() : "default";
//ddb.accountofficer = reader["accountofficer"] != DBNull.Value ? reader["accountofficer"].ToString() : "default";
ddb.ActualBalance = reader["ActualBalance"] != DBNull.Value ? decimal.Parse(reader["ActualBalance"].ToString()) : 0;
ddb.AverageBalance = reader["AverageBalance"] != DBNull.Value ? decimal.Parse(reader["AverageBalance"].ToString()) : 0;
ddb.RevExp = reader["RevExp"] != DBNull.Value ? decimal.Parse(reader["RevExp"].ToString()) : 0;
ddb.interestRate = reader["interestRate"] != DBNull.Value ? decimal.Parse(reader["interestRate"].ToString()) : 0;
ddb.PoolRate = reader["PoolRate"] != DBNull.Value ? decimal.Parse(reader["PoolRate"].ToString()) : 0;
ddb.ProductCode = reader["ProductCode"] != DBNull.Value ? reader["ProductCode"].ToString() : "default";
ddb.Category = reader["Category"] != DBNull.Value ? reader["Category"].ToString() : "default";
ddb.Currency_Type = reader["Currency_Type"] != DBNull.Value ? reader["Currency_Type"].ToString() : "default";
ddb.GL_Sub = reader["GL_Sub"] != DBNull.Value ? reader["GL_Sub"].ToString() : "default";
ddb.postedDate = reader["postedDate"] != DBNull.Value ? DateTime.Parse(reader["postedDate"].ToString()) : DateTime.Parse("1000-01-01");
ddb.Period = reader["Period"] != DBNull.Value ? int.Parse(reader["Period"].ToString()) : 0;
ddb.Year = reader["Year"] != DBNull.Value ? int.Parse(reader["Year"].ToString()) : 0;
ddb.Indicator = reader["Indicator"] != DBNull.Value ? reader["Indicator"].ToString() : "default";
}
con.Close();
}
return(ddb);
} //========== end of the mtd
