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