public JsonResult EvaluateInspection(InspectionModel model) { var request = db.Inspection.FirstOrDefault(x => x.Id == model.Id); if (request == null) { return(Json(new { Success = false, Message = "No record found!" })); } if (ModelState.IsValid) { request.StatusId = model.StatusId; request.Reason = model.Reason; request.OwnerUpdate = true; try { db.SaveChanges(); } catch (Exception ex) { return(Json(new { Success = false, ErrorMsg = ex.ToString() })); } } else { return(Json(new { Success = false, ErrorMsg = "Invalid Fields." })); } return(Json(new { Success = true, Message = "Evaluation Submitted Successfully" })); }
public IHttpActionResult PutStore(int id, Store store) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } store.Id = id; if (id != store.Id) { return(BadRequest()); } db.Entry(store).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!StoreExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult Create([Bind(Include = "Id,Name,Address")] Store store) { if (ModelState.IsValid) { db.Stores.Add(store); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(store)); }
public ActionResult Create([Bind(Include = "Id,Name,Price")] Product product) { if (ModelState.IsValid) { db.Products.Add(product); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(product)); }
public ActionResult Create([Bind(Include = "SeatID,Ticket")] Seat seat) { if (ModelState.IsValid) { db.Seats.Add(seat); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(seat)); }
public ActionResult Movie_ID([Bind(Include = "Movie_ID,Movie_Name,Genre,Director,Movie_Length,Languages,ReleaseDate")] Movie movie) { if (ModelState.IsValid) { db.Movies.Add(movie); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(movie)); }
public ActionResult Create([Bind(Include = "Id,Name,Address")] Customer customer) { if (ModelState.IsValid) { db.Customers.Add(customer); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(customer)); }
public ActionResult Add_Screen([Bind(Include = "Screen_ID,TheatreID,ScreenName,No_Of_Rows,No_Of_Columns")] Screen screen) { if (ModelState.IsValid) { db.Screens.Add(screen); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.TheatreID = new SelectList(db.Theatres, "Theatre_ID", "Theatre_ID", screen.TheatreID); return(View(screen)); }
public ActionResult Add_Theatre([Bind(Include = "Theatre_ID,Theatre_Name,Theatre_City,MovieID,Manager_Name,Manager_Contact")] Theatre theatre) { if (ModelState.IsValid) { db.Theatres.Add(theatre); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MovieID = new SelectList(db.Movies, "Movie_ID", "Movie_ID", theatre.MovieID); return(View(theatre)); }
public ActionResult Create([Bind(Include = "Id,CustomerId,ProductId,StoreId,DateSold")] ProductSold productSold) { if (ModelState.IsValid) { db.ProductSolds.Add(productSold); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CustomerId = new SelectList(db.Customers, "Id", "Name", productSold.CustomerId); ViewBag.ProductId = new SelectList(db.Products, "Id", "Name", productSold.ProductId); ViewBag.StoreId = new SelectList(db.Stores, "Id", "Name", productSold.StoreId); return(View(productSold)); }
public ActionResult Add_Show([Bind(Include = "Show_ID,ShowStartTime,ShowEndTime,Seat_ID,ShowName,TheatreID,MovieName,ScreenID")] Show show) { if (ModelState.IsValid) { db.Shows.Add(show); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MovieName = new SelectList(db.Movies, "Movie_ID", "Movie_Name", show.MovieName); ViewBag.ScreenID = new SelectList(db.Screens, "Screen_ID", "ScreenName", show.ScreenID); ViewBag.Seat_ID = new SelectList(db.Seats, "SeatID", "Ticket", show.Seat_ID); ViewBag.TheatreID = new SelectList(db.Theatres, "Theatre_ID", "Theatre_Name", show.TheatreID); return(View(show)); }
public static ServiceResponseResult AddPropertyOwnerMarketJob(JobMarketModel marketJob, Login login, HttpFileCollectionBase files = null, string serverPath = null) { using (var db = new KeysEntities()) { var newMarketJob = new TenantJobRequest(); newMarketJob.JobDescription = marketJob.JobDescription; newMarketJob.PropertyId = marketJob.PropertyId; newMarketJob.JobStatusId = 1; // should be OPEN newMarketJob.CreatedBy = login.Email; newMarketJob.CreatedOn = DateTime.UtcNow; newMarketJob.UpdatedOn = DateTime.UtcNow; newMarketJob.UpdatedBy = login.Email; newMarketJob.MaxBudget = marketJob.MaxBudget; newMarketJob.OwnerId = login.Id; newMarketJob.Title = marketJob.Title; db.TenantJobRequest.Add(newMarketJob); try { db.SaveChanges(); var mediaResult = AddMarketJobMedia(files, newMarketJob.Id, serverPath); return(mediaResult.IsSuccess ? new ServiceResponseResult { IsSuccess = true } : new ServiceResponseResult { IsSuccess = false, ErrorMessage = mediaResult.ErrorMessage }); } catch (Exception) { return(new ServiceResponseResult { IsSuccess = false, ErrorMessage = _error }); } } }
public static ServiceResponseResult QuoteViewed(int quoteId) { using (var db = new KeysEntities()) { var quote = db.JobQuote.FirstOrDefault(x => x.Id == quoteId); if (quote == null) { return(new ServiceResponseResult { IsSuccess = false, ErrorMessage = "Can note find quote" }); } if (quote.IsViewed ?? false) { return(new ServiceResponseResult { IsSuccess = false }); } quote.IsViewed = true; try { db.SaveChanges(); return(new ServiceResponseResult { IsSuccess = true }); } catch (Exception ex) { return(new ServiceResponseResult { IsSuccess = false, ErrorMessage = _error }); } } }
public ActionResult Delete(int id) { using (var db = new KeysEntities()) { var delPerson = db.Person.Find(id); // Moved this into the Else statement. Dmitry //var delPersonLogin = db.Login.Find(delPerson.LoginId); // Bug #1185 // Changed AND to an OR. Dmitry if (delPerson == null || delPerson.IsActive == false) { return(Json(new { Result = "norecord", Message = "Cannot find this record !" })); } else { var delPersonLogin = db.Login.Find(delPerson.Id); if (delPersonLogin.UserName == User.Identity.Name) { return(Json(new { Result = "ownrecord", Message = "Admin can not delete their record !" })); } else { delPerson.IsActive = false; delPersonLogin.IsActive = false; db.SaveChanges(); return(Json(new { Result = "success", Message = "Record deleted successfully" })); } } } }
public static ServiceResponseResult RemoveJobQuoteMedia(IEnumerable <int> mediaIds) { using (var db = new KeysEntities()) { foreach (var id in mediaIds) { var jobQuoteMedia = db.JobQuoteMedia.FirstOrDefault(x => x.Id == id); if (jobQuoteMedia != null) { db.JobQuoteMedia.Remove(jobQuoteMedia); } } try { db.SaveChanges(); return(new ServiceResponseResult { IsSuccess = true }); } catch (Exception ex) { return(new ServiceResponseResult { IsSuccess = false }); } } }
public static ServiceResponseResult RemoveFromWatchlist(int marketJobId, Login login) { using (var db = new KeysEntities()) { var result = new ServiceResponseResult { IsSuccess = false }; var item = db.JobWatchList.FirstOrDefault(x => x.PersonId == login.Id && x.MarketJobId == marketJobId); if (item == null) { result.ErrorMessage = "Item not found!"; return(result); } db.JobWatchList.Remove(item); try { db.SaveChanges(); result.IsSuccess = true; return(result); } catch (Exception ex) { result.IsSuccess = false; result.ErrorMessage = "Please try later!"; return(result); } } }
public static ServiceResponseResult DeleteRentallApllication(int rentalApplicationId) { var result = new ServiceResponseResult { IsSuccess = false }; using (var db = new KeysEntities()) { var deleteRentallApllication = db.RentalApplication.Where(x => x.Id == rentalApplicationId).First(); if (deleteRentallApllication == null) { var errorMsg = "Cannot locate the Rental application"; result.ErrorMessage = errorMsg; return(result); } else { deleteRentallApllication.IsActive = false; }; try { db.SaveChanges(); return(new ServiceResponseResult { IsSuccess = true }); } catch (Exception ex) { return(new ServiceResponseResult { IsSuccess = false, ErrorMessage = _error }); } } }
public static PropertyExpense AddOnboardExpense(Login user, List <ExpenseViewModel> model, int PropertyId) { using (var db = new KeysEntities()) { try { var newExpense = new PropertyExpense(); foreach (ExpenseViewModel expense in model) { newExpense.PropertyId = PropertyId; newExpense.Amount = expense.Amount; newExpense.Date = expense.ExpenseDate; newExpense.Description = expense.Description;; newExpense.CreatedBy = user.UserName; newExpense.CreatedOn = DateTime.Today; db.PropertyExpense.Add(newExpense); db.SaveChanges(); } return(newExpense); } catch (Exception ex) { return(null); } } }
//************************************************************************************* public static PropertyRepayment AddOnboardRepayment(Login user, List <RepaymentViewModel> model, int PropertyId) { using (var db = new KeysEntities()) { try { var newRepayment = new PropertyRepayment(); foreach (Service.Models.RepaymentViewModel repayment in model) { newRepayment.PropertyId = PropertyId; newRepayment.Amount = repayment.Amount; newRepayment.EndDate = repayment.EndDate; newRepayment.StartDate = repayment.StartDate; newRepayment.FrequencyType = repayment.FrequencyType; newRepayment.CreatedBy = user.UserName; newRepayment.CreatedOn = DateTime.Today; db.PropertyRepayment.Add(newRepayment); db.SaveChanges(); } return(newRepayment); } catch (Exception) { return(null); } } }
public static bool SavePersonMedia(List <MediaModel> mediaData, int personId) { try { using (var db = new KeysEntities()) { foreach (var item in mediaData) { db.PersonMedia.Add(new PersonMedia() { IsActive = true, NewFilename = item.NewFileName, OldFilename = item.OldFileName, PersonId = personId }); } db.SaveChanges(); } return(true); } catch { return(false); } }
public static ServiceResponseResult DeleteWatchlistItemById(int watchlistId) { var result = new ServiceResponseResult { IsSuccess = false }; using (var db = new KeysEntities()) { var watchlist = db.JobWatchList.FirstOrDefault(x => x.Id == watchlistId); if (watchlist == null) { result.IsSuccess = false; result.ErrorMessage = "Sorry, watchlist not found!"; return(result); } db.JobWatchList.Remove(watchlist); try { db.SaveChanges(); return(new ServiceResponseResult { IsSuccess = true }); } catch (Exception ex) { return(result); } } }
public static ServiceResponseResult ActivateLogin(int loginId) { using (var db = new KeysEntities()) { var login = db.Login.Where(x => x.Id == loginId).FirstOrDefault(); if (login == null) { return(new ServiceResponseResult { IsSuccess = false }); } try { login.EmailConfirmed = true; login.IsActive = true; db.SaveChanges(); return(new ServiceResponseResult { IsSuccess = true }); } catch (Exception ex) { return(new ServiceResponseResult { IsSuccess = false }); } } }
public static ServiceResponseResult ResetActivate(int loginId, string token) { using (var db = new KeysEntities()) { var emailConfirmToken = Guid.NewGuid(); var loginAgain = AccountService.GetAwaitingActivateUserById(loginId, token); if (loginAgain != null) { try { loginAgain.EmailConfirmationToken = emailConfirmToken.ToString(); loginAgain.EmailConfirmationTokenExpiryDate = DateTime.Now.AddHours(2).ToUniversalTime(); // FOR TESTING PURPOSE VALIDITY SET FOR 2 HRS db.Login.Attach(loginAgain); db.Entry(loginAgain).State = EntityState.Modified; db.SaveChanges(); return(new ServiceResponseResult { IsSuccess = true, NewObject = loginAgain.EmailConfirmationToken }); } catch (Exception e) { return(new ServiceResponseResult { IsSuccess = false }); } } else { return(new ServiceResponseResult { IsSuccess = false, ErrorMessage = "OOPS....!!!!You have clicked on the old activation link Or Your Account details are not correct" }); } } }
public static ServiceResponseResult ResetPasswordToken(ForgotPasswordViewModel model, string newToken) { using (var db = new KeysEntities()) { try { var user = db.Login.FirstOrDefault(x => x.Email == model.Email); if (user == null) { return(new ServiceResponseResult { IsSuccess = false, ErrorMessage = "This Email - ID is not registered in the system.Please register!" }); } user.ResetPasswordToken = newToken; user.ResetPasswordTokenExpiryDate = DateTime.Now.AddHours(2); db.SaveChanges(); return(new ServiceResponseResult { IsSuccess = true }); } catch (Exception) { return(new ServiceResponseResult { IsSuccess = false, ErrorMessage = _serverError }); } } }
public static ServiceResponseResult AccepLandlordRequest(int requestId) { using (var db = new KeysEntities()) { var request = db.PropertyRequest.Where(x => x.Id == requestId).FirstOrDefault(); var rId = request.RequestStatusId; if (rId == 2 || rId == 4 || rId == 5) { return(new ServiceResponseResult { IsSuccess = true, ErrorMessage = "Can not update request!" }); } request.RequestStatusId = 2; try { db.SaveChanges(); return(new ServiceResponseResult { IsSuccess = true }); } catch (Exception ex) { return(new ServiceResponseResult { IsSuccess = true, ErrorMessage = _error }); } } }
public static ServiceResponseResult DeclineRequest(RequestModel model, Login login) { using (var db = new KeysEntities()) { var request = db.PropertyRequest.Where(x => x.Id == model.Id).First(); var rId = request.RequestStatusId; if (rId == 2 || rId == 4 || rId == 5) { return(new ServiceResponseResult { IsSuccess = true, ErrorMessage = "Can not update request!" }); } if (request != null) { request.Reason = model.Reason; request.RequestStatusId = 5; request.UpdatedBy = login.Id; request.UpdatedOn = DateTime.UtcNow; } ; try { db.SaveChanges(); return(new ServiceResponseResult { IsSuccess = true }); } catch (Exception) { return(new ServiceResponseResult { IsSuccess = true, ErrorMessage = _error }); } } }
public static ServiceResponseResult AddTenantJobRequest(MarketJobModel model, Login login, HttpFileCollectionBase files = null) { using (var db = new KeysEntities()) { try { var request = db.PropertyRequest.Where(x => x.Id == model.RequestId).FirstOrDefault(); if (request == null) { return new ServiceResponseResult { IsSuccess = false, ErrorMessage = "No record found!" } } ; request.RequestStatusId = (int)JobRequestStatus.Accepted; request.IsUpdated = true; var jobRequest = new TenantJobRequest { PropertyId = model.PropertyId, OwnerId = login.Id, JobDescription = model.JobDescription, JobStatusId = 1, //Bug #2031 (Part 3) MaxBudget = model.MaxBudget, CreatedOn = DateTime.UtcNow, CreatedBy = login.Email, UpdatedOn = DateTime.UtcNow, UpdatedBy = login.Email, Title = model.Title }; db.TenantJobRequest.Add(jobRequest); var mediaFiles = MediaService.SaveFiles(files, 5, AllowedFileType.Images).NewObject as List <MediaModel>; mediaFiles.ForEach(x => jobRequest.TenantJobRequestMedia.Add(new TenantJobRequestMedia { NewFileName = x.NewFileName, OldFileName = x.OldFileName, })); db.SaveChanges(); var perId = request.RecipientId; if (perId.HasValue) { var addr = request.Property.Address; var ten = db.Person.FirstOrDefault(x => x.Id == perId); var tenLog = ten.Login; PropertyOwnerService.SendAcceptRequestEmail(ten.FirstName, tenLog.UserName, addr.ToAddressString()); } return(new ServiceResponseResult { IsSuccess = true }); } catch (Exception ex) { return(new ServiceResponseResult { IsSuccess = false, ErrorMessage = _error }); } } }
public static ServiceResponseResult AddDIYJob(JobModel model, Login login, HttpFileCollectionBase files, string serverPath = null) { using (var db = new KeysEntities()) { try { var newDIYJob = new Job { PropertyId = model.PropertyId, JobDescription = model.JobDescription, JobStatusId = 2, // Should be in pending state as the job hasnt started yet CreatedOn = DateTime.UtcNow, CreatedBy = login.Email, UpdatedOn = DateTime.UtcNow, UpdatedBy = login.Email, PercentDone = 0, OwnerId = login.Id, JobRequestId = model.JobRequestId, PaymentAmount = 0, }; db.Job.Add(newDIYJob); var request = db.PropertyRequest.Where(x => x.Id == model.JobRequestId).FirstOrDefault(); request.RequestStatusId = (int)JobRequestStatus.Accepted; request.IsUpdated = true; //foreach (int fileId in model.FilesCopy) //{ // var propertyRequestMedia1 = db.PropertyRequestMedia.Where(x => x.Id == fileId).FirstOrDefault(); // var newDIYJobMedia = new JobMedia(); // newDIYJobMedia.JobId = newDIYJob.Id; // newDIYJobMedia.NewFileName = propertyRequestMedia1.NewFileName; // newDIYJobMedia.OldFileName = propertyRequestMedia1.OldFileName; // newDIYJobMedia.PropertyId = newDIYJob.PropertyId; // db.JobMedia.Add(newDIYJobMedia); //} var mediaFiles = MediaService.SaveFiles(files, 5, AllowedFileType.Images).NewObject as List <MediaModel>; mediaFiles.ForEach(x => newDIYJob.JobMedia.Add(new JobMedia { NewFileName = x.NewFileName, OldFileName = x.OldFileName, })); db.SaveChanges(); return(new ServiceResponseResult { IsSuccess = true }); } catch (Exception ex) { return(new ServiceResponseResult { IsSuccess = false, ErrorMessage = _error }); } } }
public static ServiceResponseResult EditMarketJob(MarketJobModel model, Login login, HttpFileCollectionBase files = null) { var result = new ServiceResponseResult { IsSuccess = false }; using (var db = new KeysEntities()) { var files1 = model.MediaFiles; var editMarketJob = db.TenantJobRequest.Where(x => x.Id == model.Id).FirstOrDefault(); if (editMarketJob == null) { var errorMsg = "Cannot locate the Job in the Market Place"; result.ErrorMessage = errorMsg; return(result); } else { editMarketJob.JobDescription = model.JobDescription; editMarketJob.MaxBudget = model.MaxBudget; if (model.FilesRemoved != null) { model.FilesRemoved.ToList().ForEach(x => { var media = db.TenantJobRequestMedia.FirstOrDefault(y => y.Id == x); if (media != null) { db.TenantJobRequestMedia.Remove(media); MediaService.RemoveMediaFile(media.NewFileName); } }); } var fileList = MediaService.SaveFiles(files, 5 - editMarketJob.TenantJobRequestMedia.Count(), AllowedFileType.Images).NewObject as List <MediaModel>; if (fileList != null) { fileList.ForEach(x => editMarketJob.TenantJobRequestMedia.Add(new TenantJobRequestMedia { NewFileName = x.NewFileName, OldFileName = x.OldFileName })); } } try { db.SaveChanges(); return(new ServiceResponseResult { IsSuccess = true }); } catch (Exception) { return(new ServiceResponseResult { IsSuccess = false, ErrorMessage = _error }); } } }
public IHttpActionResult PutSale(int id, Keys.Poco.Sale sale) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Sale dbSale = new Sale() { Id = sale.Id, CustomerId = sale.CustomerId, ProductId = sale.ProductId, StoreId = sale.StoreId, Datesold = sale.Datesold }; sale.Id = id; if (id != dbSale.Id) { return(BadRequest()); } db.Entry(dbSale).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!SaleExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }