public AnnexureDTO GetAnnexureReport(AnnexureGetDTO objAnnexureGetDTO)
{
DataSet ds = new DataSet();
AnnexureDTO annuexure = new AnnexureDTO();
using (DbLayer dbLayer = new DbLayer())
{
SqlCommand SqlCmd = new SqlCommand("spAnnexureReportByCustomer");
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@CustomerId", objAnnexureGetDTO.CustomerId);
SqlCmd.Parameters.AddWithValue("@Date", objAnnexureGetDTO.Date);
ds = dbLayer.fillDataSet(SqlCmd);
if (ds.Tables[0].Rows.Count > 0 && ds.Tables[1].Rows.Count > 0)
{
annuexure.CustomerDetail = DataModel.Utilities.Utility.ConvertDataTableToEntityList <AnnexureCustomerDTO>(ds.Tables[0]).FirstOrDefault();
annuexure.AnnexureList = DataModel.Utilities.Utility.ConvertDataTableToEntityList <AnnexureListDTO>(ds.Tables[1]);
}
else
{
annuexure.CustomerDetail = null;
annuexure.AnnexureList = null;
}
}
return(annuexure);
}
public HttpResponseMessage GetAnnexureReport(AnnexureGetDTO objAnnexure)
{
HttpResponseMessage message;
try
{
var dynObj = new { result = _Annexure.GetAnnexureReport(objAnnexure) };
message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
}
catch (Exception ex)
{
message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Somthing wrong, Try Again!" });
ErrorLog.CreateErrorMessage(ex, "Annexure", "GetAnnexureReport");
}
return(message);
}
