public ActionResult ComplaintUpdate([DataSourceRequest] DataSourceRequest request, ComplaintModel comp)
{
if (ModelState.IsValid)
{
using (var db = new GazDbContext())
{
var repo = new UserComplaintsRepository(db);
var result = repo.GetByID(comp.ComplaintID);
if (result != null)
{
result.Disable = comp.Disable;
try
{
repo.Commit();
using (var ms = new MailingService())
{
ms.SendMail_UserComplaintRead(result);
}
}
catch (Exception)
{
return Json(new[] { comp }.ToDataSourceResult(request, ModelState));
}
}
}
}
return Json(new[] { comp }.ToDataSourceResult(request, ModelState));
}
private int GetUserIdFromUserName(string userName)
{
using (var db = new GazDbContext())
{
return db.Users.Single(o => o.Username == userName).ID;
}
}
public ActionResult GetBillImage(int counterId, string dateStr)
{
UserBillModel userBillModel;
var date = DateTime.ParseExact(dateStr, "dd/MM/yyyy", CultureInfo.CurrentCulture);
using (var db = new GazDbContext())
{
var repo = new BillsRepository(db);
var userBill = repo.GetBillByDate(counterId, date);
var user = db.Users.SingleOrDefault(o => o.Username == User.Identity.Name);
var name = user != null ? string.Format("{0} {1}", user.FirstName, user.LastName) : User.Identity.Name;
if (userBill == null)
{
return Content("no image");
}
userBillModel = new UserBillModel(name, userBill.BillAmount.ToString(CultureInfo.InvariantCulture),
userBill.CreateTime, userBill.ID.ToString(CultureInfo.InvariantCulture), userBill.CounterID.ToString());
}
return this.UserBillImage(userBillModel);
}
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 void SendComplaintReadMail()
{
bool isSent = false;
using (var db = new GazDbContext())
{
var repo = new UserComplaintsRepository(db);
var result = repo.GetByID(1005);
if (result != null)
{
result.Disable = true;
try
{
repo.Commit();
using (var ms = new MailingService())
{
isSent = ms.SendMail_UserComplaintRead(result);
}
}
catch (Exception)
{
throw;
}
}
}
Assert.IsTrue(isSent);
}
public void GetCounterForUserID()
{
GazDbContext dbContext = new GazDbContext();
var userRepository = new UserRepository(dbContext);
var user = userRepository.GetUserDetails(1);
Assert.AreEqual("moshemoshe", user.Username);
}
public ActionResult Index()
{
var test = WebSecurity.CurrentUserName;
var db = new GazDbContext();
var repo = new UserRepository(db);
var users = repo.GetAll();
return View(users);
}
public void SetNotificationForMultipleUsers(string message, int[] userIds, bool json)
{
using (var db = new GazDbContext())
{
var repo = new UserNotificationRepository(db);
repo.AddNotificationForMultipleUsers(userIds, message);
repo.Commit();
}
}
public List<NotificationViewModel> GetSystemNotifications()
{
using (var db = new GazDbContext())
{
var userId = db.Users.Single(o => o.Username == User.Identity.Name);
var notifications = db.UserNotifications.Where(o => o.UserID == userId.ID && o.Disabled == false);
return notifications.Select(o => new NotificationViewModel {Content = o.NotificationDescription, CreateTime = o.CreateTime}).ToList();
}
}
private List<SelectListItem> GetListOfUsers()
{
using (var db = new GazDbContext())
{
var users = db.Users.ToList();
return users.Select(user => new SelectListItem
{
Value = user.ID.ToString(CultureInfo.InvariantCulture),
Text = string.Format("{0} - {2},{1}",user.Username, user.FirstName, user.LastName)
}).ToList();
}
}
private List<SelectListItem> GetListOfCounters()
{
using (var db = new GazDbContext())
{
var counters = db.Counters.ToList();
return counters.Select(counter => new SelectListItem
{
Value = counter.ID.ToString(CultureInfo.InvariantCulture),
Text = CounterUiSerivce.GetDetails(counter)
}).ToList();
}
}
public UserModel(int userID, GazDbContext db)
{
var result = db.Users.Single(o => o.ID == userID);
ID = result.ID;
FirstName = result.FirstName;
LastName = result.LastName;
PhoneNumber = result.PhoneNumber;
Email = result.Email;
Password = result.Password;
RoleID = result.RoleID;
Username = result.Username;
}
public JsonResult GetCascadeCounters()
{
using (var db = new GazDbContext())
{
var urepo = new UserRepository(db);
var counters = urepo.GetCountersByUserName(User.Identity.Name)
.Select(counter => new
{
CounterID = counter.ID.ToString(CultureInfo.InvariantCulture),
Address = CounterUiSerivce.GetDetails(counter)
}).ToList();
return Json(counters, JsonRequestBehavior.AllowGet);
}
}
public List<ComplaintModel> GetData()
{
using (var db = new GazDbContext())
{
return db.UserComplaints.Select(o => new ComplaintModel
{
CounterID = o.CounterID,
ComplaintDescription = o.ComplaintDescription,
ComplaintID = o.ID,
CreateTime = o.CreateTime,
Disable = o.Disable,
UserID = o.UserID
}).Where(o => o.Disable == false).ToList();
}
}
private List<NotificationModel> GetData()
{
using (var db = new GazDbContext())
{
return db.UserNotifications.Select(o => new NotificationModel
{
NotificationID = o.ID,
NotificationDescription = o.NotificationDescription,
UserID = o.UserID,
UserName = o.User.FirstName + " " + o.User.LastName,
CreateTime = o.CreateTime,
Disabled = o.Disabled
}).ToList();
}
}
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 GetCountersForUser(int userID)
{
var model = new UserCounterModel(userID);
using (var db = new GazDbContext())
{
for (var index = 0; index < model.Counters.Count; index++)
{
var counter = model.Counters[index];
var reads = db.CounterReads.Where(o => o.CounterID == counter.CounterID);
model.Counters[index].SumReads = reads.Select(o => o.ReadAmount).Sum();
}
}
return PartialView("~/Areas/Admin/Views/Counter/_UserCounter.cshtml", model);
}
public ActionResult AddReference(int counterId, int userId)
{
using (var db = new GazDbContext())
{
var userrepo = new UserRepository(db);
var counterrepo = new CountersRepository(db);
var user = userrepo.GetByID(userId);
var counter = counterrepo.GetByID(counterId);
user.User_Counters.Add(counter);
userrepo.Commit();
return Content("Ref added");
}
}
public UserCounterModel(int userID)
{
using (var db = new GazDbContext())
{
UserDetails = new UserModel(userID, db);
Counters = new List<CounterModel>();
var counters = db.Users.Find(userID).User_Counters;
foreach (var count in counters)
{
Counters.Add(new CounterModel(count));
}
}
}
public JsonResult GetCascadeBillsMonths(int? counterId)
{
if (!counterId.HasValue)
{
return null;
}
using (var db = new GazDbContext())
{
var brepo = new BillsRepository(db);
var bills = brepo.GetAllBillsByCounterId(counterId.Value).Select(s => s.CreateTime).ToList();
return Json(bills.Select(s => new
{
MonthFormatted = s.ToString("MM/yyyy"),
Date = s.ToString("dd/MM/yyyy")
}), JsonRequestBehavior.AllowGet);
}
}
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));
}
private List<SelectListItem> GetListOfCounters(string userName)
{
using (var db = new GazDbContext())
{
var user = db.Users.First(o => o.Username == userName);
var counters = db.Users.Find(user.ID).User_Counters.ToList();
var list = new List<SelectListItem>();
foreach (var counter in counters)
{
var counterView = new SelectListItem();
counterView.Value = counter.ID.ToString(CultureInfo.InvariantCulture);
counterView.Text = CounterDetails(counter);
list.Add(counterView);
}
return list;
}
}
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));
}
private List<CounterReadModel> GetConsumptionData(int counterId, DateTime startTime, DateTime endTime)
{
using (var db = new GazDbContext())
{
var repo = new CountersRepository(db);
var counterReads = repo.GetCounterReadsPerPeriod(counterId, startTime, endTime).OrderByDescending(o => o.CreateTime).ToList();
var list = counterReads.Select(o => new CounterReadModel
{
CounterID = counterId,
CreateTime = o.CreateTime,
ReadAmount = o.ReadAmount,
ReadID = o.ID
}).ToList();
ViewBag.Overroll = GetChartModel(list.OrderBy(o => o.CreateTime).ToList());
return list;
}
}
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();
}
}
private IEnumerable<SelectListItem> GetListOfCounters(string userName)
{
using (var db = new GazDbContext())
{
var urepo = new UserRepository(db);
var counters = urepo.GetCountersByUserName(userName);
return counters.Select(counter => new SelectListItem()
{
Value = counter.ID.ToString(CultureInfo.InvariantCulture),
Text = CounterUiSerivce.GetDetails(counter)
}).ToList();
}
}
internal List<UserModel> GetUsers()
{
using (var db = new GazDbContext())
{
return db.Users.Select(o => new UserModel
{
ID = o.ID,
FirstName = o.FirstName,
LastName = o.LastName,
PhoneNumber = o.PhoneNumber,
Email = o.Email,
Password = o.Password,
RoleID = o.RoleID,
Username = o.Username
}).ToList() ;
}
}
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));
}
private void SetNotificationForAllUsers(string message)
{
using (var db = new GazDbContext())
{
var users = db.Users.Where(o => o.RoleID == 1).Select(o => o.ID).ToArray();
SetNotificationForMultipleUsers(message, users);
}
}
