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