public ActionResult AddCounter(string cityName, string streetName, int houseNumber, int apartmentNumber, float longitude, float latitude) { using (var db = new GazDbContext()) { var result = db.Addresses.Add(new Address { ApartmentNumber = apartmentNumber, CityName = cityName, HouseNumber = houseNumber, StreetName = streetName, latitude = latitude, longitude = longitude, }); db.SaveChanges(); db.Counters.Add(new Counter() { AddressID = result.ID }); db.SaveChanges(); } return Content("נוסף מונה"); }
public ActionResult RemoveUser([DataSourceRequest]DataSourceRequest request, UserModel user) { if (ModelState.IsValid) { using (var db = new GazDbContext()) { var entity = db.Users.Single(o => o.ID == user.ID); db.Users.Remove(entity); db.SaveChanges(); } } return Json(new[] { user }.ToDataSourceResult(request, ModelState)); }
public ActionResult NotificationUpdate([DataSourceRequest] DataSourceRequest request, NotificationModel note) { if (ModelState.IsValid) { using (var db = new GazDbContext()) { var result = db.UserNotifications.Single(o => o.ID == note.NotificationID); result.UserID = note.UserID; result.CreateTime = note.CreateTime; result.Disabled = note.Disabled; result.NotificationDescription = note.NotificationDescription; db.SaveChanges(); } } return Json(new[] { note }.ToDataSourceResult(request, ModelState)); }
public ActionResult AddNewUser([DataSourceRequest]DataSourceRequest request, UserModel model) { using (var db = new GazDbContext()) { db.Users.Add(new User { Email = model.Email, PhoneNumber = model.PhoneNumber, FirstName = model.FirstName, LastName = model.LastName, Password = model.Password, RoleID = model.RoleID, Username = model.Username, }); db.SaveChanges(); } return Json(new[] { model }.ToDataSourceResult(request, ModelState)); }
public ActionResult SubmitComplaint(string desc, int counterId) { desc = desc.Trim(); var userId = GetUserIdFromUserName(User.Identity.Name); using (var db = new GazDbContext()) { var complaint = new UserComplaint { ComplaintDescription = desc, CounterID = counterId, Disable = false, CreateTime = DateTime.Now, UserID = userId }; db.UserComplaints.Add(complaint); db.SaveChanges(); } return null; }
private void SetNotification(int userID, string message) { using (var db = new GazDbContext()) { db.UserNotifications.Add(new UserNotification() { UserID = userID, CreateTime = DateTime.Now, Disabled = false, NotificationDescription = message }); db.SaveChanges(); } }
public ActionResult UsersUpdate([DataSourceRequest]DataSourceRequest request, UserModel user) { if (ModelState.IsValid) { using (var db = new GazDbContext()) { var result = db.Users.Single(o => o.ID == user.ID); result.FirstName = user.FirstName; result.LastName = user.LastName; result.Password = user.Password; result.PhoneNumber = user.PhoneNumber; result.RoleID = user.RoleID; result.Email = user.Email; db.SaveChanges(); } } return Json(new[] { user }.ToDataSourceResult(request, ModelState)); }