public ActionResult Create(List <PurchaseReportVM> prakashanreport, FormCollection col)
{
DateTime date = Convert.ToDateTime(col["EnglishDate"]);
string Nepdate = col["NepaliDate"].ToString();
var report = db.prakashanreports.FirstOrDefault(m => m.Date == date);
if (report == null)
{
PurchaseReportVM purchasevm = new PurchaseReportVM();
foreach (var item in prakashanreport)
{
Prakashanreport objreport = new Prakashanreport();
objreport.NepaliDate = Nepdate;
objreport.Date = date;
objreport.GroupId = Convert.ToInt32(item.GroupId);
objreport.PrakashanGroup = db.prakashanGroups.Find(objreport.GroupId);
objreport.gp_Total = item.gp_Total;
objreport.rn_Total = item.rn_Total;
objreport.Remarks = item.Remarks;
db.prakashanreports.Add(objreport);
db.SaveChanges();
}
TempData["message"] = "Production record inserted sucessfully";
log.AddActivity("Production report Successfully Inserted");
return(RedirectToAction("Index"));
}
else
{
TempData["message"] = " Production Record for this date is already stored please edit this record here";
return(RedirectToAction("EditByDate"));
}
}
public ActionResult ChangeSaleman(assignNewspaperVM serviceAssign)
{
if (db.ServiceAssign.Any(m => m.CustomerId == serviceAssign.CustomerId))
{
foreach (var item in serviceAssign.NewspaperIds)
{
ServiceAssign objService = db.ServiceAssign.FirstOrDefault(m => m.CustomerId == serviceAssign.CustomerId && m.NewspaperId == item);
objService.SalesManId = serviceAssign.SalesManId;
log.AddActivity("Service assign to customer successfully");
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Newspaper Already Assigned.");
serviceAssign.Newspapers = new SelectList(db.Service, "Id", "NewsPaperName");
serviceAssign.Salesmans = new SelectList(db.SalesMan, "Id", "FullName");
return(View(serviceAssign));
}
}
public ActionResult Create([Bind(Include = "BranchId,BranchName,BranchAddress,BrachPhone")] Branch branch)
{
if (ModelState.IsValid)
{
db.Branch.Add(branch);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(branch));
}
public ActionResult Create([Bind(Include = "Id,RouteId,RouteName")] Route route)
{
if (ModelState.IsValid)
{
db.Routes.Add(route);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(route));
}
public ActionResult Create([Bind(Include = "Id,NewspaperName,CreatedBy,UpdatedBy,CreatedDate,UpdatedDate")] Newspaper.Models.Newspaper newspaper)
{
if (ModelState.IsValid)
{
db.Newspaper.Add(newspaper);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(newspaper));
}
public ActionResult Create([Bind(Include = "Id,GroupId,GroupName")] PrakashanGroup prakashanGroup)
{
if (ModelState.IsValid)
{
db.prakashanGroups.Add(prakashanGroup);
db.SaveChanges();
TempData["message"] = "Prakahan Group created sucessfully";
return(RedirectToAction("Index"));
}
return(View(prakashanGroup));
}
public ActionResult Create([Bind(Include = "Id,AgentName,Pan,GP_Quantity,RN_Quantity,MUNA_Quantity,Madhu_Quantity,Yuwa_Quantity,Address,Time,RouteName,Transport,State,District,Phone,Email,URL,RouteId")] GroupName groupName)
{
if (ModelState.IsValid)
{
groupName.Route = db.Routes.Find(groupName.RouteId);
db.groupNames.Add(groupName);
db.SaveChanges();
TempData["message"] = "Agent created successfully";
return(RedirectToAction("Index"));
}
ViewBag.RouteId = new SelectList(db.Routes, "Id", "RouteName", groupName.RouteId);
return(View(groupName));
}
public ActionResult Create([Bind(Include = "Id,SalesManId,Area,Comment,CreatedBy,EditedBy,ModifiedBy")] AreaRegister arearegister)
{
if (ModelState.IsValid)
{
arearegister.CreatedBy = Session["userEmail"].ToString();
arearegister.EditedBy = Session["userEmail"].ToString();
arearegister.ModifiedBy = Session["userEmail"].ToString();
try
{
db.AreaRegister.Add(arearegister);
db.SaveChanges();
String Operation = "Area Registered Sucessfully";
db.ActivityLog.Add(new ActivityLog
{
Operation = Operation,
CreatedBy = Session["userEmail"].ToString(),
CreatedDate = DateTime.Now
});
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
ViewBag.SalesManId = new SelectList(db.SalesMan, "Id", "FullName", arearegister.SalesManId);
return(View(arearegister));
}
public ActionResult EditEndedDate(DateTime PaperDispatchDate, DateTime EndedDate, bool payment, int Quantity, int id, DateTime PaymentDate)
{
ServiceAssign objserviceAssign = db.ServiceAssign.Find(id);
objserviceAssign.PaperDispatchDate = PaperDispatchDate;
objserviceAssign.EndedDate = EndedDate;
objserviceAssign.UpdatedDate = PaymentDate;
objserviceAssign.Quantity = Quantity;
objserviceAssign.PaymentType = payment;
db.SaveChanges();
TempData["message"] = "EndedDate Edited Sucessfully";
log.AddActivity("EndedDate is changed");
return(RedirectToAction("Index", "Counter"));
}
// 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 Create([Bind(Include = "Id,SalesManId,FullName,Email,BranchId,AltEmail,Phone1,Phone2")] SalesMan salesman)
{
if (ModelState.IsValid)
{
//salesman.BranchId = Convert.ToInt32(Session["BranchId"].ToString());
try
{
db.SalesMan.Add(salesman);
db.SaveChanges();
//int BranchId = Convert.ToInt32(Session["BranchId"].ToString());
String Operation = "Sales Man Created Sucessfully";
db.ActivityLog.Add(new ActivityLog
{
//BranchId = BranchId,
Operation = Operation,
CreatedBy = Session["userEmail"].ToString(),
CreatedDate = DateTime.Now
});
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
return(View(salesman));
}
public ActionResult Create(Customer customer)
{
if (!ModelState.IsValid)
{
ViewBag.SalesManId = new SelectList(db.SalesMan, "Id", "FullName");
ViewBag.ServiceId = new SelectList(db.Service, "Id", "NewsPaperName");
ViewBag.BranchId = new SelectList(db.Branch, "BranchId", "BranchName");
ViewBag.OfficerId = new SelectList(db.Officers.Where(m => m.Status && m.OfficerType == "निशुल्क प्रदान गर्ने"), "Id", "Name");
return(View(customer));
}
else
{
customer.RegisterDate = DateTime.Now;
customer.RegisteredBy = Session["userEmail"].ToString();
db.Customer.Add(customer);
db.SaveChanges();
try
{
log.AddActivity("Customer Created Successfully");
return(RedirectToAction("index"));
}
catch
{
return(View());
}
}
}
public ActionResult Create(List <RouteVM> routes, FormCollection col)
{
if (ModelState.IsValid)
{
DateTime date = Convert.ToDateTime(col["EnglishDate"]);
string Nepdate = col["NepaliDate"].ToString();
var report = db.RouteReports.FirstOrDefault(m => m.Date == date);
if (report == null)
{
foreach (var item in routes)
{
RouteReport rep = new RouteReport();
rep.Route = db.Routes.Find(item.RouteId);
rep.RouteId = item.RouteId;
rep.NepaliDate = Nepdate;
rep.Date = date;
rep.gp_Quantity = item.gp_Quantity;
rep.rn_Quantity = item.rn_Quantity;
rep.muna_Quantity = item.muna_Quantity;
rep.madhu_Quantity = item.madhu_Quantity;
rep.Yuwa_Quantity = item.Yuwa_Quantity;
rep.AgentId = item.AgentId; //GroupId as AgentId
rep.Groupname = db.groupNames.Find(item.AgentId);
db.RouteReports.Add(rep);
db.SaveChanges();
}
log.AddActivity("Route report inserted successfully");
return(RedirectToAction("Index"));
}
else
{
TempData["message"] = " Production Record for this date is already stored please edit this record here";
return(RedirectToAction("EditByDate"));
}
}
var results = (from p in db.groupNames
group p by p.RouteId into g
select new { g.Key }).ToList();
ViewBag.Routes = results.Select(x => x.Key).ToArray();
return(View(routes));
}
public ActionResult ChangePassword(ChangePasswordViewModel ch)
{
int employeeid = Convert.ToInt32(Session["Id"].ToString());
Admin us = _db.Admin.Single(m => m.Id == employeeid);// (u => u.Id == employeeid && u.Password == ch.OldPassword).FirstOrDefault();
if (us != null)
{
var pass = Crypto.Hash(ch.OldPassword);
if (string.Compare(pass, us.Password) == 0)
{
if (ch.NewPassword == ch.ConfirmNew)
{
us.Password = Crypto.Hash(ch.NewPassword);
_db.SaveChanges();
ViewBag.Message = "Password Changed Successfully";
}
else
{
ViewBag.ErrorMessage = "New Password and Confirm Password Mismatched";
}
}
else
{
ViewBag.ErrorMessage = "Password not matched with previous one!";
}
}
ModelState.Clear();
return(View());
}
public JsonResult changeStatus(string fyId)
{
try
{
if (db.FiscalYear.Any(m => m.Status == true))
{
var activeFiscalYear = db.FiscalYear.FirstOrDefault(m => m.Status == true);
activeFiscalYear.Status = false;
}
int id = Convert.ToInt32(fyId);
var objFisYear = db.FiscalYear.Find(id);
objFisYear.Status = true;
db.SaveChanges();
return(Json(true));
}
catch
{
return(Json(false));
}
}
public void AddActivity(string message)
{
if (!string.IsNullOrEmpty(message))
{
db.ActivityLog.Add(new ActivityLog
{
//BranchId = customer.BranchId,
Operation = message,
CreatedBy = HttpContext.Current.Session["userEmail"].ToString(),
CreatedDate = DateTime.Now
});
db.SaveChanges();
}
}
public ActionResult Create(Officer officer)
{
if (!ModelState.IsValid)
{
ViewBag.OfficerType = new List <SelectListItem> {
new SelectListItem {
Text = "---छान्नुहोस---", Value = ""
},
new SelectListItem {
Text = "कम्प्लिमेन्ट", Value = "कम्प्लिमेन्ट"
},
new SelectListItem {
Text = "नर्मल", Value = "नर्मल"
}
};
return(View(officer));
}
else
{
officer.CreatedBy = Session["userEmail"].ToString();
officer.CreatedDate = DateTime.Now;
officer.UpdatedDate = DateTime.Now;
db.Officers.Add(officer);
db.SaveChanges();
try
{
log.AddActivity("Officer Created Successfully");
return(RedirectToAction("index"));
}
catch
{
return(View());
}
}
}
public ActionResult Create(Customer customer, FormCollection col)
{
int days = Convert.ToInt32(col["HoldingDays"].ToString());
string datestr = col["EndedDate"];
DateTime date = Convert.ToDateTime(col["EndedDate"]);
var objCustomer = db.Customer.Find(customer.Id);
// int remainDays = objCustomer.EndedDate-DateTime.Now;
DateTime holdingEndedDate = date.AddDays(days);
// DateTime customerEndedDate = date.AddDays(days+|)
if (date > DateTime.Now)
{
customer.PaperDispatchDate = customer.EndedDate.AddDays(days);
}
db.HoldingDays.Add(new HoldingDays {
CustomerId = customer.Id, HoldingStartDays = date, HoldingEndDays = customer.EndedDate
});
db.SaveChanges();
objCustomer.EndedDate = customer.EndedDate;
db.SaveChanges();
return(View());
}
public ActionResult Create(assignNewspaperVM serviceAssign)
{
if (!db.ServiceAssign.Any(m => m.NewspaperId == serviceAssign.NewspaperId && m.CustomerId == serviceAssign.CustomerId))
{
serviceAssign.EndedDate = serviceAssign.PaperDispatchDate.AddDays(serviceAssign.Duration);
ServiceAssign objService = new ServiceAssign();
objService.NepaliDate = serviceAssign.NepaliDate;
objService.NewspaperId = serviceAssign.NewspaperId;
objService.SalesManId = serviceAssign.SalesManId;
objService.Duration = serviceAssign.Duration.ToString();
objService.PaperDispatchDate = Convert.ToDateTime(serviceAssign.PaperDispatchDate.ToShortDateString());
objService.status = true;
objService.UpdatedBy = serviceAssign.UpdatedBy;
objService.UpdatedDate = serviceAssign.UpdatedDate;
objService.CreatedBy = serviceAssign.CreatedBy;
objService.CreatedDate = serviceAssign.CreatedDate;
objService.CustomerId = serviceAssign.CustomerId;
objService.Quantity = serviceAssign.Quantity;
objService.EndedDate = Convert.ToDateTime(serviceAssign.EndedDate.ToShortDateString());
db.ServiceAssign.Add(objService);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Newspaper Already Assigned.");
serviceAssign.Newspapers = new SelectList(db.Service, "Id", "NewsPaperName");
serviceAssign.Salesmans = new SelectList(db.SalesMan, "Id", "FullName");
return(View(serviceAssign));
}
}
public ActionResult Create([Bind(Include = "Id,ServiceCode,NewsPaperName,TimeBase,CreatedBy,EditedBy,EditedDate,images")] Service service, HttpPostedFileBase ImageFile)
{
if (ModelState.IsValid)
{
service.CreatedBy = Session["userEmail"].ToString();
service.EditedBy = Session["userEmail"].ToString();
service.EditedDate = DateTime.Now;
HttpFileCollectionBase image = Request.Files;
string filename = image[0].FileName; /* service.NewsPaperName + ".jpg";*/
string name = "/Images/Newspaper/";
bool exist = System.IO.Directory.Exists(Server.MapPath(name));
if (!exist)
{
System.IO.Directory.CreateDirectory(Server.MapPath(name));
}
service.Images = "/Images/Newspaper/" + filename;
if (ImageFile != null)
{
filename = Path.Combine(Server.MapPath("~/Images/Newspaper/"), filename);
ImageFile.SaveAs(filename);
}
try
{
db.Service.Add(service);
db.SaveChanges();
String Operation = "Service Created Sucessfully";
db.ActivityLog.Add(new ActivityLog
{
Operation = Operation,
CreatedBy = Session["userEmail"].ToString(),
CreatedDate = DateTime.Now
});
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
return(View(service));
}
public int CreateAdmin(AdminViewModel av)
{
Admin tb = new Admin();
tb.EmployeeId = av.EmployeeId;
tb.FullName = av.FullName;
tb.Email = av.Email;
tb.UserName = av.UserName;
tb.Password = av.Password;
tb.Phone = av.Phone;
tb.WorkPhone = av.WorkPhone;
tb.URL = av.URL;
tb.PPSizePhoto = av.PPSizePhoto;
tb.CreatedDate = DateTime.Now; // av.CreatedDate;
tb.ModifiedDate = DateTime.Now; //av.ModifiedDate;
tb.CreatedBy = av.CreatedBy;
tb.ModifiedBy = av.ModifiedBy;
_db.Admin.Add(tb);
return(_db.SaveChanges());
}
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 Create(Customer customer)
{
customer.RegisterDate = DateTime.Now;
customer.RegisteredBy = Session["userEmail"].ToString();
db.Customer.Add(customer);
db.SaveChanges();
try
{
log.AddActivity("Customer Created Successfully");
//db.ActivityLog.Add(new ActivityLog
//{
// BranchId = customer.BranchId,
// Operation = Operation,
// CreatedBy = Session["userEmail"].ToString(),
// CreatedDate = DateTime.Now
//});
//db.SaveChanges();
return(RedirectToAction("index"));
}
catch
{
return(View());
}
//if (Session["Category"].ToString() == "SuperAdmin")
//{
// customer.RegisterDate = DateTime.Now;
// customer.RegisteredBy = Session["userEmail"].ToString();
// db.Customer.Add(customer);
// db.SaveChanges();
// try
// {
// String Operation = "Customer Created Sucessfully ";
// db.ActivityLog.Add(new ActivityLog
// {
// BranchId = customer.BranchId,
// Operation = Operation,
// CreatedBy = Session["userEmail"].ToString(),
// CreatedDate = DateTime.Now
// });
// db.SaveChanges();
// return RedirectToAction("index");
// }
// catch
// {
// return View();
// }
//}
//else
//{
// customer.RegisterDate = DateTime.Now;
// customer.RegisteredBy = Session["userEmail"].ToString();
// db.Customer.Add(customer);
// db.SaveChanges();
// try
// {
// int BranchId = Convert.ToInt32(Session["BranchId"].ToString());
// String Operation = "Customer Created Sucessfully ";
// db.ActivityLog.Add(new ActivityLog
// {
// BranchId = BranchId,
// Operation = Operation,
// CreatedBy = Session["userEmail"].ToString(),
// CreatedDate = DateTime.Now
// });
// db.SaveChanges();
// return RedirectToAction("index");
// }
// catch
// {
// return View();
// }
//}
}
public ActionResult CustomMail(MailViewModel mm)
{
List <string> email = db.Customer.Where(s => (DbFunctions.DiffDays(DateTime.Now, s.EndedDate) >= 0))
.Select(t => t.Email).ToList();
//string from = "*****@*****.**";
// string fromPassword = "******";
if (email != null)
{
try
{
int i;
for (i = 0; i <= email.Count; i++)
{
try
{
string str = "<font size='5'>Regards <br/> <b>DebugSoft</b></font>";
using (MailMessage mail = new MailMessage(/*from, email[i]*/))
{
List <string> Name = db.Customer.Where(s => (DbFunctions.DiffDays(DateTime.Now, s.EndedDate) >= 0))
.Select(t => t.FirstName).ToList();
mail.To.Add(new MailAddress(email[i]));
mail.Subject = mm.MailSubject;
mail.IsBodyHtml = true;
mail.Body = "Dear" + " " + Name[i] + "," + mm.MailBody + "<br/>" + "Thank You<br/>" + str;
SmtpClient smtp = new SmtpClient();
//smtp.Host = "smtp.gmail.com";
//smtp.EnableSsl = true;
//smtp.UseDefaultCredentials = false;
//NetworkCredential networkCredential = new NetworkCredential(from, fromPassword);
//smtp.Credentials = networkCredential;
//smtp.Port = 587;
smtp.Send(mail);
}
}
catch
{
ViewBag.Message = "Custom Mail sent";
}
}
}
catch
{
ViewBag.ErrorMessage = "Email sending failed";
}
try
{
String Operation = "Custom mail sent";
db.ActivityLog.Add(new ActivityLog
{
Operation = Operation,
CreatedBy = Session["userEmail"].ToString(),
CreatedDate = DateTime.Now
});
db.SaveChanges();
}
catch
{
ViewBag.ErrorMessage = "Email sending failed";
}
}
return(View());
}
public ActionResult CustomerActivate(string BillNo, string PaymentDate, string Duration, string NepaliDate1, DateTime PaperDispatchDate, string Nepalidate, string PaymentType, string BankName, string ACNumber, decimal Amount, decimal Discount, int id)
{
ServiceAssign objserviceAssign = db.ServiceAssign.Find(id);
int quant = objserviceAssign.Quantity;
//if (objserviceAssign.BillNo != null && objserviceAssign.EndedDate < PaperDispatchDate)
//{
objserviceAssign.Duration = Duration;
//}
objserviceAssign.NepaliDate = NepaliDate1;
objserviceAssign.PaperDispatchDate = PaperDispatchDate;
objserviceAssign.Amount = Amount;
objserviceAssign.Discount = Discount;
decimal AWithoutDis = quant * Amount;
objserviceAssign.DiscountAmount = objserviceAssign.Quantity * AWithoutDis * (Discount / 100);
objserviceAssign.GrandTotal = AWithoutDis - objserviceAssign.DiscountAmount;
objserviceAssign.BillNo = BillNo;
if (objserviceAssign.status)
{
objserviceAssign.EndedDate = objserviceAssign.PaperDispatchDate.AddDays(Convert.ToInt32(Duration));
objserviceAssign.status = false;
}
else
{
if (objserviceAssign.EndedDate.Date > DateTime.Now.Date)
{
objserviceAssign.EndedDate = objserviceAssign.EndedDate.AddDays(Convert.ToInt32(Duration));
}
else if (objserviceAssign.EndedDate.Date < DateTime.Now.Date)
{
objserviceAssign.EndedDate = objserviceAssign.PaperDispatchDate.AddDays(Convert.ToInt32(Duration));
}
}
db.SaveChanges();
Account objAccount = new Account();
objAccount.Amount = objserviceAssign.GrandTotal;
objAccount.Paymentdate = Convert.ToDateTime(PaymentDate);
objAccount.Nepalidate = Nepalidate;
objAccount.BankName = BankName;
objAccount.BankAcc = ACNumber;
objAccount.DiscountAmount = objserviceAssign.DiscountAmount;
objAccount.CustomerId = objserviceAssign.CustomerId;
objAccount.NewspaperId = objserviceAssign.NewspaperId;
objAccount.CreatedBy = "counter";
objAccount.CreatedDate = DateTime.Now;
objAccount.UpdateDate = DateTime.Now;
objAccount.UpdatedBy = "counter";
objAccount.fiscalyear = db.FiscalYear.FirstOrDefault(m => m.Status == true);
objAccount.FiscalYear = db.FiscalYear.FirstOrDefault(m => m.Status == true).NepYear;
objAccount.BillNo = Convert.ToInt32(BillNo);
objAccount.Payoption = PaymentType;
db.Account.Add(objAccount);
db.SaveChanges();
string accId = db.Account.OrderByDescending(m => m.Id).FirstOrDefault().Id.ToString();
// return ReportCounter(BillNo.ToString());
return(RedirectToAction("ReportCounter", "Counter", new { BillNo = accId }));//
}
public ActionResult ForgetPassword(Admin admin)
{
//string from = "usern";
//string fromPassword = "******";
string password = Membership.GeneratePassword(6, 1);
if (admin.Email != null)
{
var mail = new MailMessage();
//using (MailMessage mail = new MailMessage(admin.Email))
try
{
var tb = _db.Admin.Where(u => u.Email == admin.Email).FirstOrDefault();
if (tb == null)
{
ViewBag.Message = "email Doesnot Exist Please enter valid email";
}
else
{
mail.To.Add(new MailAddress(admin.Email));
mail.Subject = "Password Recovery";
mail.Body = "Use this Password to login:"******"smtp.gmail.com";
//smtp.EnableSsl = true;
//smtp.UseDefaultCredentials = false;
//NetworkCredential networkCredential = new NetworkCredential(from, fromPassword);
//smtp.Credentials = networkCredential;
//smtp.Port = 587;
smtp.Send(mail);
ViewBag.Message = "Your Password Is Sent to your email";
var query = (from q in _db.Admin
where q.Email == admin.Email
select q).First();
query.randompass = password;
_db.SaveChanges();
}
}
catch (Exception e)
{
return(RedirectToAction(e.ToString().Substring(0, 100) + "errorpage"));
}
TempData["Message"] = admin.Email;
TempData.Keep();
return(RedirectToAction("conformation"));
}
var errors = ModelState.Where(x => x.Value.Errors.Count > 0)
.Select(x => new { x.Key, x.Value.Errors }).ToArray();
return(View());
//return RedirectToAction("Index", "Home");
}