// GET: Counter
public ActionResult Index()
{
var cus = (from s in db.ServiceAssign
from c in db.Customer
from n in db.Service
where s.NewspaperId == n.Id && s.CustomerId == c.Id
select new
{
Customer = c,
ServiceAssign = s,
NewsPaper = n
}).ToList(); // as IEnumerable<CounterVM>;
var uniqCustomer = from m in cus
group m by new { m.Customer.Id }
into mygroup
select mygroup.FirstOrDefault();
List <AccountantVM> objConter = new List <AccountantVM>();
foreach (var item in cus)
{
AccountantVM counter = new AccountantVM();
counter.Service = item.NewsPaper;
counter.Customer = item.Customer;
var end = item.ServiceAssign.EndedDate;
counter.Endeddate = ADTOBS.EngToNep(end).ToString();
counter.ServiceAssign = item.ServiceAssign;
objConter.Add(counter);
}
return(View(objConter.AsEnumerable()));
}
public FileResult Export(int?id)
{
if (id == null)
{
return(null);
}
SalesMan salesman = db.SalesMan.Find(id);
var cus = (from s in db.ServiceAssign
from c in db.Customer
from p in db.Service
where s.SalesManId == id && s.CustomerId == c.Id && s.NewspaperId == p.Id
select new
{
customer = c,
ServiceAssign = s,
service = p,
}).ToList();
if (!(cus.Count == 0))
{
List <SalesmanVM> objConter = new List <SalesmanVM>();
DataTable dt = new DataTable("Grid");
dt.Columns.AddRange(new DataColumn[9] {
new DataColumn("Customer Type"),
new DataColumn("Customer Id"),
new DataColumn("Customer Name"),
new DataColumn("Address"),
new DataColumn("Phone"),
new DataColumn("Newspaper"),
new DataColumn("Quantity"),
new DataColumn("Paperdispatch Date"),
new DataColumn("Ended Date")
});
foreach (var item in cus)
{
dt.Rows.Add(item.customer.CustomerType, item.customer.CustomerId,
item.customer.FirstName, item.customer.Address, item.customer.Address,
item.service.NewsPaperName, item.ServiceAssign.Quantity, ADTOBS.EngToNep(item.ServiceAssign.PaperDispatchDate).ToString(),
ADTOBS.EngToNep(item.ServiceAssign.EndedDate).ToString()
);
}
using (XLWorkbook wb = new XLWorkbook())
{
wb.Worksheets.Add(dt);
using (MemoryStream stream = new MemoryStream())
{
wb.SaveAs(stream);
return(File(stream.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "ExportExcel.xlsx"));
}
}
}
return(null);
}
public ActionResult ProductionReport(string engdate)
{
DateTime days = Convert.ToDateTime(engdate);
DateTime subsdays = days.AddDays(-1);
List <Prakashanreport> prakashanreport = db.prakashanreports.Where(m => m.Date == days).ToList();
List <Prakashanreport> prakashanreportyes = db.prakashanreports.Where(m => m.Date == subsdays).ToList();
List <ProductionReportvm> productiovm = new List <ProductionReportvm>();
var report = db.prakashanreports.FirstOrDefault(m => m.Date == days);
if (report != null)
{
foreach (var item in prakashanreport)
{
ProductionReportvm objRep = new ProductionReportvm();
objRep.groupname = db.prakashanGroups.Find(item.GroupId).GroupName;
objRep.datetoday = ADTOBS.EngToNep(days).ToString();
objRep.dateyes = ADTOBS.EngToNep(subsdays).ToString();
objRep.gptoday = item.gp_Total;
if (prakashanreportyes.Any(m => m.GroupId == item.GroupId))
{
objRep.gpyes = prakashanreportyes.FirstOrDefault(m => m.GroupId == item.GroupId).gp_Total;
objRep.rnyes = prakashanreportyes.FirstOrDefault(m => m.GroupId == item.GroupId).rn_Total;
}
objRep.gpdiff = objRep.gptoday - objRep.gpyes;
objRep.rntoday = item.rn_Total;
objRep.rndiff = objRep.rntoday - objRep.rnyes;
productiovm.Add(objRep);
}
ProductionReportvm objReport = new ProductionReportvm();
objReport.gptodaytotal = productiovm.Sum(m => m.gptoday);
objReport.gpyestotal = productiovm.Sum(m => m.gpyes);
objReport.gpdifftotal = productiovm.Sum(m => m.gpdiff);
objReport.rntodaytotal = productiovm.Sum(m => m.rntoday);
objReport.rnyestotal = productiovm.Sum(m => m.rnyes);
objReport.rndifftotal = productiovm.Sum(m => m.rndiff);
productiovm.Add(objReport);
log.AddActivity("Production report printed successfully");
return(View(productiovm));
}
else
{
TempData["message"] = "There is no record for this date";
return(RedirectToAction("SelectDate"));
}
}
public ActionResult EditEndedDate(int?id)
{
//if (id == null)
//{
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
//}
//ServiceAssign service = db.ServiceAssign.Find(id);
//if (service == null)
//{
// return HttpNotFound();
//}
//return View(service);
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var cus = (from s in db.ServiceAssign
from c in db.Customer
from n in db.Service
where s.NewspaperId == n.Id && s.CustomerId == c.Id && s.Id == id
select new
{
Customer = c,
ServiceAssign = s,
NewsPaper = n
}); // as IEnumerable<CounterVM>;
CounterVM counter = new CounterVM();
if (cus.ToList().Any())
{
counter.NewsPaper = cus.ToList().First().NewsPaper;
counter.Customer = cus.ToList().First().Customer;
counter.ServiceAssign = cus.ToList().First().ServiceAssign;
counter.payment = counter.ServiceAssign.PaymentType;
counter.Billdate = ADTOBS.EngToNep(counter.ServiceAssign.UpdatedDate).ToString();
counter.Paperdispatch = ADTOBS.EngToNep(counter.ServiceAssign.PaperDispatchDate).ToString();
counter.enddate = ADTOBS.EngToNep(counter.ServiceAssign.EndedDate).ToString();
}
return(View(counter));
}
public ActionResult CustomerDetail(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var cus = (from s in db.ServiceAssign
from c in db.Customer
from n in db.Service
where s.NewspaperId == n.Id && s.CustomerId == c.Id && s.CustomerId == id
select new
{
Customer = c,
ServiceAssign = s,
NewsPaper = n
}).ToList(); // as IEnumerable<CounterVM>;
List <CounterVM> objConter = new List <CounterVM>();
foreach (var item in cus)
{
CounterVM counter = new CounterVM();
counter.NewsPaper = item.NewsPaper;
counter.Customer = item.Customer;
counter.ServiceAssign = item.ServiceAssign;
var dispatch = item.ServiceAssign.PaperDispatchDate;
counter.Paperdispatch = ADTOBS.EngToNep(dispatch).ToString();
var date = item.ServiceAssign.EndedDate;
counter.NepaliDate = ADTOBS.EngToNep(date).ToString();
objConter.Add(counter);
}
if (objConter.AsEnumerable() == null)
{
return(HttpNotFound());
}
return(View(objConter.AsEnumerable()));
}
public ActionResult ExpiredReport()
{
var Newspaper = (from p in db.ServiceAssign
from c in db.Customer
from s in db.SalesMan
from e in db.Service
where p.CustomerId == c.Id && p.SalesManId == s.Id && p.NewspaperId == e.Id && p.EndedDate <= DateTime.Now
select new
{
serviceAssign = p,
customer = c,
salesman = s,
newspaper = e
}).ToList();
List <CounterVM> listCounter = new List <CounterVM>();
for (int i = 0; i < Newspaper.ToList().Count; i++)
{
CounterVM objcounter = new CounterVM();
objcounter.ServiceAssign = Newspaper[i].serviceAssign;
objcounter.Customer = Newspaper[i].customer;
objcounter.NewsPaper = Newspaper[i].newspaper;
objcounter.SalesMan = Newspaper[i].salesman;
objcounter.enddate = ADTOBS.EngToNep(Newspaper[i].serviceAssign.EndedDate).ToString();
listCounter.Add(objcounter);
// AddedCustomerVM.Add(new AddedCustomerVM { NewsPaperName = Newspaper[i].NewspaperName, 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(), branch = "All Branches" });
}
// var Count = db.ServiceAssign.Where(t => t.EndedDate <= DateTime.Now).ToList();
if (Newspaper.Count == 0)
{
TempData["message"] = "No one is expired";
return(RedirectToAction("Report", "DayWiseCount"));
}
log.AddActivity("Expired Customers reported printed successfully");
return(View(listCounter));
}
public ActionResult AllAssigned()
{
var cus = (from s in db.ServiceAssign
from c in db.Customer
from n in db.Service
from o in db.SalesMan
where s.NewspaperId == n.Id && s.CustomerId == c.Id && s.SalesManId == o.Id
select new
{
Customer = c,
ServiceAssign = s,
NewsPaper = n,
SalesMan = o
}).ToList();
List <assignNewspaperVM> objConter = new List <assignNewspaperVM>();
foreach (var item in cus)
{
assignNewspaperVM counter = new assignNewspaperVM();
counter.Paper = item.NewsPaper.NewsPaperName;
counter.phone = item.Customer.MPhone;
counter.CustomerName = item.Customer.FirstName;
counter.Newspapername = item.NewsPaper.NewsPaperName;
counter.Address = item.Customer.Address;
counter.Distributor = item.SalesMan.FullName;
counter.EndedDate = item.ServiceAssign.EndedDate;
counter.PaperDispatchDate = item.ServiceAssign.PaperDispatchDate;
var date = item.ServiceAssign.EndedDate;
counter.endDate = ADTOBS.EngToNep(date).ToString();
var dispatch = item.ServiceAssign.PaperDispatchDate;
counter.dispatch = ADTOBS.EngToNep(dispatch).ToString();
counter.CusId = item.Customer.CustomerId;
counter.CustomerId = item.Customer.Id;
objConter.Add(counter);
}
return(View(objConter.AsEnumerable()));
}
public ActionResult CustomerActivate(int?id)
{
FiscalYear fiscalYear = db.FiscalYear.FirstOrDefault(m => m.Status == true);
int billNo = 1;
if (fiscalYear != null)
{
if (db.Account.Any(m => m.fiscalyear.Id == fiscalYear.Id))
{
billNo = db.Account.Where(m => m.fiscalyear.Id == fiscalYear.Id).Max(m => m.BillNo) + 1;
}
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var list = new List <SelectListItem>
{
new SelectListItem {
Text = "--छान्नुहोस्-- ", Value = ""
},
new SelectListItem {
Text = "मासिक", Value = "30"
},
new SelectListItem {
Text = "त्रेमासिक", Value = "90"
},
new SelectListItem {
Text = "चौ मासिक", Value = "120"
},
new SelectListItem {
Text = "अर्ध बार्षिक", Value = "182"
},
new SelectListItem {
Text = "बार्षिक", Value = "365"
},
new SelectListItem {
Text = "२ वर्ष", Value = "730"
},
new SelectListItem {
Text = "३ वर्ष", Value = "1095"
},
new SelectListItem {
Text = "४ वर्ष", Value = "1460"
},
new SelectListItem {
Text = "५ वर्ष", Value = "1825"
}
};
// SelectList countries = new SelectList({ Text = "Quarterly", Value = "90" }, new SelectListItem() { Text = "Half Quarterly", Value = "183" }, new SelectListItem() { Text = "Yearly", Value = "365" } }
var cus = (from s in db.ServiceAssign
from c in db.Customer
from n in db.Service
where s.NewspaperId == n.Id && s.CustomerId == c.Id && s.Id == id
select new
{
Customer = c,
ServiceAssign = s,
NewsPaper = n
}); // as IEnumerable<CounterVM>;
CounterVM counter = new CounterVM();
if (cus.ToList().Any())
{
counter.NewsPaper = cus.ToList().First().NewsPaper;
counter.Customer = cus.ToList().First().Customer;
counter.ServiceAssign = cus.ToList().First().ServiceAssign;
counter.Paperdispatch = ADTOBS.EngToNep(counter.ServiceAssign.PaperDispatchDate).ToString();
counter.enddate = ADTOBS.EngToNep(counter.ServiceAssign.EndedDate).ToString();
counter.fiscalYear = fiscalYear.NepYear;
counter.billNo = billNo;
}
ViewBag.Duration = new SelectList(list, "Value", "Text", cus.ToList().FirstOrDefault().ServiceAssign.Duration);
return(View(counter));
}
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 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));
}
// GET: /SalesMan/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SalesMan salesman = db.SalesMan.Find(id);
var cus = (from s in db.ServiceAssign
from c in db.Customer
from p in db.Service
where s.SalesManId == id && s.CustomerId == c.Id && s.NewspaperId == p.Id
select new
{
customer = c,
ServiceAssign = s,
service = p,
}).ToList(); // as IEnumerable<CounterVM>;
ViewBag.Newspaper = new SelectList(db.Service.ToList(), "NewsPaperName", "NewspaperName");
if (!(cus.Count == 0))
{
List <SalesmanVM> objConter = new List <SalesmanVM>();
foreach (var item in cus)
{
SalesmanVM counter = new SalesmanVM();
counter.salesman = salesman;
counter.Customertype = item.customer.CustomerType;
counter.CustomerId = item.customer.CustomerId;
counter.CustomerName = item.customer.FirstName;
counter.Address = item.customer.Address;
counter.Phone = item.customer.MPhone;
counter.Newspaper = item.service.NewsPaperName;
counter.Quantity = Convert.ToInt32(item.ServiceAssign.Quantity).ToString();
counter.Ended = item.ServiceAssign.EndedDate;
counter.EndedDate = ADTOBS.EngToNep(item.ServiceAssign.EndedDate).ToString();
counter.Paperdispatchdate = ADTOBS.EngToNep(item.ServiceAssign.PaperDispatchDate).ToString();
objConter.Add(counter);
}
ViewBag.errmsg = "customer";
if (objConter.AsEnumerable() == null)
{
return(HttpNotFound());
}
return(View(objConter.AsEnumerable()));
}
else
{
SalesmanVM objsale = new SalesmanVM();
List <SalesmanVM> objConter = new List <SalesmanVM>();
objsale.salesman = salesman;
objConter.Add(objsale);
ViewBag.errmsg = "no cus";
return(View(objConter.AsEnumerable()));
}
}
