public HttpResponseMessage UpdatePurchaseOrderItem(Entities.TrnPurchaseOrderItem objPurchaseOrderItem, String id, String POId)
{
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("PurchaseOrderDetail")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanEdit)
{
var purchaseOrder = from d in db.TrnPurchaseOrders
where d.Id == Convert.ToInt32(POId)
select d;
if (purchaseOrder.Any())
{
if (!purchaseOrder.FirstOrDefault().IsLocked)
{
var purchaseOrderItem = from d in db.TrnPurchaseOrderItems
where d.Id == Convert.ToInt32(id)
select d;
if (purchaseOrderItem.Any())
{
String oldObject = at.GetObjectString(purchaseOrderItem.FirstOrDefault());
var item = from d in db.MstArticles
where d.Id == objPurchaseOrderItem.ItemId &&
d.ArticleTypeId == 1 &&
d.IsLocked == true
select d;
if (item.Any())
{
var conversionUnit = from d in db.MstArticleUnits
where d.ArticleId == item.FirstOrDefault().Id &&
d.UnitId == objPurchaseOrderItem.UnitId &&
d.MstArticle.IsLocked == true
select d;
if (conversionUnit.Any())
{
Decimal baseQuantity = objPurchaseOrderItem.Quantity * 1;
if (conversionUnit.FirstOrDefault().Multiplier > 0)
{
baseQuantity = objPurchaseOrderItem.Quantity * (1 / conversionUnit.FirstOrDefault().Multiplier);
}
Decimal baseCost = objPurchaseOrderItem.Amount;
if (baseQuantity > 0)
{
baseCost = objPurchaseOrderItem.Amount / baseQuantity;
}
var updatePurchaseOrdeItem = purchaseOrderItem.FirstOrDefault();
updatePurchaseOrdeItem.ItemId = item.FirstOrDefault().Id;
updatePurchaseOrdeItem.Particulars = objPurchaseOrderItem.Particulars;
updatePurchaseOrdeItem.UnitId = conversionUnit.FirstOrDefault().UnitId;
updatePurchaseOrdeItem.Quantity = objPurchaseOrderItem.Quantity;
updatePurchaseOrdeItem.Cost = objPurchaseOrderItem.Cost;
updatePurchaseOrdeItem.Amount = objPurchaseOrderItem.Amount;
updatePurchaseOrdeItem.BaseUnitId = item.FirstOrDefault().UnitId;
updatePurchaseOrdeItem.BaseQuantity = baseQuantity;
updatePurchaseOrdeItem.BaseCost = baseCost;
db.SubmitChanges();
String newObject = at.GetObjectString(purchaseOrderItem.FirstOrDefault());
at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, oldObject, newObject);
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "The selected item has no unit conversion."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "The selected item was not found in the server."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "This purchase order item detail is no longer exist in the server."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "You cannot update purchase order item if the current purchase order detail is locked."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "These current purchase order details are not found in the server. Please add new purchase order first before proceeding."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to edit and update purchase order item in this purchase order detail page."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access in this purchase order 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 AddPurchaseOrderItem(Entities.TrnPurchaseOrderItem objPurchaseOrderItem, String POId)
{
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("PurchaseOrderDetail")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanAdd)
{
var purchaseOrder = from d in db.TrnPurchaseOrders
where d.Id == Convert.ToInt32(POId)
select d;
if (purchaseOrder.Any())
{
if (!purchaseOrder.FirstOrDefault().IsLocked)
{
var item = from d in db.MstArticles
where d.Id == objPurchaseOrderItem.ItemId &&
d.ArticleTypeId == 1 &&
d.IsLocked == true
select d;
if (item.Any())
{
var conversionUnit = from d in db.MstArticleUnits
where d.ArticleId == objPurchaseOrderItem.ItemId &&
d.UnitId == objPurchaseOrderItem.UnitId &&
d.MstArticle.IsLocked == true
select d;
if (conversionUnit.Any())
{
Decimal baseQuantity = objPurchaseOrderItem.Quantity * 1;
if (conversionUnit.FirstOrDefault().Multiplier > 0)
{
baseQuantity = objPurchaseOrderItem.Quantity * (1 / conversionUnit.FirstOrDefault().Multiplier);
}
Decimal baseCost = objPurchaseOrderItem.Amount;
if (baseQuantity > 0)
{
baseCost = objPurchaseOrderItem.Amount / baseQuantity;
}
Data.TrnPurchaseOrderItem newPurchaseOrderItem = new Data.TrnPurchaseOrderItem
{
POId = objPurchaseOrderItem.POId,
ItemId = objPurchaseOrderItem.ItemId,
Particulars = objPurchaseOrderItem.Particulars,
UnitId = objPurchaseOrderItem.UnitId,
Quantity = objPurchaseOrderItem.Quantity,
Cost = objPurchaseOrderItem.Cost,
Amount = objPurchaseOrderItem.Amount,
BaseUnitId = item.FirstOrDefault().UnitId,
BaseQuantity = baseQuantity,
BaseCost = baseCost
};
db.TrnPurchaseOrderItems.InsertOnSubmit(newPurchaseOrderItem);
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "The selected item has no unit conversion."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "The selected item was not found in the server."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "You cannot add new purchase order item if the current purchase order detail is locked."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "These current purchase order details are not found in the server. Please add new purchase order first before proceeding."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add new purchase order item in this purchase order detail page."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access in this purchase order 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."));
}
}
