Beispiel #1
0
        public HttpResponseMessage updateUnit(String id, Models.MstUnit unit)
        {
            try
            {
                var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();

                var units = from d in db.MstUnits where d.Id == Convert.ToInt32(id) select d;
                if (units.Any())
                {
                    var updateUnit = units.FirstOrDefault();

                    updateUnit.Unit            = unit.Unit;
                    updateUnit.IsLocked        = unit.IsLocked;
                    updateUnit.UpdatedById     = userId;
                    updateUnit.UpdatedDateTime = DateTime.Now;

                    db.SubmitChanges();

                    return(Request.CreateResponse(HttpStatusCode.OK));
                }
                else
                {
                    return(Request.CreateResponse(HttpStatusCode.NotFound));
                }
            }
            catch
            {
                return(Request.CreateResponse(HttpStatusCode.BadRequest));
            }
        }
Beispiel #2
0
        public Int32 insertUnit(Models.MstUnit unit)
        {
            try
            {
                var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();

                Data.MstUnit newUnit = new Data.MstUnit();
                newUnit.Unit            = unit.Unit;
                newUnit.IsLocked        = unit.IsLocked;
                newUnit.CreatedById     = userId;
                newUnit.CreatedDateTime = DateTime.Now;
                newUnit.UpdatedById     = userId;
                newUnit.UpdatedDateTime = DateTime.Now;

                db.MstUnits.InsertOnSubmit(newUnit);
                db.SubmitChanges();

                return(newUnit.Id);
            }
            catch
            {
                return(0);
            }
        }