コード例 #1
0
ファイル: Startup.cs プロジェクト: poudyalrupak2/Newspaper-1
        // 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);
        }
コード例 #2
0
        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"));
            }
        }
コード例 #3
0
        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));
        }
コード例 #4
0
        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));
            }
        }
コード例 #5
0
        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));
        }
コード例 #6
0
        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));
        }
コード例 #7
0
        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());
        }
コード例 #8
0
        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());
        }