public HttpResponseMessage GetIncomeCustomerRatingOverride(HttpRequestMessage request, int Id)
{
return(GetHttpResponse(request, () =>
{
HttpResponseMessage response = null;
IncomeCustomerRatingOverrideTEMP icro = _MPRBSService.GetIncomeCustomerRatingOverrideTEMP(Id);
// notice no need to create a seperate model object since AcquirerMapping entity will do just fine
response = request.CreateResponse <IncomeCustomerRatingOverrideTEMP>(HttpStatusCode.OK, icro);
return response;
}));
}
//================ methods to call starts IncomeNewDetails ==========================================
public IEnumerable <IncomeCustomerRatingOverrideTEMP> IncomeCustomerRatingOverrideTEMP(string status)
{
List <IncomeCustomerRatingOverrideTEMP> obuList = new List <IncomeCustomerRatingOverrideTEMP>();
using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
{
var cmd = new System.Data.SqlClient.SqlCommand("", con);
//cmd.CommandText = "select * from Names where Id=@Id";
//cmd.Parameters.AddWithValue("@Id", id);
con.Open();
cmd.CommandText = "select top (@TAKETOP) * from Income_CustomerRating_Override_TEMP where ApprovalStatus=@STATUS";
//cmd.CommandText = "select top 500 Id, Cust_ID, Ref_No, Settlement_Account, Customer_Name, Limit, " +
// "PrincipalOutstandingBal, Value_Date, Maturity_Date, Risk_Rating, ApprovalStatus " +
// "from Income_CustomerRating_Override_TEMP where ApprovalStatus=@STATUS";
cmd.Parameters.AddWithValue("@STATUS", status);
cmd.Parameters.AddWithValue("@TAKETOP", taketop);
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var obu = new IncomeCustomerRatingOverrideTEMP();
obu.Id = reader["Id"] != DBNull.Value ? int.Parse(reader["Id"].ToString()) : 0;
obu.Cust_ID = reader["Cust_ID"] != DBNull.Value ? reader["Cust_ID"].ToString() : "";
obu.Ref_No = reader["Ref_No"] != DBNull.Value ? reader["Ref_No"].ToString() : "";
obu.Settlement_Account = reader["Settlement_Account"] != DBNull.Value ? reader["Settlement_Account"].ToString() : "";
obu.Customer_Name = reader["Customer_Name"] != DBNull.Value ? reader["Customer_Name"].ToString() : "";
obu.Limit = reader["Limit"] != DBNull.Value ? Convert.ToDecimal(reader["Limit"].ToString()) : 0;
obu.PrincipalOutstandingBal = reader["PrincipalOutstandingBal"] != DBNull.Value ? Convert.ToDecimal(reader["PrincipalOutstandingBal"].ToString()) : 0;
//ddb.P_Date = reader["P_Date"] != DBNull.Value ? DateTime.Parse(reader["P_Date"].ToString()) : DateTime.Parse("1000-01-01");
//obu.Value_Date = reader["Value_Date"] != DBNull.Value ? DateTime.Parse(reader["Value_Date"].ToString()) : DateTime.Now;
obu.Value_Date = reader["Value_Date"] != DBNull.Value ? DateTime.Parse(reader["Value_Date"].ToString()) : DateTime.Parse("1000-01-01");
obu.Maturity_Date = reader["Maturity_Date"] != DBNull.Value ? DateTime.Parse(reader["Maturity_Date"].ToString()) : DateTime.Parse("1000-01-01");
obu.Risk_Rating = reader["Risk_Rating"] != DBNull.Value ? reader["Risk_Rating"].ToString() : "";
obu.ApprovalStatus = reader["ApprovalStatus"] != DBNull.Value ? reader["ApprovalStatus"].ToString() : "";
obuList.Add(obu);
}
con.Close();
}
return(obuList);
}
public HttpResponseMessage DeleteIncomeCustomerRatingOverride(HttpRequestMessage request, [FromBody] int Id)
{
return(GetHttpResponse(request, () =>
{
HttpResponseMessage response = null;
// not that calling the WCF service here will authenticate access to the data
IncomeCustomerRatingOverrideTEMP icro = _MPRBSService.GetIncomeCustomerRatingOverrideTEMP(Id);
if (icro != null)
{
_MPRBSService.DeleteIncomeCustomerRatingOverrideTEMP(Id);
response = request.CreateResponse(HttpStatusCode.OK);
}
else
{
response = request.CreateErrorResponse(HttpStatusCode.NotFound, "No record found under that ID.");
}
return response;
}));
}
public HttpResponseMessage UpdateIncomeCustomerRatingOverride(HttpRequestMessage request, [FromBody] IncomeCustomerRatingOverrideTEMP icroModel)
{
return(GetHttpResponse(request, () =>
{
var icro = _MPRBSService.UpdateIncomeCustomerRatingOverrideTEMP(icroModel);
return request.CreateResponse <IncomeCustomerRatingOverrideTEMP>(HttpStatusCode.OK, icro);
}));
}
public IncomeCustomerRatingOverrideTEMP UpdateIncomeCustomerRatingOverrideTEMP(IncomeCustomerRatingOverrideTEMP icro)
{
return(Channel.UpdateIncomeCustomerRatingOverrideTEMP(icro));
}