public HttpResponseMessage CreateBDMAppointmentReport()
{
HttpResponseMessage message;
var BDMAttachments = HttpContext.Current.Request.Files;
var ClientId = HttpContext.Current.Request.Form[0];
var Date = HttpContext.Current.Request.Form[1];
var Calltype = HttpContext.Current.Request.Form[2];
var Remarks = HttpContext.Current.Request.Form[3];
var CreatedBy = HttpContext.Current.Request.Form[4];
BDMAppointmentReportDTO objAppointmentReport = new BDMAppointmentReportDTO();
objAppointmentReport.ClientId = Convert.ToInt32(ClientId);
objAppointmentReport.Date = Convert.ToDateTime(Date);
objAppointmentReport.Calltype = Convert.ToInt32(Calltype);
objAppointmentReport.Remarks = Remarks;
objAppointmentReport.CreatedBy = CreatedBy;
// BDMAppointmentReportDataAccessLayer dal=new BDMAppointmentReportDataAccessLayer();
BDMAttachmentDTO objAttachment = new BDMAttachmentDTO();
bool res = false;
try
{
int id = _obj.InsertBDMAppointmentReport(objAppointmentReport);
if (id != -1)
{
SqlCommand cmd = new SqlCommand("Select Id from BDMAppoinmentReport where Id =" + id + "");
List <string> file_urlList = new List <string>();
for (int i = 0; i < BDMAttachments.Count; i++)
{
string fileName = id + "_" + BDMAttachments[i].FileName;
string path = Path.Combine(HostingEnvironment.MapPath("~/ServeyImages"), fileName);
file_urlList.Add(path);
(BDMAttachments[i] as HttpPostedFile).SaveAs(path);
// BDMAttachmentDataAccessLayer dalAttachment = new BDMAttachmentDataAccessLayer();
_attach.InsertBDMAttachment(new BDMAttachmentDTO
{
AppointmentId = id,
FileUrl = fileName,
});
}
res = true;
}
}
catch (Exception ex)
{
message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Something wrong. Try Again!" });
ErrorLog.CreateErrorMessage(ex, "BDMAppointmentReport", "CreateBDMAppointmentReport");
}
return(message = Request.CreateResponse(HttpStatusCode.OK, new { msgText = "Success!", result = res }));
}
public bool InsertBDMAttachment(BDMAttachmentDTO objAttachment)
{
bool res = false;
SqlCommand SqlCmd = new SqlCommand("spInsertBDMAttachment");
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@AppoinmentId", objAttachment.AppointmentId);
SqlCmd.Parameters.AddWithValue("@FileUrl", objAttachment.FileUrl);
int result = _unitOfWork.DbLayer.ExecuteNonQuery(SqlCmd);
if (result != Int32.MaxValue)
{
res = true;
}
return(res);
}
