public static int UpdateMappedRooms(etblPropetyPhotoMap etblPropetyPhotoMap) { using (OneFineRateEntities db = new OneFineRateEntities()) { var idParam = new SqlParameter[6]; idParam[0] = new SqlParameter("iPhotoId", etblPropetyPhotoMap.iPhotoId); idParam[1] = new SqlParameter("iPropId", etblPropetyPhotoMap.iPropId); idParam[2] = new SqlParameter("iPhotoCatId", etblPropetyPhotoMap.iPhotoCatId); idParam[3] = new SqlParameter("iPhotoSubCatId", etblPropetyPhotoMap.iPhotoSubCatId); idParam[4] = new SqlParameter("bIsPrimary", etblPropetyPhotoMap.bIsPrimaryR); idParam[5] = new SqlParameter("iActionBy", etblPropetyPhotoMap.iActionBy); var objTblRatePlan = db.Database.ExecuteSqlCommand("spSetPrimaryR_False @iPhotoId, @iPropId, @iPhotoCatId,@iPhotoSubCatId,@bIsPrimary,@iActionBy", idParam); return(1); } }
public static etblPropetyPhotoMap GetRecordById(long photoMapId) { etblPropetyPhotoMap etblPropetyPhotoMap = null; using (OneFineRateEntities db = new OneFineRateEntities()) { try { var eobj = db.tblPropertyPhotoMaps.Where(x => x.iPhotoId == photoMapId).FirstOrDefault(); etblPropetyPhotoMap = (etblPropetyPhotoMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new etblPropetyPhotoMap()); } catch (Exception) { throw; } } return(etblPropetyPhotoMap); }
public static int AddRecord(etblPropetyPhotoMap eobj) { int statusCode = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { OneFineRate.tblPropertyPhotoMap dbuser = (OneFineRate.tblPropertyPhotoMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyPhotoMap()); db.tblPropertyPhotoMaps.Add(dbuser); db.SaveChanges(); statusCode = 1; } catch (Exception) { throw; } } return(statusCode); }
public static int UpdateRecord(etblPropetyPhotoMap eobj) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { OneFineRate.tblPropertyPhotoMap obj = (OneFineRate.tblPropertyPhotoMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyPhotoMap()); db.tblPropertyPhotoMaps.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); retval = 1; } catch (Exception) { throw; } } return(retval); }
public ActionResult UpdatePropertyPhotoMap(etblPropetyPhotoMap etblPropetyPhotoMap, long?roomId) { try { bool status = false; string msg = string.Empty; int result = -1; var userId = Convert.ToInt32(((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId); etblPropetyPhotoMap.iActionBy = userId; if (roomId.HasValue) { result = BL_tblPropertyPhotoMap.UpdateMappedRooms(etblPropetyPhotoMap); } else { result = BL_tblPropertyPhotoMap.UpdateMappedProeprty(etblPropetyPhotoMap); } if (result == 1) { TempData["msg"] = "Photo Mapping updated successfully!"; msg = "Photo Mapping updated successfully!"; status = true; } else { TempData["ERROR"] = "Sorry! Something went wrong, Please try refreshing the page."; msg = "Sorry! Something went wrong, Please try refreshing the page."; } var jsonResult = Json(new { status = status, msg = msg }, JsonRequestBehavior.AllowGet); return(jsonResult); } catch (Exception e) { var jsonResult = Json(new { status = false, msg = e.Message }, JsonRequestBehavior.AllowGet); return(jsonResult); } }
public ActionResult Index(IEnumerable <HttpPostedFileBase> photos) { try { bool isSavedSuccessfully = false; if (photos != null) { if (Session["PropId"] != null) { var propertyId = Convert.ToInt32(Session["PropId"].ToString()); IList <etblPropetyPhotoMap> etblPropetyImageMList = new List <etblPropetyPhotoMap>(); string s_propertyId = propertyId.ToString(); //if(propertyId < 10) //{ // s_propertyId = "00" + propertyId.ToString(); //} //else if(propertyId < 100) //{ // s_propertyId = "0" + propertyId.ToString(); //} foreach (var uploadedFile in photos) { if (IsValideImage(uploadedFile)) { using (MemoryStream target = new MemoryStream()) { uploadedFile.InputStream.CopyTo(target); byte[] data = target.ToArray(); var uniqueFileName = Guid.NewGuid().ToString() + Path.GetExtension(uploadedFile.FileName); var currentUploadedFileUrl = clsUtils.fnUploadFileINBlobStorage(s_propertyId, uniqueFileName, data, true); System.Drawing.Image image = System.Drawing.Image.FromStream(new System.IO.MemoryStream(data)); var etblPropertyPhotoMap = new etblPropetyPhotoMap(); etblPropertyPhotoMap.iPropId = propertyId; etblPropertyPhotoMap.bIsMapped = false; etblPropertyPhotoMap.sImgUrl = propertyId.ToString() + "/" + uniqueFileName; etblPropertyPhotoMap.UniqueAzureFileName = uniqueFileName; etblPropertyPhotoMap.dtActionDate = DateTime.Now; etblPropertyPhotoMap.iActionBy = Convert.ToInt16(((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId); if (image.Height >= 1080 && image.Width >= 1360) { etblPropertyPhotoMap.bIsHighRes = true; } else { etblPropertyPhotoMap.bIsHighRes = false; } etblPropertyPhotoMap.iResolutionH = (short)image.Height; etblPropertyPhotoMap.iResolutionW = (short)image.Width; etblPropetyImageMList.Add(etblPropertyPhotoMap); } } else { TempData["ERROR"] = "Invalid Images ! Please upload only .jpg, .png, .jpeg or .bmp images"; return(View()); } } BL_tblPropertyPhotoMap.AddMultipleRecord(etblPropetyImageMList.ToArray()); isSavedSuccessfully = true; } if (isSavedSuccessfully) { TempData["msg"] = "Photos uploaded successfully !"; return(Json(new { Message = "Files uploaded successfully !" })); } else { return(Json(new { status = "error", Message = "Error in saving file" })); } } return(View()); } catch (Exception ex) { TempData["ERROR"] = ex.Message; return(Json(new { Message = ex.Message })); } }