public HttpResponseMessage AddArticlePriceItem(Entities.TrnArticlePriceItem objArticlePriceItem, String articlePriceId) { 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("ItemPriceDetail") select d; if (userForms.Any()) { if (userForms.FirstOrDefault().CanAdd) { var articlePrice = from d in db.TrnArticlePrices where d.Id == Convert.ToInt32(articlePriceId) select d; if (articlePrice.Any()) { if (!articlePrice.FirstOrDefault().IsLocked) { var articles = from d in db.MstArticles where d.Id == objArticlePriceItem.ItemId && d.IsLocked == true select d; if (articles.Any()) { Data.TrnArticlePriceItem newArticlePriceItem = new Data.TrnArticlePriceItem { ArticlePriceId = Convert.ToInt32(articlePriceId), ItemId = articles.FirstOrDefault().Id, Price = objArticlePriceItem.Price, TriggerQuantity = objArticlePriceItem.TriggerQuantity }; db.TrnArticlePriceItems.InsertOnSubmit(newArticlePriceItem); db.SubmitChanges(); String newObject = at.GetObjectString(newArticlePriceItem); at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, "NA", newObject); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "No Article.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "You cannot add new article price item if the current item price detail is locked.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "These current item price details are not found in the server. Please add new item price first before proceeding.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add new article price item in this item price detail page.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access in this item price detail page.")); } } 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 UpdateArticlePriceItem(Entities.TrnArticlePriceItem objArticlePriceItem, String id, String articlePriceId) { 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("ItemPriceDetail") select d; if (userForms.Any()) { if (userForms.FirstOrDefault().CanEdit) { var articlePrice = from d in db.TrnArticlePrices where d.Id == Convert.ToInt32(articlePriceId) select d; if (articlePrice.Any()) { if (!articlePrice.FirstOrDefault().IsLocked) { var articlePriceItem = from d in db.TrnArticlePriceItems where d.Id == Convert.ToInt32(id) select d; if (articlePriceItem.Any()) { var articles = from d in db.MstArticles where d.Id == objArticlePriceItem.ItemId && d.IsLocked == true select d; if (articles.Any()) { var updateArticlePriceItem = articlePriceItem.FirstOrDefault(); updateArticlePriceItem.ItemId = articles.FirstOrDefault().Id; updateArticlePriceItem.Price = objArticlePriceItem.Price; updateArticlePriceItem.TriggerQuantity = objArticlePriceItem.TriggerQuantity; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "No Article.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "This article price item detail is no longer exist in the server.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "You cannot add new article price item if the current item price detail is locked.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "These current item price details are not found in the server. Please add new item price first before proceeding.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to edit and update article price item in this item price detail page.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access in this item price detail page.")); } } 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.")); } }