//
// GET: /Practices/Create
public ActionResult Create()
{
Person sperson = Session["person"] as Person;
ViewBag.PersonID = new SelectList(db.People, "ID", "Title", sperson.ID);
var person = new Practices { PersonID = sperson.ID };
return View(person);
}
public ActionResult Create(Practices practices)
{
if (ModelState.IsValid)
{
practices.ID = Guid.NewGuid();
db.Practices.Add(practices);
db.SaveChanges();
return Content(Boolean.TrueString);
}
ViewBag.PersonID = new SelectList(db.People, "ID", "Title", practices.PersonID);
return View(practices);
}
// Creates a WordprocessingDocument.
public void CreatePackage(string filePath, List<InvoiceDetail> ind, Practices prac)
{
InvoiceD = ind;
pdetail = prac;
persondetail = db.People.Where(a => a.ID == prac.PersonID).FirstOrDefault();
InvoiceD.ForEach(invoice => {
total += System.Convert.ToDecimal(invoice.Appointment.Total.ToString());
});
using (WordprocessingDocument package = WordprocessingDocument.Create(filePath, WordprocessingDocumentType.Document))
{
CreateParts(package);
}
}
public ActionResult InvoicingreportTable(InvoiceDetail vm, string writer, Guid id)
{
var abresults = new List<InvoiceDetail>();
var results = new List<Appointment>();
var practice = new Practices();
var name = Session["Person"] as AutoComplete.Models.Person;
var allAppt = db.Appointments.Where(a => a.Invoiced == false && a.APPID == id).ToList();
vm.session = new Sessions();
vm.session = vm.session;
decimal total = 0;
foreach (var appt in allAppt)
{
vm.PracticeID = appt.PracID;
vm.startDate = Convert.ToDateTime(appt.startDate);
vm.endDate = Convert.ToDateTime(appt.endDate);
vm.Total =Convert.ToDecimal(appt.Total);
Session["Practice"] = db.Practices.Where(p => p.ID == appt.PracID).FirstOrDefault();
practice = Session["Practice"] as AutoComplete.Models.Practices;
if (practice.ID == appt.PracID)
{
appt.sessionDetail = new Sessions();
appt.sessionDetail = db.Sessions.Where(a => a.ID == appt.SessID).FirstOrDefault() != null ? db.Sessions.Where(a => a.ID == appt.SessID).FirstOrDefault() : null;
results.Add(appt);
}
}
if (results != null)
{
foreach (var r in results)
abresults.Add(new InvoiceDetail()
{
InvoicedDate = DateTime.Now,
ID = Guid.NewGuid(),
Appointment = r,
//SessionFees = Convert.ToDecimal(r.sessionDetail.fees) * r.days,
SessionFees = Convert.ToDecimal(r.Total),
SessionName = r.sessionDetail.Name,
totalFees = Convert.ToDecimal(r.Total),
});
// Generateinvoice docreport = new Generateinvoice();
// docreport.CreatePackage(Server.MapPath("\\Reports\\abc.doc"), abresults, practice);
Session["Allinvoice"] = abresults;
var report = new Report(abresults.Select(ap => new { ap.InvoicedDate, ap.SessionName, ap.SessionFees }).ToList().ToReportSource());
// Customize the Text Fields
report.TextFields.Header = string.Format(@"<table width='100%'><tr><td align='left'>
  To : {0}
Website : {1}
City : {2}
Street Address : {3}
Contact no. : {4}
<span style='color:red'>Email</span> : {5}</td>
<td align=''>
From Dr. : {6}
City : {7}
Country : {8}
Contact no.: {9}
Email : {10} </td></tr></table>", practice.Name, practice.cWebsite, practice.city, practice.streetAdd, practice.cphone, practice.cEmail, name.FirstName, name.city, name.country, name.phone, name.Email);
report.TextFields.Title = "Invoicing For " + db.Practices.Where(p => p.ID == vm.PracticeID).FirstOrDefault() == null ? "Not Found" : db.Practices.Where(p => p.ID == vm.PracticeID).FirstOrDefault().Name;
report.TextFields.SubTitle = " From : " + vm.startDate + " End : " + vm.endDate;
report.TextFields.Footer = string.Format(@"<table width='80%'><tr><td align='right'> Total Fees {0}</td></tr></table>", Convert.ToString(vm.Total));
// Render hints allow you to pass additional hints to the reports as they are being rendered
report.RenderHints.BooleanCheckboxes = true;
report.RenderHints.BooleansAsYesNo = true;
report.RenderHints.FreezeRows = 20;
report.RenderHints.FreezeColumns = 10;
Session["Report"] = report;
if (writer == "excel") return new ReportResult(report, new DoddleReport.Writers.ExcelReportWriter());
}
return View(abresults);
//return Json(abresults.Select(ap => new { ap.PatientId, ap.TestDateTime,ap.Age, ap.Gender, ap.TestName, ap.Technician, ap.Result, ap.NormalRange, ap.Name }).ToList(), JsonRequestBehavior.AllowGet);
}
public ActionResult Edit(Practices practices)
{
if (ModelState.IsValid)
{
db.Entry(practices).State = EntityState.Modified;
db.SaveChanges();
return Content(Boolean.TrueString);
}
ViewBag.PersonID = new SelectList(db.People, "ID", "Title", practices.PersonID);
return View(practices);
}