public List <BDMReportExportExcel> GetAppoinmentReporttoExport(BDMReportExport ExportDetail)
{
List <BDMReportExportExcel> appoinments = new List <BDMReportExportExcel>();
using (DbLayer dbLayer = new DbLayer())
{
SqlCommand SqlCmd = new SqlCommand("spSelectBDMAppoinmentReportExport");
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@ClientId", ExportDetail.ClientId);
if (ExportDetail.Date.Year != 1)
{
SqlCmd.Parameters.AddWithValue("@Date", ExportDetail.Date);
}
appoinments = dbLayer.GetEntityList <BDMReportExportExcel>(SqlCmd);
}
return(appoinments);
}
public HttpResponseMessage GetAppoinmentReporttoExport(BDMReportExport objAppointmentDetail)
{
HttpResponseMessage message;
try
{
// BDMAppointmentDetailDAL dal = new BDMAppointmentDetailDAL();
var dynObj = new { result = _obj.GetAppoinmentReporttoExport(objAppointmentDetail) };
message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
}
catch (Exception ex)
{
message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Something wrong. Try Again!" });
ErrorLog.CreateErrorMessage(ex, "BDMAppoinmentDetail", "GetAppoinmentReporttoExport");
}
return(message);
}
