public ActionResult generateBill(FormCollection collection)
{
var actions = collection.GetValues("Patient");
List <int> selectedAppointments = new List <int>();
foreach (string val in actions)
{
if (!(val.Contains("true") || val.Contains("false")))
{
selectedAppointments.Add(Convert.ToInt32(val));
}
}
Billing bill = new Billing();
bill.comments = "";
bill.billTime = DateTime.Now;
dentistContext.billing.Add(bill);
dentistContext.SaveChanges();
int billID = dentistContext.billing.OrderByDescending(s => s.billingID).Select(x => x.billingID).FirstOrDefault();
using (var db = new DentistContext())
{
foreach (int i in selectedAppointments)
{
var result = db.Appointments.FirstOrDefault(b => b.appointmentID == i);
if (result != null)
{
result.billingID = billID;
db.SaveChanges();
}
}
}
List <Invoice> invoice = dentistContext.Database.SqlQuery <Invoice>("Exec Billing @billingID = " + billID).ToList();
foreach (Invoice inv in invoice)
{
List <PatientTreatment> patTreat = dentistContext.patientTreatment.Where(s => s.appointmentID == inv.appointmentID).ToList();
List <String> treat = new List <String>();
foreach (PatientTreatment pat in patTreat)
{
treat.Add(dentistContext.treatment.Where(s => s.treatmentID == pat.treatmentID).Select(x => x.name).FirstOrDefault());
}
inv.treatments = treat;
int dentID = dentistContext.Appointments.Where(s => s.appointmentID == inv.appointmentID).Select(x => x.dentistID).FirstOrDefault();
inv.dentist = dentistContext.Dentists.Where(s => s.dentistID == dentID).Select(s => s.firstName).FirstOrDefault();
}
return(View(invoice));
}
static void Main(string[] args)
{
try
{
using (var db = new DentistContext())
{
db.Database.CreateIfNotExists();
Patient patient = new Patient()
{
Name = "Tomek",
Surname = "Walasek",
Diagram = new Diagram {
PozX = 0, PozY = 1, Color = 1
},
Visits = new List <Visit>
{
new Visit {
DateOfVisit = DateTime.Now, Description = "asfasf"
},
new Visit {
DateOfVisit = DateTime.Now.AddDays(1), Description = "asdasdas"
}
},
Pictures = new List <Picture>
{
new Picture {
PictureName = "Re3ndgen1.png"
},
new Picture {
PictureName = "Re3ndgen2.jpg"
}
}
};
db.Patients.Add(patient);
db.SaveChanges();
}
Console.WriteLine("Done...");
}
catch (Exception ex)
{
Console.WriteLine("Fail... {0}\r\n{1}", ex.Message, ex.InnerException);
}
finally
{
Console.ReadKey();
}
}
public ActionResult UpdateAppointment(string appID)
{
int appointmentID = Convert.ToInt32(appID);
using (var db = new DentistContext())
{
var result = db.Appointments.FirstOrDefault(b => b.appointmentID == appointmentID);
if (result != null)
{
result.updateType = "2";
db.SaveChanges();
}
}
return(RedirectToAction("OpenAppointment", "Appointment"));
}
public DentistController()
{
dentistContext = new DentistContext();
}
public BillingController()
{
dentistContext = new DentistContext();
}
public AppointmentController()
{
dentistContext = new DentistContext();
}
public HomeController()
{
this.dentistContext = new DentistContext();
}