public HttpResponseMessage GetIncomeRetailProductOverrideTEMP(HttpRequestMessage request, int Id)
{
return(GetHttpResponse(request, () =>
{
HttpResponseMessage response = null;
IncomeRetailProductOverrideTEMP icprb = _MPRBSService.GetIncomeRetailProductOverrideTEMP(Id);
// notice no need to create a seperate model object since AcquirerMapping entity will do just fine
response = request.CreateResponse <IncomeRetailProductOverrideTEMP>(HttpStatusCode.OK, icprb);
return response;
}));
}
public IEnumerable <IncomeRetailProductOverrideTEMP> IncomeRetailProductOverrideTEMPusingparams(string status, string search)
{
List <IncomeRetailProductOverrideTEMP> obuList = new List <IncomeRetailProductOverrideTEMP>();
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 * from Income_RetailProduct_Override_TEMP " +
"where ApprovalStatus=@STATUS and (Customerid like @searchval OR Mis_code like @searchval OR AccountOfficer_Code like @searchval)";
//cmd.CommandText = "select Id, Customerid, Bank, Mis_code, AccountOfficer_Code, ApprovalStatus from Income_RetailProduct_Override_TEMP " +
// "where ApprovalStatus=@STATUS and (Customerid like @searchval OR Mis_code like @searchval OR AccountOfficer_Code like @searchval)";
cmd.Parameters.AddWithValue("@STATUS", status);
cmd.Parameters.AddWithValue("@searchval", "%" + search + "%");
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var obu = new IncomeRetailProductOverrideTEMP();
obu.Id = reader["Id"] != DBNull.Value ? int.Parse(reader["Id"].ToString()) : 0;
obu.Customerid = reader["Customerid"] != DBNull.Value ? int.Parse(reader["Customerid"].ToString()) : 0;
obu.Bank = reader["Bank"] != DBNull.Value ? reader["Bank"].ToString() : "";
obu.Mis_code = reader["Mis_code"] != DBNull.Value ? reader["Mis_code"].ToString() : "";
obu.AccountOfficer_Code = reader["AccountOfficer_Code"] != DBNull.Value ? reader["AccountOfficer_Code"].ToString() : "";
obu.ApprovalStatus = reader["ApprovalStatus"] != DBNull.Value ? reader["ApprovalStatus"].ToString() : "";
obuList.Add(obu);
}
con.Close();
}
return(obuList);
}
public HttpResponseMessage DeleteIncomeRetailProductOverrideTEMP(HttpRequestMessage request, [FromBody] int Id)
{
return(GetHttpResponse(request, () =>
{
HttpResponseMessage response = null;
// not that calling the WCF service here will authenticate access to the data
IncomeRetailProductOverrideTEMP icprb = _MPRBSService.GetIncomeRetailProductOverrideTEMP(Id);
if (icprb != null)
{
_MPRBSService.DeleteIncomeRetailProductOverrideTEMP(Id);
response = request.CreateResponse(HttpStatusCode.OK);
}
else
{
response = request.CreateErrorResponse(HttpStatusCode.NotFound, "No record found under that ID.");
}
return response;
}));
}
//================ methods to call starts IncomeNewDetails ==========================================
public IEnumerable <IncomeRetailProductOverrideTEMP> IncomeRetailProductOverrideTEMP(string status)
{
List <IncomeRetailProductOverrideTEMP> obuList = new List <IncomeRetailProductOverrideTEMP>();
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 500 * from Income_RetailProduct_Override_TEMP where ApprovalStatus=@STATUS";
cmd.CommandText = "select top (@TAKETOP) * from Income_RetailProduct_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 IncomeRetailProductOverrideTEMP();
obu.Id = reader["Id"] != DBNull.Value ? int.Parse(reader["Id"].ToString()) : 0;
obu.Customerid = reader["Customerid"] != DBNull.Value ? int.Parse(reader["Customerid"].ToString()) : 0;
obu.Bank = reader["Bank"] != DBNull.Value ? reader["Bank"].ToString() : "";
obu.Mis_code = reader["Mis_code"] != DBNull.Value ? reader["Mis_code"].ToString() : "";
obu.AccountOfficer_Code = reader["AccountOfficer_Code"] != DBNull.Value ? reader["AccountOfficer_Code"].ToString() : "";
obu.ApprovalStatus = reader["ApprovalStatus"] != DBNull.Value ? reader["ApprovalStatus"].ToString() : "";
obuList.Add(obu);
}
con.Close();
}
return(obuList);
}
public HttpResponseMessage UpdateIncomeRetailProductOverrideTEMP(HttpRequestMessage request, [FromBody] IncomeRetailProductOverrideTEMP icprbModel)
{
return(GetHttpResponse(request, () =>
{
var icprb = _MPRBSService.UpdateIncomeRetailProductOverrideTEMP(icprbModel);
return request.CreateResponse <IncomeRetailProductOverrideTEMP>(HttpStatusCode.OK, icprb);
}));
}
public IncomeRetailProductOverrideTEMP UpdateIncomeRetailProductOverrideTEMP(IncomeRetailProductOverrideTEMP ic)
{
return(Channel.UpdateIncomeRetailProductOverrideTEMP(ic));
}
