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));
}
