public HttpResponseMessage GetLatestIncomeSetup(HttpRequestMessage request)
{
return(GetHttpResponse(request, () =>
{
IncomeSetup latestincomesetup = _MPRCoreService.GetLatestIncomeSetup();
return request.CreateResponse <IncomeSetup>(HttpStatusCode.OK, latestincomesetup);
}));
}
public HttpResponseMessage UpdateIncomeSetup(HttpRequestMessage request, [FromBody] IncomeSetup incomeSetupModel)
{
return(GetHttpResponse(request, () =>
{
var incomeSetup = _MPRCoreService.UpdateIncomeSetup(incomeSetupModel);
return request.CreateResponse <IncomeSetup>(HttpStatusCode.OK, incomeSetup);
}));
}
public HttpResponseMessage GetIncomeSetup(HttpRequestMessage request, int ID)
{
return(GetHttpResponse(request, () =>
{
HttpResponseMessage response = null;
IncomeSetup incomeSetup = _MPRCoreService.GetIncomeSetup(ID);
// notice no need to create a seperate model object since CaptionMapping entity will do just fine
response = request.CreateResponse <IncomeSetup>(HttpStatusCode.OK, incomeSetup);
return response;
}));
}
public HttpResponseMessage DeleteIncomeSetup(HttpRequestMessage request, [FromBody] int ID)
{
return(GetHttpResponse(request, () =>
{
HttpResponseMessage response = null;
// not that calling the WCF service here will authenticate access to the data
IncomeSetup incomeSetup = _MPRCoreService.GetIncomeSetup(ID);
if (incomeSetup != null)
{
_MPRCoreService.DeleteIncomeSetup(ID);
response = request.CreateResponse(HttpStatusCode.OK);
}
else
{
response = request.CreateErrorResponse(HttpStatusCode.NotFound, "No IncomeSetup found under that ID.");
}
return response;
}));
}
} //========== end of the mtd
public IncomeSetup GetLatestIncomeSetUp()
{
IncomeSetup incomesetup = new IncomeSetup();
using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
{
var cmd = new System.Data.SqlClient.SqlCommand("latestincomesetup", 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 = "searchvalue",
// Value = SearchValue,
//});
con.Open();
//cmd.ExecuteNonQuery();
//cmd2.ExecuteNonQuery();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
//AccountCustomerModel pObj = new AccountCustomerModel();
// progressInfo.TotalCount = reader["teambankid"] != DBNull.Value ? int.Parse(reader["teambankid"].ToString()) : 0;
incomesetup.Year = reader["Year"] != DBNull.Value ? int.Parse(reader["Year"].ToString()) : 0;
incomesetup.CurrentPeriod = reader["CurrentPeriod"] != DBNull.Value ? int.Parse(reader["CurrentPeriod"].ToString()) : 0;
}
con.Close();
}
return(incomesetup);
} //========== end of the mtd
