public IHttpActionResult DatetimeslotbyId(string DATETIMESLOTID) { db.Configuration.ProxyCreationEnabled = false; DATETIMESLOT abc = new DATETIMESLOT(); try { int ID = Convert.ToInt32(DATETIMESLOTID); abc = db.DATETIMESLOTs.Find(ID); if (abc == null) { return(NotFound()); } } catch (Exception) { dynamic User = new ExpandoObject(); User.Message = "Something went wrong !"; return(null); } return(Ok(abc)); }
public IHttpActionResult PostDateSlot(EmpSlot data) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { var date = db.DATETIMESLOTs.Where(kk => kk.DATEID == data.DateID && kk.SLOTID == data.SlotID).ToList(); if (date.Count == 0) { DATETIMESLOT DATETIMESLOT = new DATETIMESLOT(); DATETIMESLOT.DATEID = data.DateID; DATETIMESLOT.SLOTID = data.SlotID; DATETIMESLOT.AREAID = data.AreaID; db.DATETIMESLOTs.Add(DATETIMESLOT); db.SaveChanges(); } else { return(Ok(false)); } int value = int.Parse(db.DATETIMESLOTs .OrderByDescending(p => p.DATETIMESLOTID) .Select(r => r.DATETIMESLOTID) .First().ToString()); EMPLOYEEDATETIMESLOT EMPLOYEEDATETIMESLOT = new EMPLOYEEDATETIMESLOT(); EMPLOYEEDATETIMESLOT.EMPLOYEEID = data.EmployeeID; EMPLOYEEDATETIMESLOT.EMPLOYEESLOTSTAUSID = 1; EMPLOYEEDATETIMESLOT.DATETIMESLOTID = value; db.EMPLOYEEDATETIMESLOTs.Add(EMPLOYEEDATETIMESLOT); db.SaveChanges(); } catch (Exception) { dynamic User = new ExpandoObject(); User.Message = "Something went wrong !"; return(null); } return(Ok(data)); }
public IHttpActionResult PostDateSlot(DATETIMESLOT data) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { db.DATETIMESLOTs.Add(data); db.SaveChanges(); } catch (Exception) { dynamic User = new ExpandoObject(); User.Message = "Something went wrong !"; return(User); } return(Ok(data)); }