public ActionResult DeleteUser(UserViewModel item) { try { User c = db.Users.Find(item.ToModel().Id); if (c != null) { c.IsDeleted = true; c.DeletionDate = DateTime.Now; //foreach (var i in db.Responses) //{ // //if (i.UserId == c.Id) // //{ // // i.IsDeleted = true; // //} //} foreach (var i in db.Surveys) { if (i.UserId == c.Id) { i.IsDeleted = true; } } db.SaveChanges(); } return(new HttpStatusCodeResult(200)); } catch { LogViewModel l = new LogViewModel { Id = Guid.NewGuid(), CreatedDate = DateTime.Now, Type = "Deletion", Message = "failed to delete user from " + this.CityName + " to database" }; l.AddLog(l); return(new HttpStatusCodeResult(400)); } }
public ActionResult UpdateImage(ImageViewModel item) { try { Image c = db.Images.Find(item.ToModel().Id); if (c != null) { c.Id = item.Id; c.IsDeleted = item.IsDeleted; c.ModifiedDate = DateTime.Now; c.ModifiedUserId = item.ModifiedUserId; c.DeletionDate = item.DeletionDate; c.DeletionUserId = item.DeletionUserId; item.GetAnimateList(item.Animates, c.Animates); c.ImageType = db.ImageTypes.Find(item.ImageTypeId); c.Location = item.Location; //c.CreatedDate = item.CreatedDate; c.CreatedUserId = item.CreatedUserId; c.ImageTypeId = item.ImageTypeId; c.Name = item.Name; c.Name = item.Name; c.Height = item.Height; c.Width = item.Width; db.SaveChanges(); } return(new HttpStatusCodeResult(200)); } catch { LogViewModel l = new LogViewModel { Id = Guid.NewGuid(), CreatedDate = DateTime.Now, Type = "Update", Message = "failed to update image " + this.Name + " to database" }; l.AddLog(l); return(new HttpStatusCodeResult(400)); } }
public ActionResult AddQuestionAnswer(QuestionAnswerViewModel item) { try { QuestionAnswer q = item.ToModel(); q.CreatedDate = DateTime.Now; db.QuestionAnswers.Add(q); db.SaveChanges(); return(new HttpStatusCodeResult(200)); } catch { LogViewModel l = new LogViewModel { Id = Guid.NewGuid(), CreatedDate = DateTime.Now, Type = "Insertion", Message = "failed to insert question answer " + this.Answer + " to database" }; l.AddLog(l); return(new HttpStatusCodeResult(400)); } }
public ActionResult AddImageType(ImageTypeViewModel item) { try { ImageType i = item.ToModel(); i.CreatedDate = DateTime.Now; db.ImageTypes.Add(i); db.SaveChanges(); return(new HttpStatusCodeResult(200)); } catch { LogViewModel l = new LogViewModel { Id = Guid.NewGuid(), CreatedDate = DateTime.Now, Type = "Insertion", Message = "failed to insert image type " + this.Type + " to database" }; l.AddLog(l); return(new HttpStatusCodeResult(400)); } }
public ActionResult AddCountry(CountryViewModel item) { try { Country c = item.ToModel(); c.Cities = item.GetCityList(item.Cities); db.Countries.Add(c); db.SaveChanges(); return(new HttpStatusCodeResult(200)); } catch { LogViewModel l = new LogViewModel { Id = Guid.NewGuid(), CreatedDate = DateTime.Now, Type = "Insertion", Message = "failed to insert country " + this.Name + " to database" }; l.AddLog(l); return(new HttpStatusCodeResult(400)); } }
public ActionResult AddSurvey(SurveyViewModel s) { try { var item = s.ToModel(); item.CreatedDate = DateTime.Now; db.Surveys.Add(item); db.SaveChanges(); return(new HttpStatusCodeResult(200)); } catch { LogViewModel l = new LogViewModel { Id = Guid.NewGuid(), CreatedDate = DateTime.Now, Type = "Insertion", Message = "failed to insert survey from " + this.UserName + " to database" }; l.AddLog(l); return(new HttpStatusCodeResult(400)); } }
//ko, kalau pakai actionresult bgmn? Boleh g? public ActionResult AddAccess() { try { Access a = this.ToModel(); a.CreatedDate = DateTime.Now; db.Accesses.Add(a); db.SaveChanges(); return(new HttpStatusCodeResult(HttpStatusCode.OK)); } catch { LogViewModel l = new LogViewModel { Id = Guid.NewGuid(), CreatedDate = DateTime.Now, Type = "Insertion", Message = "failed to insert access to database" }; l.AddLog(l); return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } }
public ActionResult AddPermission(PermissionViewModel item) { try { Permission p = item.ToModel(); p.CreatedDate = DateTime.Now; db.Permissions.Add(p); db.SaveChanges(); return(new HttpStatusCodeResult(200)); } catch { LogViewModel l = new LogViewModel { Id = Guid.NewGuid(), CreatedDate = DateTime.Now, Type = "Insertion", Message = "failed to insert permission " + this.Name + " to database" }; l.AddLog(l); return(new HttpStatusCodeResult(400)); } }
public ActionResult AddNotification(NotificationViewModel item) { try { Notification n = item.ToModel(); n.CreatedDate = DateTime.Now; db.Notifications.Add(n); db.SaveChanges(); return(new HttpStatusCodeResult(200)); } catch { LogViewModel l = new LogViewModel { Id = Guid.NewGuid(), CreatedDate = DateTime.Now, Type = "Insertion", Message = "failed to sent mail to " + this.ToUsername }; l.AddLog(l); return(new HttpStatusCodeResult(400)); } }
public ActionResult UpdateQuestionAnswer(QuestionAnswerViewModel item) { try { QuestionAnswer c = db.QuestionAnswers.Find(item.ToModel().Id); if (c != null) { c.Id = item.Id; c.IsDeleted = item.IsDeleted; c.ModifiedDate = DateTime.Now; c.ModifiedUserId = item.ModifiedUserId; c.DeletionDate = item.DeletionDate; c.DeletionUserId = item.DeletionUserId; c.Answer = item.Answer; c.OrderNumber = item.OrderNumber; c.Question = db.Questions.Find(item.QuestionId); c.QuestionId = item.QuestionId; c.CreatedUserId = item.CreatedUserId; //c.CreatedDate = item.CreatedDate; db.SaveChanges(); } return(new HttpStatusCodeResult(200)); } catch { LogViewModel l = new LogViewModel { Id = Guid.NewGuid(), CreatedDate = DateTime.Now, Type = "Update", Message = "failed to update question answer " + this.Answer + " to database" }; l.AddLog(l); return(new HttpStatusCodeResult(400)); } }
public ActionResult UpdateAccess() { try { Access c = db.Accesses.Find(this.ToModel().Id); if (c != null) { c.Id = this.Id; c.IsDeleted = this.IsDeleted; c.ModifiedDate = DateTime.Now; c.ModifiedUserId = this.ModifiedUserId; c.DeletionDate = this.DeletionDate; c.DeletionUserId = this.DeletionUserId; c.IsGranted = this.IsGranted; c.Permission = db.Permissions.Find(this.PermissionId); c.PermissionId = this.PermissionId; c.Role = db.Roles.Find(this.RoleId); c.RoleId = this.RoleId; //c.CreatedDate = this.CreatedDate; c.CreatedUserId = this.CreatedUserId; db.SaveChanges(); } return(new HttpStatusCodeResult(HttpStatusCode.OK)); } catch { LogViewModel l = new LogViewModel { Id = Guid.NewGuid(), CreatedDate = DateTime.Now, Type = "Update", Message = "failed to update access to database" }; l.AddLog(l); return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } }
public ActionResult UpdateCity(CityViewModel item) { try { City c = db.Cities.Find(item.ToModel().Id); if (c != null) { c.Id = item.Id; c.CountryId = item.CountryId; c.Name = item.Name; c.ModifiedDate = DateTime.Now; c.ModifiedUserId = item.ModifiedUserId; c.IsDeleted = item.IsDeleted; c.DeletionDate = item.DeletionDate; c.DeletionUserId = item.DeletionUserId; c.Users = item.GetUserList(item.Users); c.Country = db.Countries.Find(c.CountryId); //c.CreatedDate = item.CreatedDate; c.CreatedUserId = item.CreatedUserId; db.SaveChanges(); } return(new HttpStatusCodeResult(200)); } catch { LogViewModel l = new LogViewModel { Id = Guid.NewGuid(), CreatedDate = DateTime.Now, Type = "Update", Message = "failed to update city " + this.Name + " to database" }; l.AddLog(l); return(new HttpStatusCodeResult(400)); } }
public ActionResult AddUser(UserViewModel item) { try { User u = item.ToModel(); u.CreatedDate = DateTime.Now; u.LastLogin = DateTime.Now; db.Users.Add(u); db.SaveChanges(); return(new HttpStatusCodeResult(200)); } catch { LogViewModel l = new LogViewModel { Id = Guid.NewGuid(), CreatedDate = DateTime.Now, Type = "Insertion", Message = "failed to insert user from " + this.CityName + " to database" }; l.AddLog(l); return(new HttpStatusCodeResult(400)); } }
public ActionResult AddSurveyType(SurveyTypeViewModel item) { try { SurveyType c = item.ToModel(); c.Surveys = item.GetSurveyList(item.Surveys); c.CreatedDate = DateTime.Now; db.SurveyTypes.Add(c); db.SaveChanges(); return(new HttpStatusCodeResult(200)); } catch { LogViewModel l = new LogViewModel { Id = Guid.NewGuid(), CreatedDate = DateTime.Now, Type = "Insertion", Message = "failed to insert survey type " + this.Type + " to database" }; l.AddLog(l); return(new HttpStatusCodeResult(400)); } }
public ActionResult UpdateImageType(ImageTypeViewModel item) { try { ImageType c = db.ImageTypes.Find(item.ToModel().Id); if (c != null) { //c.Id = item.Id; c.IsDeleted = item.IsDeleted; c.Images = item.GetImageList(item.Images); c.ModifiedDate = DateTime.Now; c.ModifiedUserId = item.ModifiedUserId; c.Type = item.Type; //c.CreatedDate = item.CreatedDate; c.CreatedUserId = item.CreatedUserId; c.Width = item.Width; c.Height = item.Height; //c.DeletionDate = item.DeletionDate; c.DeletionUserId = item.DeletionUserId; db.SaveChanges(); } return(new HttpStatusCodeResult(200)); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); LogViewModel l = new LogViewModel { Id = Guid.NewGuid(), CreatedDate = DateTime.Now, Type = "Update", Message = message }; l.AddLog(l); db.SaveChanges(); // raise a new exception nesting // the current instance as InnerException } } //catch () //{ // LogViewModel l = new LogViewModel // { // Id = Guid.NewGuid(), // CreatedDate = DateTime.Now, // Type = "Update", // Message = "failed to update image type " + this.Type + " to database" // }; // l.AddLog(l); // return new HttpStatusCodeResult(200); //} return(new HttpStatusCodeResult(200)); } }