// In this method we will create default User roles and Admin user for login private void createUsers() { NewspaperEntities context = new NewspaperEntities(); // var roleManager = new RoleManager<IdentityRole>(new RoleStore<IdentityRole>(context)); // var UserManager = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(context)); // In Startup iam creating a default Admin User var user = new Admin(); user.EmployeeId = "100"; user.UserName = "******"; user.FullName = "Super Admin"; user.Email = "*****@*****.**"; user.Category = "SuperAdmin"; user.Phone = "01-4220638"; user.Password = Crypto.Hash("admin123"); user.CreatedDate = DateTime.Now; user.ModifiedDate = DateTime.Now; user.PPSizePhoto = "~/img/17.jpg"; user.Status = true; if (context.Admin.ToList().Count == 0) { context.Admin.Add(user); context.SaveChanges(); } //string userPWD = "admin123"; //var chkUser = UserManager.Create(user, userPWD); }
public ActionResult NewspaperToPrint(FormCollection col) { List <SelectSalesManVM> publishNewspaper = new List <SelectSalesManVM>(); DateTime date = Convert.ToDateTime(col["NewpaperToPublish"]); string Date = col["NepDate"].ToString(); if (date > DateTime.Now) { NewspaperEntities db = new NewspaperEntities(); string Email = Session["userEmail"].ToString(); //DateTime endedDate = db.Customer.Include("Service").FirstOrDefault(m => m.EndedDate > date).EndedDate; var Newspaper = db.ServiceAssign.FirstOrDefault(m => m.EndedDate > date && m.PaperDispatchDate < date); var Paper = db.ServiceAssign.Where(m => m.EndedDate > date && m.PaperDispatchDate < date).GroupBy(n => n.NewspaperId) .Select(g => new { ServiceId = g.Key, Count = g.Sum(m => m.Quantity), newspaperId = g.FirstOrDefault().NewspaperId }).ToList(); if (Newspaper == null) { TempData["message"] = "No record found."; return(RedirectToAction("SelectPublishDate")); } for (int i = 0; i < Paper.ToList().Count; i++) { int newsId = Int32.Parse(Paper[i].newspaperId.ToString()); string newspapername = db.Service.FirstOrDefault(m => m.Id == newsId).NewsPaperName; publishNewspaper.Add(new SelectSalesManVM { NepDate = Date, NewsPaperName = newspapername, Count = Paper[i].Count, branch = "All Branches" }); // imagesList.Add(new SelectSalesManVM { NewsPaperName=customer[i].ServiceId, Count = customer[i].Count }); } try { string operation = "Estimated Report to print Newspaper is created by" + " " + Email; db.ActivityLog.Add(new ActivityLog { Operation = operation, CreatedBy = Session["userEmail"].ToString(), CreatedDate = DateTime.Now }); db.SaveChanges(); } catch { ViewBag.ErrorMessage = "Estimated Report Failed To Print"; } return(View(publishNewspaper)); } else { TempData["message"] = "You cannot Estimate for this date"; return(RedirectToAction("SelectPublishDate")); } }
public ActionResult CountSalesManReport(FormCollection col) { List <SelectSalesManVM> SelectSalesManVM = new List <SelectSalesManVM>(); string NepaliDate = col["NepDate"].ToString(); int salesManId = Convert.ToInt32(col["SalesManId"]); DateTime date = Convert.ToDateTime(col["PaperDispatchDate"]); NewspaperEntities db = new NewspaperEntities(); var salesManList = db.SalesMan.ToList(); foreach (var item in salesManList) { var customer = db.ServiceAssign.Where(m => m.EndedDate > date && m.SalesManId == item.Id && m.PaperDispatchDate < date).GroupBy(n => n.NewspaperId) .Select(g => new { ServiceId = g.Key, Count = g.Sum(m => m.Quantity), newspaperId = g.FirstOrDefault().NewspaperId }).ToList(); for (int i = 0; i < customer.ToList().Count; i++) { int newsId = Int32.Parse(customer[i].newspaperId.ToString()); string newspapername = db.Service.FirstOrDefault(m => m.Id == newsId).NewsPaperName; SelectSalesManVM.Add(new SelectSalesManVM { SalesManId = item.Id, NepDate = NepaliDate, SalesManName = item.FullName, ReportDate = DateTime.Now, NewsPaperName = newspapername, Count = customer[i].Count, branch = "All Branches" }); } } if (SelectSalesManVM.Count == 0) { TempData["message"] = "No record found."; return(RedirectToAction("SelectSalesMan")); } try { string Operation = "Daywise count Report is printed"; db.ActivityLog.Add(new ActivityLog { Operation = Operation, CreatedBy = Session["userName"].ToString(), CreatedDate = DateTime.Now }); } catch { ViewBag.ErrorMessage = "Daywise count Report failed to print"; } log.AddActivity("Gatepass report printed successfully"); return(View(SelectSalesManVM)); }
public ActionResult RenewCustomerReport(FormCollection col) { List <AddedCustomerVM> AddedCustomerVM = new List <AddedCustomerVM>(); int ServiceId = Convert.ToInt32(col["ServiceId"]); string AddedDate = col["NepDate"].ToString(); DateTime date = Convert.ToDateTime(col["RegisterDate"]); NewspaperEntities db = new NewspaperEntities(); { var Newspaper = (from p in db.ServiceAssign from c in db.Customer from s in db.SalesMan from e in db.Service // replace && p.CustomerId == c.Id && p.SalesManId == s.Id && p.NewspaperId == e.Id //where p.NewspaperId == e.Id && p.CreatedDate == date && p.CustomerId.ToString() == c.CustomerId && p.SalesManId == s.Id && p.NewspaperId == ServiceId where p.NewspaperId == ServiceId && p.UpdatedDate == date && p.PaymentType == true && p.CustomerId == c.Id && p.SalesManId == s.Id && p.NewspaperId == e.Id select new { serviceId = p.NewspaperId, FirstName = c.FirstName, quantity = p.Quantity, NepaliDate = p.NepaliDate, SalesMan = s.FullName, MPhone = c.MPhone, Address = c.Address, PaperDispatchDate = p.PaperDispatchDate, EndedDate = p.EndedDate, NewspaperName = e.NewsPaperName, date = p.UpdatedDate, CustomerId = c.CustomerId }).ToList(); if (Newspaper == null || Newspaper.Count == 0) { TempData["message"] = "No record found."; return(RedirectToAction("SelectRewNewspaper")); } for (int i = 0; i < Newspaper.ToList().Count; i++) { if (Newspaper[i].CustomerId == null) { AddedCustomerVM.Add(new AddedCustomerVM { dispatch = ADTOBS.EngToNep(Newspaper[i].PaperDispatchDate).ToString(), enddate = ADTOBS.EngToNep(Newspaper[i].EndedDate).ToString(), NewsPaperName = Newspaper[i].NewspaperName, NepaliDate = AddedDate, SalesMan = Newspaper[i].SalesMan /*, NewsPaperName =Newspaper[i].NewspaperName*/, ReportDate = Newspaper[i].date, FirstName = Newspaper[i].FirstName, quantity = Convert.ToInt32(Newspaper[i].quantity).ToString(), Address = Newspaper[i].Address, MPhone = Newspaper[i].MPhone, PaperDispatchDate = Newspaper[i].PaperDispatchDate, EndedDate = Newspaper[i].EndedDate, branch = "All Branches" }); } else { AddedCustomerVM.Add(new AddedCustomerVM { dispatch = ADTOBS.EngToNep(Newspaper[i].PaperDispatchDate).ToString(), enddate = ADTOBS.EngToNep(Newspaper[i].EndedDate).ToString(), NewsPaperName = Newspaper[i].NewspaperName, quantity = Convert.ToInt32(Newspaper[i].quantity).ToString(), NepaliDate = AddedDate, SalesMan = Newspaper[i].SalesMan /*, NewsPaperName =Newspaper[i].NewspaperName*/, ReportDate = Newspaper[i].date, FirstName = Newspaper[i].FirstName, Address = Newspaper[i].Address, MPhone = Newspaper[i].MPhone, PaperDispatchDate = Newspaper[i].PaperDispatchDate, EndedDate = Newspaper[i].EndedDate, CustomerId = Newspaper[i].CustomerId.ToString(), }); } } if (AddedCustomerVM == null) { TempData["message"] = "No record found."; return(RedirectToAction("SelectRewNewspaper")); } try { String Operation = "Renew Customer Report Printed"; db.ActivityLog.Add(new ActivityLog { Operation = Operation, CreatedBy = Session["userEmail"].ToString(), CreatedDate = DateTime.Now }); db.SaveChanges(); } catch { ViewBag.ErrorMessage = "Email sending failed"; } return(View(AddedCustomerVM)); } }
public ActionResult DistributorAddReport(FormCollection col) { List <DistributorVM> DistributorVM = new List <DistributorVM>(); int ServiceId = Convert.ToInt32(col["ServiceId"]); string EndedDate = col["NepDate"].ToString(); DateTime date = Convert.ToDateTime(col["EndedDate"]); DateTime yes = date.AddDays(-1); NewspaperEntities db = new NewspaperEntities(); int serviceId = Convert.ToInt32(col["ServiceId"].ToString()); var objService = db.Service.Find(serviceId); var paperAll = db.ServiceAssign.Where(m => m.EndedDate >= date && m.PaperDispatchDate <= date).Where(m => m.NewspaperId == serviceId).GroupBy(n => n.SalesManId) .Select(g => new { FullName = g.Key, SalesManId = g.Key, Count = g.Sum(m => m.Quantity) }).ToList(); var PaperTotal = db.ServiceAssign.Where(m => m.EndedDate >= yes && m.PaperDispatchDate <= yes).Where(m => m.NewspaperId == serviceId).GroupBy(n => n.SalesManId) .Select(g => new { FullName = g.Key, SalesManId = g.Key, Count = g.Sum(m => m.Quantity) }).ToList(); var substracted = db.ServiceAssign.Where(m => m.EndedDate == date).Where(m => m.NewspaperId == serviceId).GroupBy(n => n.SalesManId) .Select(g => new { FullName = g.Key, SalesManId = g.Key, Count = g.Sum(m => m.Quantity) }).ToList(); var added = db.ServiceAssign.Where(m => m.PaperDispatchDate == date).Where(m => m.NewspaperId == serviceId).GroupBy(n => n.SalesManId) .Select(g => new { FullName = g.Key, SalesManId = g.Key, Count = g.Sum(m => m.Quantity) }).ToList(); for (int i = 0; i < paperAll.Count; i++) { int addedInt = 0, substractInt = 0, paperTotalInt = 0; if (PaperTotal.FirstOrDefault(m => m.SalesManId == paperAll[i].SalesManId) == null) { paperTotalInt = 0; } else { paperTotalInt = PaperTotal.FirstOrDefault(m => m.SalesManId == paperAll[i].SalesManId).Count; } if (added.FirstOrDefault(m => m.SalesManId == paperAll[i].SalesManId) == null) { addedInt = 0; } else { addedInt = added.FirstOrDefault(m => m.SalesManId == paperAll[i].SalesManId).Count; } if (substracted.FirstOrDefault(m => m.SalesManId == paperAll[i].SalesManId) == null) { substractInt = 0; } else { substractInt = substracted.FirstOrDefault(m => m.SalesManId == paperAll[i].SalesManId).Count; } DistributorVM.Add(new DistributorVM { DistributorName = db.SalesMan.Find(paperAll[i].SalesManId).FullName, newspaperName = objService.NewsPaperName, Quantity = paperTotalInt, Added = addedInt, Subs = substractInt, NepaliDate = EndedDate, }); } try { string operation = "Distributor Report is created"; db.ActivityLog.Add(new ActivityLog { Operation = operation, CreatedBy = Session["userEmail"].ToString(), CreatedDate = DateTime.Now, }); db.SaveChanges(); } catch { ViewBag.ErrorMessage = "Distributor Report Failed to print"; } if (DistributorVM.Count == 0) { TempData["message"] = "No record found."; return(RedirectToAction("SelectDistributorDate")); } return(View(DistributorVM)); }
public ActionResult ExpiredCustomerBydate(FormCollection col) { List <AddedCustomerVM> AddedCustomerVM = new List <AddedCustomerVM>(); string EndedDate = col["NepDate"].ToString(); DateTime date = Convert.ToDateTime(col["EndedDate"]); NewspaperEntities db = new NewspaperEntities(); var Newspaper = (from s in db.ServiceAssign from e in db.Service from d in db.SalesMan from c in db.Customer where s.EndedDate == date && s.CustomerId == c.Id && s.SalesManId == d.Id && s.NewspaperId == e.Id select new { ServiceId = s.NewspaperId, FirstName = c.FirstName, SalesMan = d.FullName, MPhone = c.MPhone, Address = c.Address, NewspaperName = e.NewsPaperName, date = s.EndedDate, CustomerId = c.CustomerId }).ToList(); if (Newspaper == null || Newspaper.Count == 0) { TempData["message"] = "No record found."; return(RedirectToAction("SelectDate")); } for (int i = 0; i < Newspaper.ToList().Count; i++) { AddedCustomerVM.Add(new AddedCustomerVM { enddate = ADTOBS.EngToNep(date).ToString(), EndedDate = date, NepaliDate = EndedDate, SalesMan = Newspaper[i].SalesMan, NewsPaperName = Newspaper[i].NewspaperName, ReportDate = Newspaper[i].date, FirstName = Newspaper[i].FirstName, Address = Newspaper[i].Address, MPhone = Newspaper[i].MPhone, CustomerId = Newspaper[i].CustomerId }); } if (AddedCustomerVM == null) { TempData["message"] = "No record found."; return(RedirectToAction("SelectDistributorDate")); } try { String Operation = "Expired Reported printed"; db.ActivityLog.Add(new ActivityLog { Operation = Operation, CreatedBy = Session["userEmail"].ToString(), CreatedDate = DateTime.Now }); db.SaveChanges(); } catch { ViewBag.ErrorMessage = "Email sending failed"; } return(View(AddedCustomerVM)); }
public ActionResult Login(Models.LoginViewModel l, string ReturnUrl = "") { using (NewspaperEntities db = new NewspaperEntities()) { //var Admin = _db.Admin.FirstOrDefault(a => (a.UserName == l.UserName || a.Email == l.UserName)); //if (Admin != null) //{ // var pass = Crypto.Hash(l.Password); // if (string.Compare(pass, Admin.Password) == 0) // { // FormsAuthentication.SetAuthCookie(l.UserName, l.RememberMe); // if (Url.IsLocalUrl(ReturnUrl)) // { // var objAdmin = _db.Admin.FirstOrDefault(a=>(a.UserName == l.UserName || a.Email == l.UserName) && a.Password == l.Password); // return RedirectToAction("Index","Dashboard"); // } // else // { // Session.Add("id", Admin.Id); // Session.Add("userName", Admin.UserName); // Session.Add("userEmail", Admin.Email); // Session.Add("FullName", Admin.FullName); // Session.Add("Category", Admin.Category); // return RedirectToAction("Index", "DashBoard"); // } // } //} //else //{ // ModelState.AddModelError("", "Invalid User"); //} // return View(); //} var Admin = _db.Admin.FirstOrDefault(a => (a.UserName == l.UserName || a.Email == l.UserName)); if (Admin != null) { var pass = Crypto.Hash(l.Password); if (string.Compare(pass, Admin.Password) == 0) { var check = _db.Admin.FirstOrDefault(a => a.Status); if (Admin.Status == true) { string imageUrl = "../../img/17.jpg"; if (System.IO.File.Exists(Server.MapPath(@"~/images/" + Admin.Id + ".jpg"))) { imageUrl = "../../images/" + Admin.Id + ".jpg"; } Session.Add("id", Admin.Id); Session.Add("userName", Admin.UserName); Session.Add("userEmail", Admin.Email); Session.Add("FullName", Admin.FullName); Session.Add("Category", Admin.Category); Session.Add("imageUrl", imageUrl); Session.Add("BranchId", Admin.BranchId); if (Session["Category"].ToString() == "Counter") { return(RedirectToAction("Index", "Counter")); } else if (Session["Category"].ToString() == "Accountant") { return(RedirectToAction("Index", "Accountant")); } else { return(RedirectToAction("Index", "DashBoard")); } } else { ModelState.AddModelError("", "Admin is Deactivate"); } } else { ModelState.AddModelError("", "UserName and Password not match"); } } else { ModelState.AddModelError("", "UserName and Password not match"); } } return(View()); }
public ActionResult Login(Models.LoginViewModel l, string ReturnUrl = "") { using (NewspaperEntities db = new NewspaperEntities()) { var Admin = _db.Admin.FirstOrDefault(a => (a.UserName == l.UserName || a.Email == l.UserName)); if (Admin != null) { var pass = Crypto.Hash(l.Password); if (string.Compare(pass, Admin.Password) == 0) { var check = _db.Admin.FirstOrDefault(a => a.Status); if (Admin.Status == true) { string imageUrl = "../../img/17.jpg"; if (System.IO.File.Exists(Server.MapPath(@"~/images/" + Admin.Id + ".jpg"))) { imageUrl = "../../images/" + Admin.Id + ".jpg"; } Session.Add("id", Admin.Id); Session.Add("userName", Admin.UserName); Session.Add("userEmail", Admin.Email); Session.Add("FullName", Admin.FullName); Session.Add("Category", Admin.Category); Session.Add("imageUrl", imageUrl); Session.Add("BranchId", Admin.BranchId); if (Session["Category"].ToString() == "Counter") { var login = Session["userEmail"].ToString(); log.AddActivity(login + " " + "logged in successfully"); return(RedirectToAction("Index", "Counter")); } else if (Session["Category"].ToString() == "Accountant") { var login = Session["userEmail"].ToString(); log.AddActivity(login + " " + "logged in successfully"); return(RedirectToAction("Index", "Accountant")); } else { return(RedirectToAction("Index", "DashBoard")); } } else { ModelState.AddModelError("", "Admin is Deactivate"); } } else { ModelState.AddModelError("", "UserName and Password not match"); } } else { ModelState.AddModelError("", "UserName and Password not match"); } } return(View()); }