Beispiel #1
0
        public HttpResponseMessage UpdateAccount(Entities.MstArticleInventorySerial objItemInventorySerial, String id)
        {
            try
            {
                var currentUser = from d in db.MstUsers
                                  where d.UserId == User.Identity.GetUserId()
                                  select d;

                if (currentUser.Any())
                {
                    var currentUserId = currentUser.FirstOrDefault().Id;

                    var userForms = from d in db.MstUserForms
                                    where d.UserId == currentUserId &&
                                    d.SysForm.FormName.Equals("ItemList")
                                    select d;

                    if (userForms.Any())
                    {
                        if (userForms.FirstOrDefault().CanEdit)
                        {
                            var itemInventorySerial = from d in db.MstArticleInventorySerials
                                                      where d.Id == Convert.ToInt32(id)
                                                      select d;

                            if (itemInventorySerial.Any())
                            {
                                String oldObject = at.GetObjectString(itemInventorySerial.FirstOrDefault());

                                var updateItemInventorySerial = itemInventorySerial.FirstOrDefault();
                                updateItemInventorySerial.ArticleId          = objItemInventorySerial.ArticleId;
                                updateItemInventorySerial.ArticleInventoryId = objItemInventorySerial.ArticleInventoryId;
                                updateItemInventorySerial.SerialNumber       = objItemInventorySerial.SerialNumber;
                                updateItemInventorySerial.LotNumber          = objItemInventorySerial.LotNumber;
                                updateItemInventorySerial.RegistrationNumber = objItemInventorySerial.RegistrationNumber;
                                updateItemInventorySerial.ManufacturingDate  = Convert.ToDateTime(objItemInventorySerial.ManufacturingDate);
                                updateItemInventorySerial.ExpiryDate         = Convert.ToDateTime(objItemInventorySerial.ExpiryDate);
                                updateItemInventorySerial.Particulars        = objItemInventorySerial.Particulars;

                                db.SubmitChanges();

                                String newObject = at.GetObjectString(itemInventorySerial.FirstOrDefault());
                                at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, oldObject, newObject);

                                return(Request.CreateResponse(HttpStatusCode.OK));
                            }
                            else
                            {
                                return(Request.CreateResponse(HttpStatusCode.NotFound, "This item inventory serial detail is no longer available."));
                            }
                        }
                        else
                        {
                            return(Request.CreateResponse(HttpStatusCode.NotFound, "No rights."));
                        }
                    }
                    else
                    {
                        return(Request.CreateResponse(HttpStatusCode.NotFound, "No rights."));
                    }
                }
                else
                {
                    return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in."));
                }
            }
            catch (Exception e)
            {
                Debug.WriteLine(e);
                return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server."));
            }
        }
Beispiel #2
0
        public HttpResponseMessage AddItemInventorySerial(Entities.MstArticleInventorySerial objItemInventorySerial)
        {
            try
            {
                var currentUser = from d in db.MstUsers
                                  where d.UserId == User.Identity.GetUserId()
                                  select d;

                if (currentUser.Any())
                {
                    var currentUserId = currentUser.FirstOrDefault().Id;

                    var userForms = from d in db.MstUserForms
                                    where d.UserId == currentUserId &&
                                    d.SysForm.FormName.Equals("ItemList")
                                    select d;

                    if (userForms.Any())
                    {
                        if (userForms.FirstOrDefault().CanAdd)
                        {
                            var currentBranchId = currentUser.FirstOrDefault().BranchId;

                            Data.MstArticleInventorySerial newItemInventorySerial = new Data.MstArticleInventorySerial
                            {
                                BranchId           = currentBranchId,
                                ArticleId          = objItemInventorySerial.ArticleId,
                                ArticleInventoryId = objItemInventorySerial.ArticleInventoryId,
                                SerialNumber       = objItemInventorySerial.SerialNumber,
                                LotNumber          = objItemInventorySerial.LotNumber,
                                RegistrationNumber = objItemInventorySerial.RegistrationNumber,
                                ManufacturingDate  = Convert.ToDateTime(objItemInventorySerial.ManufacturingDate),
                                ExpiryDate         = Convert.ToDateTime(objItemInventorySerial.ExpiryDate),
                                Quantity           = 0,
                                Particulars        = objItemInventorySerial.Particulars
                            };

                            db.MstArticleInventorySerials.InsertOnSubmit(newItemInventorySerial);
                            db.SubmitChanges();

                            String newObject = at.GetObjectString(newItemInventorySerial);
                            at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, "NA", newObject);

                            return(Request.CreateResponse(HttpStatusCode.OK));
                        }
                        else
                        {
                            return(Request.CreateResponse(HttpStatusCode.NotFound, "No rights."));
                        }
                    }
                    else
                    {
                        return(Request.CreateResponse(HttpStatusCode.NotFound, "No rights."));
                    }
                }
                else
                {
                    return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in."));
                }
            }
            catch (Exception e)
            {
                Debug.WriteLine(e);
                return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server."));
            }
        }