public ActionResult SaveToDateTimeTable(FormCollection fc)
{
BODateTime bDateTime = new BODateTime();
BOAppointmentDetails bAppointment = new BOAppointmentDetails();
var companyId = fc["dropdownCompany"].ToString(); //CompanyId
var vipId = fc["dropdownVIP"].ToString(); //VipId
var dateId = fc["dropdownDate"].ToString();
var dateValue = bllAvailable.GetAllAvailableTiming().Where(u => u.Id == Convert.ToInt32(dateId)).SingleOrDefault().Date; ////date
bDateTime.Date = Convert.ToDateTime(dateValue);
//string resultString = Regex.Match(bDateTime.Date.ToString(), @"\d{4}-\d{2}-\d{2}").Value;
bDateTime.FromTime = fc["dropdownInterval"].ToString();
bDateTime.ToTime = endTime;
bDateTime.IsCanceled = false;
int i = bllDateTime.CreateDateTime(bDateTime);
bAppointment.DepartmentId = Convert.ToInt32(fc["dropdownDepartment"].ToString());
bAppointment.AppointmentFrom = emailId;
bAppointment.AppointmentTo = bllVIP.GetAllVIP().Where(u => u.Id == Convert.ToInt32(vipId)).SingleOrDefault().Email;
bAppointment.DateTimeId = bllDateTime.GetLastId();
bAppointment.Details = fc["Details"].ToString();
bAppointment.status = "True";
int j = bllAppointment.CreateAppointment(bAppointment);
if (j > 0)
{
ViewBag.Appointment = "Successfully Created";
}
else
{
ViewBag.Appointment = "Failed";
}
return(RedirectToAction("FixAppointment"));
}
public int UpdateAppointment(BOAppointmentDetails model)
{
tblAppointment appointment = _db.tblAppointments.Where(u => u.Id == model.Id).FirstOrDefault();
appointment.AppointmentFrom = model.AppointmentFrom;
appointment.AppointmentTo = model.AppointmentTo;
appointment.DateTimeId = model.DateTimeId;
appointment.DepartmentId = model.DepartmentId;
appointment.Details = model.Details;
return(_db.SaveChanges());
}
public int CreateAppointment(BOAppointmentDetails model)
{
tblAppointment appointment = new tblAppointment();
appointment.DepartmentId = model.DepartmentId;
appointment.AppointmentFrom = model.AppointmentFrom;
appointment.AppointmentTo = model.AppointmentTo;
appointment.DateTimeId = model.DateTimeId;
appointment.Details = model.Details;
_db.tblAppointments.Add(appointment);
return(_db.SaveChanges());
}
public List <BOAppointmentDetails> GetAllAppointment()
{
List <BOAppointmentDetails> lst = new List <BOAppointmentDetails>();
var temp = _db.tblAppointments.ToList();
foreach (var model in temp)
{
BOAppointmentDetails appointment = new BOAppointmentDetails();
appointment.AppointmentFrom = model.AppointmentFrom;
appointment.AppointmentTo = model.AppointmentTo;
appointment.DateTimeId = model.DateTimeId;
appointment.DepartmentId = model.DepartmentId;
appointment.Details = model.Details;
lst.Add(appointment);
}
return(lst);
}
