public ActionResult scallMobileSaveComplaint(mobileComplaintInputs complaintResponse) { try { if (complaintResponse != null) { string refNumber = complaintResponse.Category_Id; var complants = gc.db.SCL_Mobile_Complaints.OrderByDescending(x => x.ID).FirstOrDefault(); if (complants != null) { refNumber = refNumber + (complants.ID + 1); } else { refNumber = refNumber + "000"; } var dt = DateTime.Now; SCL_Mobile_Complaints complaint = new SCL_Mobile_Complaints { Complaint_ReferenceNo = refNumber, Complaint_Date = dt.ToString(), CreatedDate = dt, ComplaintStatus = "Received", CreatedBy = complaintResponse.loggedId.ToString(), Comments = complaintResponse.comments, Dept_Id = complaintResponse.Dept_Id, Dept_Desc = complaintResponse.Dept_Desc, Category_Id = complaintResponse.Category_Id, Category_Desc = complaintResponse.Category_Desc, SubCategory_Id = complaintResponse.SubCategory_Id, SubCategory_Desc = complaintResponse.SubCategory_Desc, Lattitude = complaintResponse.Lattitude, Longitude = complaintResponse.Longitude, Address = complaintResponse.Address, CompanyID = complaintResponse.companyId, AllocateduserID = complaintResponse.loggedId, FileName = refNumber + '_' + complaintResponse.companyId + '_' + complaintResponse.loggedId + ".jpg" }; gc.db.SCL_Mobile_Complaints.Add(complaint); if (gc.db.SaveChanges() > 0) { string filename = refNumber + '_' + complaintResponse.companyId + '_' + complaintResponse.loggedId + ".jpg"; // if (!string.IsNullOrEmpty(complaintResponse.img_data)) { bool imge = SaveImage(complaintResponse.img_data, filename); SCL_ComplaintImages img = new SCL_ComplaintImages(); img.AttachmentName = filename; img.Complaint_ID = complaint.ID; img.Complaint_ReferenceNo = refNumber; img.Device = "mobile"; gc.db.SCL_ComplaintImages.Add(img); gc.db.SaveChanges(); } var res = new MobileAppResponse <string>() { message = "Saved", statusCode = 200 }; return(Json(res, JsonRequestBehavior.AllowGet)); } else { return(Json(new MobileAppResponse <string>() { message = "Not saved", statusCode = 400, }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new MobileAppResponse <string>() { message = "bad request", statusCode = 400, }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(new MobileAppResponse <string>() { message = ex.Message, statusCode = 500, }, JsonRequestBehavior.AllowGet)); } }
public ActionResult SaveComplaint() { int LoginUserCompanyID = Convert.ToInt32(HttpContext.Session["cid_SCL_account"].ToString()); var FormData = Request.Form["FormData"]; var ComplaintMasterResponse = JsonConvert.DeserializeObject <SCL_Mobile_Complaints>(FormData); var files = Request.Files; var Browser = Request.Browser.Browser.ToUpper(); string file_Name = ""; string fileName = ""; Dictionary <string, object> dct = new Dictionary <string, object>(); using (var db = new scallEntities()) { try { string siteURL = WebConfigurationManager.AppSettings["imagePathURL"]; string refNumber = ComplaintMasterResponse.Category_Id; var complants = db.SCL_Mobile_Complaints.OrderByDescending(x => x.ID).FirstOrDefault(); if (complants != null) { refNumber = refNumber + (complants.ID + 1); } else { refNumber = refNumber + "000"; } var date = DateTime.Now; var Depts = db.SCL_Department.Where(x => x.DEPARTMENT_ID == ComplaintMasterResponse.Dept_Id).FirstOrDefault(); var cats = db.SCL_Category.Where(x => x.CATEGORY_ID == ComplaintMasterResponse.Category_Id).FirstOrDefault(); var subCats = db.SCL_Sub_Category.Where(x => x.SUB_CATEGORY_ID == ComplaintMasterResponse.SubCategory_Id).FirstOrDefault(); ComplaintMasterResponse.Dept_Desc = Depts != null?Depts.DEPARTMENT_DESC:""; ComplaintMasterResponse.Category_Desc = cats != null? cats.CATEGORY_DESC:""; ComplaintMasterResponse.SubCategory_Desc = subCats != null ? subCats.SUB_CATEGORY_DESC:""; ComplaintMasterResponse.Complaint_ReferenceNo = refNumber; ComplaintMasterResponse.Complaint_Date = date.ToString(); ComplaintMasterResponse.CreatedDate = DateTime.Now; ComplaintMasterResponse.ComplaintStatus = "Received"; ComplaintMasterResponse.CompanyID = LoginUserCompanyID; db.SCL_Mobile_Complaints.Add(ComplaintMasterResponse); int n = db.SaveChanges(); if (n > 0) { dct.Add("success", true); if (files.Count > 0) { // Get all files from Request object for (int i = 0; i < files.Count; i++) { HttpPostedFileBase file = files[i]; if (Browser == "IE" || Browser == "INTERNETEXPLORER") { string[] testfiles = file.FileName.Split(new char[] { '\\' }); fileName = testfiles[testfiles.Length - 1]; } else { fileName = file.FileName; } fileName = file.FileName; file_Name = string.Format("{0}-{1}", DateTime.Now.ToString("ddMMMyyyyHHmmss"), fileName.Replace("-", "")); fileName = Path.Combine(HttpContext.Server.MapPath("~/Attachments/"), file_Name); file.SaveAs(fileName); SCL_ComplaintImages img = new SCL_ComplaintImages(); //img.AttachmentName = string.Format("{0}/{1}", siteURL, fileName); img.AttachmentName = file_Name; img.Complaint_ID = ComplaintMasterResponse.ID; img.Complaint_ReferenceNo = ComplaintMasterResponse.Complaint_ReferenceNo; db.SCL_ComplaintImages.Add(img); db.SaveChanges(); } } } else { dct.Add("success", false); } } catch (Exception ex) { dct.Add("isError", true); dct.Add("exception", ex.Message); } } return(Json(dct, JsonRequestBehavior.AllowGet)); }