예제 #1
0
        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));
        }
예제 #2
0
        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));
        }
예제 #3
0
        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));
        }