public ActionResult BookingAppointment(FormCollection collection)
{
int dentistID = Convert.ToInt32(collection["Dentist"]);
int locationID = Convert.ToInt32(collection["Location"]);
DateTime Startdate = Convert.ToDateTime(collection["Date"]);
DateTime Enddate = Convert.ToDateTime(collection["Date"]);
var StartTime = collection["StartTime"];
var EndTime = collection["EndTime"];
int StartHour = Convert.ToInt32(StartTime.Substring(0, 2));
int EndHour = Convert.ToInt32(EndTime.Substring(0, 2));
int StartMinute = Convert.ToInt32(StartTime.Substring(3, 2));
int EndMinute = Convert.ToInt32(EndTime.Substring(3, 2));
Startdate = Startdate.AddHours(StartHour);
Enddate = Enddate.AddHours(EndHour);
Startdate = Startdate.AddMinutes(StartMinute);
Enddate = Enddate.AddMinutes(EndMinute);
Appointments app = new Appointments();
app.startTime = Startdate;
app.endTime = Enddate;
app.dentistID = dentistID;
app.locationID = locationID;
app.updateType = "1";
app.patientID = Convert.ToInt32(TempData["patientID"]);
TempData.Remove("patientID");
using (var tran = dentistContext.Database.BeginTransaction())
{
try
{
dentistContext.Appointments.Add(app);
dentistContext.SaveChanges();
tran.Commit();
}
catch (Exception e)
{
tran.Rollback();
return(RedirectToAction("Desktop", "Home"));
}
}
return(View());
}
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 ActionResult PatientRegistration([Bind(Exclude = "patientID")] Patients patient)
{
using (var tran = dentistContext.Database.BeginTransaction())
{
try
{
dentistContext.Patients.Add(patient);
dentistContext.SaveChanges();
tran.Commit();
return(RedirectToAction("Desktop", "Home"));
}
catch (Exception e)
{
tran.Rollback();
return(View());
}
}
}
public ActionResult PatientRegistration([Bind(Exclude = "patientID")] Patients patient)
{
using (var tran = dentistContext.Database.BeginTransaction())
{
try
{
patient.patientHRN = "DAM02";
dentistContext.Patients.Add(patient);
dentistContext.SaveChanges();
tran.Commit();
return(View());
}
catch (Exception e)
{
tran.Rollback();
return(View());
}
}
}
public ActionResult Create(Users user, HttpPostedFileBase file)
{
string filename = System.IO.Path.GetFileName(file.FileName);
/*Saving the file in server folder*/
file.SaveAs(Server.MapPath("~/Images/" + filename));
user.Image = "Images/" + filename;
if (ModelState.IsValid)
{
db.Userses.Add(user);
db.SaveChanges();
return(RedirectToAction("Confirmation"));
}
return(View(user));
}
public ActionResult CompletedApp(FormCollection collection)
{
int treatmentID = Convert.ToInt32(collection["Treatment"]);
int appID = Convert.ToInt32(TempData["appID"]);
TempData.Remove("appID");
PatientTreatment patTreatment = new PatientTreatment();
try
{
int toothID = Convert.ToInt32(collection["Tooth"]);
patTreatment.patienttoothID = toothID;
}
catch (Exception e)
{
}
patTreatment.appointmentID = appID;
patTreatment.treatmentID = treatmentID;
dentistContext.patientTreatment.Add(patTreatment);
dentistContext.SaveChanges();
return(View());
}
public ActionResult DentistRegistration([Bind(Exclude = "dentistID")] FormCollection collection)
{
using (var tran = dentistContext.Database.BeginTransaction())
{
try
{
Boolean isActive;
var checkbox = collection["isActive"];
if (checkbox == null) //if it is unchecked it will be null
{
isActive = false; //set it to a parsable value instead
}
else
{
isActive = true;
}
Dentists u = new Dentists();
//SqlParameter param1 = new SqlParameter("@HRN", "DM213");
//convert 0 or 1 to int and return it to view
u.dentistHRN = "DM02";
u.firstName = Convert.ToString(collection["firstName"]);
u.middleName = Convert.ToString(collection["middleName"]);
u.lastName = Convert.ToString(collection["lastName"]);
u.contactNumber = Convert.ToString(collection["contactNumber"]);
u.gender = Convert.ToString(collection["gender"]);
u.emailID = Convert.ToString(collection["emailID"]);
u.qualification = Convert.ToString(collection["qualification"]);
u.aptNumber = Convert.ToString(collection["aptNumber"]);
u.street = Convert.ToString(collection["street"]);
u.city = Convert.ToString(collection["city"]);
u.state = Convert.ToString(collection["state"]);
u.isActive = isActive;
u.dob = Convert.ToDateTime(collection["dob"]);
u.doj = Convert.ToDateTime(collection["doj"]);
dentistContext.Dentists.Add(u);
dentistContext.SaveChanges();
int id = dentistContext.Dentists.OrderByDescending(x => x.dentistID).
Select(x => x.dentistID).FirstOrDefault();
Users s = new Users();
s.userName = Convert.ToString(collection["userName"]);
s.password = Convert.ToString(collection["password"]);
s.dentistID = id;
s.role = "Dentist";
dentistContext.Users.Add(s);
dentistContext.SaveChanges();
tran.Commit();
return(RedirectToAction("Desktop", "Home"));
}
catch (Exception e)
{
tran.Rollback();
return(View());
}
}
}
