public void Execute(IJobExecutionContext context) { PropertyModel PropertyModel = new Models.PropertyModel(); JobDataMap dataMap = context.JobDetail.JobDataMap; int PropertyId = Convert.ToInt32(dataMap.GetString("PropertyId")); string Subject = dataMap.GetString("Subject"); string Body = dataMap.GetString("Body"); string PropertyTypeStatus = dataMap.GetString("PropertyTypeStatus"); CommonClass CommonClass = new Services.CommonClass(); string QStr = ""; DataTable dt = new DataTable(); QStr = "select p.PropertyId,p.Style,p.LocationPrefered,p.PropertyType,c.TrebId,c.FirstName,c.MiddleName,c.LastName,c.EmailId from Property p,Customer c where p.CustomerId=c.CustomerId and p.PropertyId=" + PropertyId; dt = CommonClass.GetDataSet(QStr).Tables[0]; if (dt.Rows.Count > 0) { string FirstName = dt.Rows[0]["FirstName"].ToString() + " " + dt.Rows[0]["MiddleName"].ToString() + " " + dt.Rows[0]["LastName"].ToString(); string EmailId = dt.Rows[0]["EmailId"].ToString(); PropertyModel.PropertyTypeStatus = PropertyTypeStatus; PropertyModel.Style = dt.Rows[0]["Style"].ToString(); PropertyModel.PropertyType = dt.Rows[0]["PropertyType"].ToString(); PropertyModel.LocationPrefered = dt.Rows[0]["LocationPrefered"].ToString(); PropertyModel.CustomerTrebId = dt.Rows[0]["TrebId"].ToString(); SendMailToUser(FirstName, EmailId, PropertyModel); SendMailToAdmin(FirstName, EmailId, PropertyModel, Subject, Body); } }
// // GET: /PropertyEdit/ public ActionResult Index(long?id, string tab) { try { Models.PropertyModel prprty = new Models.PropertyModel(); prprty.CheckInhr = "02"; prprty.CheckOuthr = "12"; if (id.HasValue && id.Value > 0) { long propertyId = id.Value; long ownerId = BLayer.User.GetUserId(User.Identity.Name); if (!BLayer.Property.IsOwnerProperty(id.Value, ownerId)) { return(Redirect("PropertyList")); //current user does not own this property } prprty = GetDetails(id.Value); } else { long ownerId = 0; // = BLayer.User.GetUserId(User.Identity.GetUserId); long.TryParse(User.Identity.GetUserId(), out ownerId); prprty.OwnerId = ownerId; prprty.PropertyId = 0; List <CLayer.Address> adr = BLayer.Address.GetOnUser(ownerId); if (adr.Count > 0) { prprty.State = adr[0].State; prprty.CityId = adr[0].CityId; prprty.City = adr[0].City; prprty.Country = adr[0].CountryId; prprty.LoadPlaces(); } } if (tab == null || tab == "") { prprty.ActiveTab = "home"; } else { prprty.ActiveTab = tab; } return(View(prprty)); } catch (Exception ex) { Common.LogHandler.HandleError(ex); return(Redirect("~/ErrorPage")); } }
public ActionResult Property() { var cus = Session["UserCompany"] as UserCompany; Models.PropertyModel pm = new Models.PropertyModel(); List <Models.ShiftType> sl = new List <Models.ShiftType>(); List <Models.AnnouncementType> al = new List <Models.AnnouncementType>(); var dbo = ProjeDB.DBO.GetInstance(); using (ProjeEntities db = new ProjeEntities()) { var shift = db.Companies.Include("CompanyShifts").Include("CompanyShifts.Shift").Where(x => x.Id == cus.CompanyId).ToList(); foreach (var item in shift) { foreach (var item2 in item.CompanyShifts) { var p = dbo.getPrice(item2.Shift.Id); Models.ShiftType s = new Models.ShiftType(); s.Id = item2.Shift.Id; s.Name = item2.Shift.Name; s.Price = (int)p.Price; s.CardName = item2.Shift.ShiftNumber; sl.Add(s); } } var ann = db.Companies.Include("CompanyAnnouncements").Include("CompanyAnnouncements.Announcement").Where(z => z.Id == cus.CompanyId).ToList(); foreach (var item in ann) { foreach (var item2 in item.CompanyAnnouncements) { Models.AnnouncementType a = new Models.AnnouncementType(); a.Id = item2.Announcement.Id; a.Name = item2.Announcement.Name; al.Add(a); } } pm.ShiftList = sl; pm.AnnList = al; return(View(pm)); } }
public ActionResult AccommodationSave(Models.AccommodationModel data) { try { string userid = User.Identity.GetUserId(); long id = 0; long.TryParse(userid, out id); if (ModelState.IsValid) { CLayer.Accommodation accmdtn = new CLayer.Accommodation() { AccommodationId = data.AccommodationId, PropertyId = data.PropertyId, AccommodationTypeId = data.AccommodationTypeId, StayCategoryId = data.StayCategoryId, AccommodationCount = data.AccommodationCount, Description = data.Description, MaxNoOfPeople = data.MaxNoOfPeople, MaxNoOfChildren = data.MaxNoOfChildren, MinNoOfPeople = data.MinNoOfPeople, BedRooms = data.BedRooms, Area = data.Area, Status = data.Status, TotalAccommodations = data.TotalAccommodations, UpdatedById = id }; long accId = BLayer.Accommodation.Save(accmdtn); Models.PropertyModel property = GetDetails(data.PropertyId); property.ActiveTab = "accommodation"; property.Accommodations.Accommodation = AccommodationGet(accId); //property.Accommodations.Accommodation.ActiveTab = "acc"; return(View("Index", property)); //return RedirectToAction("Index", new { id = data.PropertyId }); } return(Redirect("~/ErrorPage")); } catch (Exception ex) { Common.LogHandler.HandleError(ex); return(Redirect("~/ErrorPage")); } }
public ActionResult PictureDelete(long id) { try { CLayer.PropertyFiles pf = BLayer.PropertyFiles.Get(id); BLayer.PropertyFiles.Delete(id); if (System.IO.File.Exists(Server.MapPath("~/Files/Property/" + pf.PropertyId.ToString() + "/" + pf.FileName))) { System.IO.File.Delete(Server.MapPath("~/Files/Property/" + pf.PropertyId.ToString() + "/" + pf.FileName)); } Models.PropertyModel property = GetDetails(pf.PropertyId); property.ActiveTab = "gallery"; return(View("Index", property)); //return RedirectToAction("Index", new { id = pf.PropertyId }); } catch (Exception ex) { Common.LogHandler.HandleError(ex); return(Redirect("~/ErrorPage")); } }
public ActionResult AccommodationPictureDelete(long id) { try { CLayer.AccommodationFiles pf = BLayer.AccommodationFiles.Get(id); BLayer.AccommodationFiles.Delete(id); if (System.IO.File.Exists(Server.MapPath("~/Files/Property/Accommodation/" + pf.AccommodationId.ToString() + "/" + pf.FileName))) { System.IO.File.Delete(Server.MapPath("~/Files/Property/Accommodation/" + pf.AccommodationId.ToString() + "/" + pf.FileName)); } CLayer.Accommodation ac = BLayer.Accommodation.Get(pf.AccommodationId); Models.PropertyModel property = GetDetails(ac.PropertyId); property.ActiveTab = "accommodation"; property.Accommodations.Accommodation = AccommodationGet(pf.AccommodationId); property.Accommodations.Accommodation.ActiveTab = "pictures"; return(View("Index", property)); //return RedirectToAction("Index", new { id = ac.PropertyId }); } catch (Exception ex) { Common.LogHandler.HandleError(ex); return(Redirect("~/ErrorPage")); } }
public ActionResult AccommodationPictureSave(Models.AccommodationPicturesModel data) { try { if (data.AccommodationId == 0) { Models.PropertyModel property = GetDetails(data.PropertyId); property.ActiveTab = "accommodation"; property.Accommodations.Accommodation = AccommodationGet(data.AccommodationId); property.Accommodations.Accommodation.ActiveTab = "pictures"; return(View("Index", property)); } if (ModelState.IsValid) { #region Save string FileNamePart = data.AccommodationId.ToString() + DateTime.Now.ToString("ddMMyyyyHHmmss"); CLayer.AccommodationFiles acmdtn = new CLayer.AccommodationFiles() { AccommodationId = data.AccommodationId, FileId = data.FileId, FileName = FileNamePart + System.IO.Path.GetFileNameWithoutExtension(data.AccommodationPhoto.FileName) + ".jpg" }; if (data.AccommodationPhoto != null && data.AccommodationPhoto.ContentLength > 0) { int Sizevalue = Convert.ToInt32(ConfigurationManager.AppSettings.Get("FileUploadSizeInMB")); int MaxContentLength = 1024 * 1024 * Sizevalue; //3 MB string[] AllowedFileExtensions = new string[] { ".jpg", ".gif", ".png", ".jpeg" }; if (!AllowedFileExtensions.Contains(data.AccommodationPhoto.FileName.Substring(data.AccommodationPhoto.FileName.LastIndexOf('.')))) { ModelState.AddModelError(string.Empty, "Please use files of type: " + string.Join(", ", AllowedFileExtensions)); } else if (data.AccommodationPhoto.ContentLength > MaxContentLength) { ModelState.AddModelError(string.Empty, "Your file is too large, maximum allowed size is: " + MaxContentLength + " MB"); } else { var fileName = FileNamePart + System.IO.Path.GetFileName(data.AccommodationPhoto.FileName); //uploaded file from UI if (!System.IO.Directory.Exists(Server.MapPath("~/Files/Temp/"))) { System.IO.Directory.CreateDirectory(Server.MapPath("~/Files/Temp/")); } var path = System.IO.Path.Combine(Server.MapPath("~/Files/Temp/"), fileName); data.AccommodationPhoto.SaveAs(path); int maxHeight = Convert.ToInt32(ConfigurationManager.AppSettings.Get("MaxImgHeight")); Image tempimage = Image.FromFile(path); Image resized = Common.Utils.ScaleImage(tempimage, maxHeight); //var fileName = acmdtn.FileName; if (!System.IO.Directory.Exists(Server.MapPath("~/Files/Property/Accommodation/" + data.AccommodationId.ToString() + "/"))) { System.IO.Directory.CreateDirectory(Server.MapPath("~/Files/Property/Accommodation/" + data.AccommodationId.ToString() + "/")); } var path2 = System.IO.Path.Combine(Server.MapPath("~/Files/Property/Accommodation/" + data.AccommodationId.ToString() + "/"), acmdtn.FileName); resized.Save(path2, System.Drawing.Imaging.ImageFormat.Jpeg); try { resized.Dispose(); tempimage.Dispose(); if (System.IO.File.Exists(path)) { System.IO.File.Delete(path); } } catch { } BLayer.AccommodationFiles.Save(acmdtn); ModelState.Clear(); } } #endregion Models.PropertyModel property = GetDetails(data.PropertyId); property.ActiveTab = "accommodation"; property.Accommodations.Accommodation = AccommodationGet(data.AccommodationId); property.Accommodations.Accommodation.ActiveTab = "pictures"; return(View("Index", property)); //return RedirectToAction("Index", new { id = data.PropertyId }); } return(Redirect("~/ErrorPage")); } catch (Exception ex) { Common.LogHandler.HandleError(ex); return(Redirect("~/ErrorPage")); } }
public async Task <ActionResult> SaveDetails(Models.PropertyModel data) { try { if (ModelState.IsValid) { if (data.PropertyFor == 0) { data.PropertyFor = 3; } data.CheckInTime = data.CheckInhr + ":" + data.CheckInmin + " " + data.CheckInclock; data.CheckOutTime = data.CheckOuthr + ":" + data.CheckOutmin + " " + data.CheckOutClock; //data.Description != "" && //if (data.Description.Length > 8000) data.Description = data.Description.Substring(0, 8000); CLayer.Property prprty = new CLayer.Property() { PropertyId = data.PropertyId, Title = data.Title, Description = data.Description, Location = data.Location, Status = (CLayer.ObjectStatus.StatusType)data.Status, OwnerId = BLayer.User.GetUserId(User.Identity.Name), Address = data.Address, Country = data.Country, // CountryId=data.CountryId, State = data.State, City = data.City, CityId = data.CityId, ZipCode = data.ZipCode, Email = data.Email, DistanceFromCity = data.DistanceFromCity, Phone = data.Phone, Mobile = data.Mobile, CheckInTime = data.CheckInTime, CheckOutTime = data.CheckOutTime, CheckInhr = data.CheckInhr, CheckInmin = data.CheckInmin, CheckInclock = data.CheckInclock, CheckOuthr = data.CheckOuthr, CheckOutmin = data.CheckOutmin, CheckOutClock = data.CheckOutClock, AgeLimit = data.AgeLimit, PageTitle = data.PageTitle, MetaDescription = data.MetaDescription, PropertyFor = data.PropertyFor }; string loc = ""; try { string statename = BLayer.State.Get(data.State).Name; string cityname; if (data.CityId < 1) { cityname = data.City; } else { cityname = BLayer.City.Get(data.CityId).Name; data.City = cityname; prprty.City = cityname; } string Countryname = BLayer.Country.Get(data.Country).Name; loc = cityname + "," + statename + "," + Countryname; string qAdddress = data.Title + "," + data.Address + "," + loc; Common.Utils.Location pos; pos = await Common.Utils.GetLocation(qAdddress); prprty.PositionLat = pos.Lattitude.ToString(); prprty.PositionLng = pos.Longitude.ToString(); //string apiQuery = BLayer.Settings.GetValue(CLayer.Settings.GOOGLE_API_QUERY); //apiQuery = apiQuery.Replace("[ADDR]", HttpUtility.UrlEncode(qAdddress)); //apiQuery = apiQuery.Replace("[API]", BLayer.Settings.GetValue(CLayer.Settings.GOOGLE_API_KEY)); //System.Net.Http.HttpClient client = new System.Net.Http.HttpClient(); //string result = await client.GetStringAsync(apiQuery); //System.Xml.XmlDocument doc = new System.Xml.XmlDocument(); //doc.LoadXml(result); //string status = doc.SelectSingleNode("/GeocodeResponse/status").InnerText; //if (status.ToUpper().Trim() == "OK") //{ // string lat = doc.SelectSingleNode("/GeocodeResponse/result/geometry/location/lat").InnerText; // string longitude = doc.SelectSingleNode("/GeocodeResponse/result/geometry/location/lng").InnerText; // prprty.PositionLat = lat; // prprty.PositionLng = longitude; //} } catch (Exception ex) { Common.LogHandler.LogError(ex); } if (data.DistanceFromCity <= 0) { try { Common.Utils.Location pos; pos = await Common.Utils.GetLocation(loc); double lat, lng; lat = lng = 0; double.TryParse(prprty.PositionLat, out lat); double.TryParse(prprty.PositionLng, out lng); // double val = Common.Utils.GetDistance(lat,lng, (double) pos.Lattitude,(double) pos.Longitude); double val = Common.Utils.DistanceCalc(lat, lng, (double)pos.Lattitude, (double)pos.Longitude); //val = val * 1000; prprty.DistanceFromCity = (int)Math.Round(val, 1); if (prprty.DistanceFromCity > 100) { prprty.DistanceFromCity = 0; } } catch (Exception ex) { Common.LogHandler.LogError(ex); } } else { prprty.DistanceFromCity = data.DistanceFromCity; } data.PropertyId = BLayer.Property.Save(prprty); BLayer.Property.SetPosition(data.PropertyId, prprty.PositionLat, prprty.PositionLng); ViewBag.Message = "Saved property."; return(RedirectToAction("Index", new { id = data.PropertyId })); } else { ViewBag.Message = "Error. Please try again"; return(View("Index", data)); } } catch (Exception ex) { Common.LogHandler.HandleError(ex); return(Redirect("~/ErrorPage")); } }
private Models.PropertyModel GetDetails(long propertyid) { Models.PropertyModel prprty = new Models.PropertyModel(); CLayer.Property data = BLayer.Property.Get(propertyid); if (data != null) { if (data.CheckInTime == "" || data.CheckOutTime == "") { data.CheckInTime = "02:00 AM"; data.CheckOutTime = "12:00 PM"; } string a = data.CheckInTime; string[] Intime = a.Split(' '); string Inhrmin = Intime[0]; string[] Inhrmin1 = Inhrmin.Split(':'); string CheckInclock = Intime[1]; string CheckInHr = Inhrmin1[0]; string CheckInMin = Inhrmin1[1]; string b = data.CheckOutTime; string[] Outtime = b.Split(' '); string Outhrmin = Outtime[0]; string[] Outhrmin1 = Outhrmin.Split(':'); string CheckOutclock = Outtime[1]; string CheckOutHr = Outhrmin1[0]; string CheckOutMin = Outhrmin1[1]; prprty = new Models.PropertyModel() { PropertyId = data.PropertyId, Title = data.Title, Description = data.Description, Location = data.Location, Status = (int)data.Status, OwnerId = data.OwnerId, Address = data.Address, ZipCode = data.ZipCode, Landmarks = GetLandmarks(propertyid), Pictures = GetPictures(propertyid), Features = GetFeatures(propertyid), Email = data.Email, Accommodations = GetAccommodations(propertyid), DistanceFromCity = data.DistanceFromCity, Phone = data.Phone, Mobile = data.Mobile, AgeLimit = data.AgeLimit, CheckInhr = CheckInHr, CheckInmin = CheckInMin, CheckInclock = CheckInclock, CheckOuthr = CheckOutHr, CheckOutmin = CheckOutMin, CheckOutClock = CheckOutclock, PageTitle = data.PageTitle, MetaDescription = data.MetaDescription, PropertyFor = data.PropertyFor }; prprty.Country = data.Country; prprty.State = data.State; if (data.City != null && data.City != "") { prprty.City = data.City; } if (data.CityId > 0) { prprty.City = BLayer.City.Get(data.CityId).Name; } prprty.CityId = data.CityId; prprty.LoadPlaces(); } else { prprty.PropertyId = -1; } return(prprty); }