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.")); } }
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.")); } }