public ActionResult CreateTiming(BOAvailableTiming model)
{
model.VipId = VIPID;
blavailable.AddAvailableTiming(model);
return(RedirectToAction("VIP", new { id = VIPID }));
}
public ActionResult FixAppointment(BOAvailableTiming model)
{
if (ModelState.IsValid)
{
model.VipId = VIPID;
available.AddAvailableTiming(model);
}
return(View());
}
public int UpdateAvailableTiming(BOAvailableTiming model)
{
using (_db)
{
tblAvailableTiming available = _db.tblAvailableTimings.Where(u => u.Id == model.Id).FirstOrDefault();
available.Date = model.Date;
available.StartTime = model.StartTime;
available.EndTime = model.EndTime;
available.IsAvailable = model.IsAvailable;
available.VipId = model.VipId;
return(_db.SaveChanges());
}
}
public int AddAvailableTiming(BOAvailableTiming model)
{
using (_db)
{
tblAvailableTiming available = new tblAvailableTiming();
available.Date = model.Date;
available.StartTime = model.StartTime;
available.EndTime = model.EndTime;
available.IsAvailable = model.IsAvailable;
available.VipId = model.VipId;
_db.tblAvailableTimings.Add(available);
return(_db.SaveChanges());
}
}
public BOAvailableTiming GetIndividualAvailableTiming(int id)
{
using ( _db )
{
var temp = _db.tblAvailableTimings.Where(u => u.Id == id).SingleOrDefault();
BOAvailableTiming available = new BOAvailableTiming();
available.Id = temp.Id;
available.StartTime = temp.StartTime;
available.Date = temp.Date;
available.EndTime = temp.EndTime;
available.IsAvailable = temp.IsAvailable;
available.VipId = temp.VipId;
return(available);
}
}
public JsonResult Update(BOAvailableTiming model)
{
model.VipId = VIPID;
int date = DateTime.Compare(DateTime.Now, Convert.ToDateTime(model.Date)); //now < myone ==>-1
int results = DateTime.Compare(Convert.ToDateTime(model.EndTime), Convert.ToDateTime(model.StartTime));
if (date <= 0 && results > 0)
{
var appointment = available.UpdateAvailableTiming(model);
return(Json(appointment, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(-1, JsonRequestBehavior.AllowGet));
}
}
public List <BOAvailableTiming> GetAllAvailableTiming()
{
using (_db)
{
List <BOAvailableTiming> lst = new List <BOAvailableTiming>();
var temp = _db.tblAvailableTimings.ToList();
foreach (var model in temp)
{
BOAvailableTiming available = new BOAvailableTiming();
available.Id = model.Id;
available.Date = model.Date;
available.StartTime = model.StartTime;
available.EndTime = model.EndTime;
available.IsAvailable = model.IsAvailable;
available.VipId = model.VipId;
lst.Add(available);
}
return(lst);
}
}
public ActionResult EditAvailableTiming(BOAvailableTiming model)
{
blavailable.UpdateAvailableTiming(model);
return(RedirectToAction("VIP", new { id = VIPID }));
}
public ActionResult EditAvailableTiming(int id)
{
BOAvailableTiming model = blavailable.GetIndividualAvailableTiming(id);
return(View(model));
}
