public JsonResult SaveEvent(Schedule s)
{
var status = false;
using (ERP1DataContext dc = new ERP1DataContext())
{
if (s.EventID > 0)
{
//Update the event
var v = dc.Schedules.Where(a => a.EventID == s.EventID).FirstOrDefault();
if (v != null)
{
v.Subject = s.Subject;
v.Start = s.Start;
v.End = s.End;
v.Description = s.Description;
v.IsFullDay = s.IsFullDay;
v.Theme = s.Theme;
}
}
else
{
dc.Schedules.InsertOnSubmit(s);
}
dc.SubmitChanges();
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
public JsonResult SaveBill(BillVM B)
{
bool status = false;
if (ModelState.IsValid)
{
using (ERP1DataContext dc = new ERP1DataContext())
{
string Day = DateTime.Now.Day.ToString();
string Month = DateTime.Now.Month.ToString();
string Year = DateTime.Now.Year.ToString();
Bill bill = new Bill {
AppointmentID = B.AppointmentID, DoctorID = B.DoctorID, PatientID = B.PatientID, TotalAmount = decimal.Parse(B.TotalAmount), AddedDay = Day, AddedMonth = Month, AddedYear = Year
};
foreach (var i in B.BillDetails)
{
//
// i.TotalAmount =
bill.BillDetails.Add(i);
}
dc.Bills.InsertOnSubmit(bill);
dc.SubmitChanges();
status = true;
return(new JsonResult {
Data = new { status = status }
});
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public JsonResult SaveOrder(OrderVM O)
{
bool status = false;
if (ModelState.IsValid)
{
using (ERP1DataContext dc = new ERP1DataContext())
{
Order Order = new Order {
OrderDate = O.OrderDate, OrderStatus = O.OrderStatus, TotalAmount = O.TotalAmount, Payment = O.Payment
};
foreach (var i in O.OrderDetails)
{
//
// i.TotalAmount =
Order.OrderDetails.Add(i);
}
dc.Orders.InsertOnSubmit(Order);
dc.SubmitChanges();
status = true;
}
}
else
{
status = false;
}
return(new JsonResult {
Data = new { status = status }
});
}
//Get Event
public JsonResult GetEvents()
{
using (ERP1DataContext dc = new ERP1DataContext())
{
var events = dc.Schedules.ToList();
return(new JsonResult {
Data = events, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult SaveInvoice(InvoiceVM I)
{
bool status = false;
if (ModelState.IsValid)
{
using (ERP1DataContext dc = new ERP1DataContext())
{
string Day = DateTime.Now.Day.ToString();
string Month = DateTime.Now.Month.ToString();
string Year = DateTime.Now.Year.ToString();
Invoice invoice = new Invoice {
InvoiceDate = I.InvoiceDate, TotalAmount = I.TotalAmount, InvoiceStatus = I.InvoiceStatus, Payment = I.Payment, AppointmentID = I.AppointmentID, AddedDay = Day, AddedMonth = Month, AddedYear = Year
};
foreach (var i in I.InvoiceDetails)
{
//
// i.TotalAmount =
invoice.InvoiceDetails.Add(i);
}
dc.Invoices.InsertOnSubmit(invoice);
foreach (var v in I.QuantityDetails)
{
var data = dc.Stocks.Where(s => s.StockID == v.StockID).ToList();
foreach (Stock s in data)
{
s.Quantity = s.Quantity - v.Quantity;
}
foreach (var item in I.QuantityDetails)
{
StockOut Sout = new StockOut();
Sout.StockID = item.StockID;
Sout.StockName = item.ItemName;
Sout.StockQuantity = item.Quantity;
Sout.StockRevenue = item.cast;
Sout.AddedDay = Day;
Sout.AddedMonth = Month;
Sout.AddedYear = Year;
dc.StockOuts.InsertOnSubmit(Sout);
}
}
dc.SubmitChanges();
status = true;
}
}
else
{
status = false;
}
return(new JsonResult {
Data = new { status = status }
});
}
public List <AppointmentDetails> getAppointmentDetails(int ID)
{
ERP1DataContext dc = new ERP1DataContext();
var result = from app in dc.Appointments
join doc in dc.Doctors on app.DoctorID equals doc.DoctorID
join p in dc.Patients on app.PatientID equals p.PatientID
where app.PatientID == ID
select new
{
AppointmentID = app.AppointmentID,
DoctorID = doc.DoctorID,
Department = doc.Designation,
DoctorName = doc.FirstName + doc.LastName,
DoctorImage = doc.Image,
DoctorEmail = doc.DoctorEmail,
PatientID = p.PatientID,
PatientName = p.PatientName,
PatientEmail = p.PatientEmail,
PatientContact = p.PatientContact,
PatientImage = p.PatientImage,
Date = app.Date,
TimeSlot = app.TimeSlot,
Status = app.Status
};
var data = from r in result where (r.Status == "Scheduled") select r;
if (data != null)
{
foreach (var v in data)
{
AppointmentDetails details = new AppointmentDetails();
details.AppointmentID = v.AppointmentID;
details.DoctorID = v.DoctorID;
details.Designation = v.Department;
details.DoctorName = v.DoctorName;
details.DoctorImage = v.DoctorImage;
details.DoctorEmail = v.DoctorEmail;
details.PatientID = v.PatientID;
details.PatientName = v.PatientName;
details.PatientEmail = v.PatientEmail;
details.PatientContact = v.PatientContact;
details.PatientImage = v.PatientImage;
details.Date = v.Date.ToString();
details.TimeSlot = v.TimeSlot;
AppList.Add(details);
}
return(AppList);
}
return(AppList);
}
public JsonResult CheckPassword(string Password)
{
using (ERP1DataContext dc = new ERP1DataContext())
{
var result = dc.Users.Where(x => x.Password == Password).FirstOrDefault();
if (result != null)
{
return(Json(true, JsonRequestBehavior.AllowGet));
}
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
public void SaveAppointment(AppointmentModel amodel)
{
ERP1DataContext dc = new ERP1DataContext();
Appointment App = new Appointment();
{
App.DoctorID = amodel.DoctorID;
App.PatientID = amodel.PatientID;
App.Description = amodel.Description;
App.Date = amodel.Date;
App.TimeSlot = amodel.TimeSlot;
}
dc.Appointments.InsertOnSubmit(App);
dc.SubmitChanges();
}
public JsonResult CheckSchedule(string Date)
{
DateTime date = Convert.ToDateTime(Date);;
using (ERP1DataContext dc = new ERP1DataContext())
{
var result = dc.Schedules.Where(x => x.Start.Date == date.Date).FirstOrDefault();
if (result != null)
{
return(Json(true, JsonRequestBehavior.AllowGet));
}
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
public bool DeleteAppointment(int Id, bool status)
{
using (ERP1DataContext dc = new ERP1DataContext())
{
var AppData = dc.Appointments.Where(a => a.AppointmentID == Id).ToList();
if (AppData != null)
{
foreach (Appointment ds in AppData)
{
dc.Appointments.DeleteOnSubmit(ds);
}
dc.SubmitChanges();
return(status = true);
}
return(status = false);
}
}
//book
public bool BookDoctor(AppointmentModel App, bool status)
{
using (ERP1DataContext dc = new ERP1DataContext())
{
Appointment A = new Appointment();
A.DoctorID = App.DoctorID;
A.PatientID = App.PatientID;
A.Date = App.Date;
A.Description = App.Description;
A.TimeSlot = App.TimeSlot;
A.Status = "Scheduled";
dc.Appointments.InsertOnSubmit(A);
dc.SubmitChanges();
status = true;
return(status);
}
}
//timeSlot
public bool TimeSlot(bool status, int DocID, string Date, string slot)
{
DateTime date = Convert.ToDateTime(Date);;
using (ERP1DataContext dc = new ERP1DataContext())
{
var result = dc.Appointments.Where(x => x.Date == date.Date && x.DoctorID == DocID && x.TimeSlot == slot).FirstOrDefault();
if (result != null)
{
status = true;
return(status);
}
else
{
status = false;
return(status);
}
}
}
public bool CheckSchedule(bool status, string Date)
{
DateTime date = Convert.ToDateTime(Date);;
using (ERP1DataContext dc = new ERP1DataContext())
{
var result = dc.Schedules.Where(x => x.Start.Date == date.Date).FirstOrDefault();
if (result != null)
{
status = true;
return(status);
}
else
{
status = false;
return(status);
}
}
}
public JsonResult CheckQuanity(int Quantity, int id)
{
bool status = false;
if (ModelState.IsValid)
{
using (ERP1DataContext dc = new ERP1DataContext())
{
bool status1 = dc.Stocks.Where(s => s.StockID == id).Any(s => s.Quantity < Quantity);
return(new JsonResult {
Data = new { status = status1 }
});
}
}
else
{
status = false;
return(new JsonResult {
Data = new { status = status }
});
}
}
public JsonResult SavePrescription(PrescriptionVM P)
{
bool status = false;
if (ModelState.IsValid)
{
using (ERP1DataContext dc = new ERP1DataContext())
{
Prescription pres = new Prescription {
AppointmentID = P.AppointmentID, DoctorID = P.DoctorID, PatientID = P.PatientID
};
foreach (var i in P.MedDetails)
{
//
// i.TotalAmount =
pres.Medications.Add(i);
}
dc.Prescriptions.InsertOnSubmit(pres);
dc.SubmitChanges();
var data = dc.Appointments.Where(a => a.AppointmentID == P.AppointmentID).ToList();
foreach (Appointment A in data)
{
//
// i.TotalAmount =
A.Status = "Prescribed";
dc.SubmitChanges();
}
dc.SubmitChanges();
status = true;
}
}
else
{
status = false;
}
return(new JsonResult {
Data = new { status = status }
});
}
public JsonResult deleteEvent(int eventID)
{
var status = false;
using (ERP1DataContext dc = new ERP1DataContext())
{
var v = dc.Schedules.Where(a => a.EventID == eventID).FirstOrDefault();
var data = dc.DoctorSchedules.Where(a => a.EventID == eventID).ToList();
if (v != null || data != null)
{
foreach (DoctorSchedule ds in data)
{
dc.DoctorSchedules.DeleteOnSubmit(ds);
}
dc.Schedules.DeleteOnSubmit(v);
dc.SubmitChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public JsonResult SaveSchedule(int DoctorID, int EventID)
{
bool status = false;
if (ModelState.IsValid)
{
using (ERP1DataContext dc = new ERP1DataContext())
{
DoctorSchedule ds = new DoctorSchedule();
ds.DoctorID = DoctorID;
ds.EventID = EventID;
dc.DoctorSchedules.InsertOnSubmit(ds);
dc.SubmitChanges();
status = true;
}
}
else
{
status = false;
}
return(new JsonResult {
Data = new { status = status }
});
}
