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); }