public HttpResponseMessage AddPurchaseRequestItem(Entities.TrnPurchaseRequestItem objPurchaseRequestItem, String PRId)
{
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("PurchaseRequestDetail")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanAdd)
{
var purchaseRequest = from d in db.TrnPurchaseRequests
where d.Id == Convert.ToInt32(PRId)
select d;
if (purchaseRequest.Any())
{
if (!purchaseRequest.FirstOrDefault().IsLocked)
{
var item = from d in db.MstArticles
where d.Id == objPurchaseRequestItem.ItemId &&
d.ArticleTypeId == 1 &&
d.IsLocked == true
select d;
if (item.Any())
{
var conversionUnit = from d in db.MstArticleUnits
where d.ArticleId == objPurchaseRequestItem.ItemId &&
d.UnitId == objPurchaseRequestItem.UnitId &&
d.MstArticle.IsLocked == true
select d;
if (conversionUnit.Any())
{
Decimal baseQuantity = objPurchaseRequestItem.Quantity * 1;
if (conversionUnit.FirstOrDefault().Multiplier > 0)
{
baseQuantity = objPurchaseRequestItem.Quantity * (1 / conversionUnit.FirstOrDefault().Multiplier);
}
Decimal baseCost = objPurchaseRequestItem.Amount;
if (baseQuantity > 0)
{
baseCost = objPurchaseRequestItem.Amount / baseQuantity;
}
Data.TrnPurchaseRequestItem newPurchaseRequestItem = new Data.TrnPurchaseRequestItem
{
PRId = objPurchaseRequestItem.PRId,
ItemId = objPurchaseRequestItem.ItemId,
Particulars = objPurchaseRequestItem.Particulars,
UnitId = objPurchaseRequestItem.UnitId,
Quantity = objPurchaseRequestItem.Quantity,
Cost = objPurchaseRequestItem.Cost,
Amount = objPurchaseRequestItem.Amount,
BaseUnitId = item.FirstOrDefault().UnitId,
BaseQuantity = baseQuantity,
BaseCost = baseCost
};
db.TrnPurchaseRequestItems.InsertOnSubmit(newPurchaseRequestItem);
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 request item if the current purchase request detail is locked."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "These current purchase request details are not found in the server. Please add new purchase request first before proceeding."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add new purchase request item in this purchase request detail page."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access in this purchase request 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 ApplyPurchaseRequestConsignment(List <Entities.TrnSalesInvoiceItem> objItems, String PRId)
{
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 currentBranchId = currentUser.FirstOrDefault().BranchId;
IQueryable <Data.MstUserForm> userForms = from d in db.MstUserForms where d.UserId == currentUserId && d.SysForm.FormName.Equals("PurchaseRequestDetail") select d;
IQueryable <Data.TrnPurchaseRequest> purchaseRequest = from d in db.TrnPurchaseRequests where d.Id == Convert.ToInt32(PRId) select d;
Boolean isValid = false;
String returnMessage = "";
if (!userForms.Any())
{
returnMessage = "Sorry. You have no access in this purchase request detail page.";
}
else if (!userForms.FirstOrDefault().CanAdd)
{
returnMessage = "Sorry. You have no rights to add new purchase request item in this purchase request detail page.";
}
else if (!purchaseRequest.Any())
{
returnMessage = "These current purchase request details are not found in the server. Please add new purchase request first before proceeding.";
}
else if (purchaseRequest.FirstOrDefault().IsLocked)
{
returnMessage = "You cannot apply consignment items to purchase request item if the current purchase request detail is locked.";
}
else if (!objItems.Any())
{
returnMessage = "There are no consignment items.";
}
else
{
isValid = true;
}
if (isValid)
{
String newObject = "[";
Int32 count = 0;
foreach (var objItem in objItems)
{
count += 1;
var item = from d in db.MstArticles
where d.Id == objItem.ItemId &&
d.ArticleTypeId == 1 &&
d.IsLocked == true
select d;
if (item.Any())
{
var conversionUnit = from d in db.MstArticleUnits
where d.ArticleId == objItem.ItemId &&
d.UnitId == objItem.UnitId &&
d.MstArticle.IsLocked == true
select d;
if (conversionUnit.Any())
{
Decimal baseQuantity = objItem.Quantity * 1;
if (conversionUnit.FirstOrDefault().Multiplier > 0)
{
baseQuantity = objItem.Quantity * (1 / conversionUnit.FirstOrDefault().Multiplier);
}
Decimal baseCost = objItem.Amount;
if (baseQuantity > 0)
{
baseCost = objItem.Amount / baseQuantity;
}
Data.TrnPurchaseRequestItem newPurchaseRequestItem = new Data.TrnPurchaseRequestItem
{
PRId = Convert.ToInt32(PRId),
ItemId = objItem.ItemId,
Particulars = "Consignment Item",
UnitId = objItem.UnitId,
Quantity = objItem.Quantity,
Cost = objItem.Cost,
Amount = objItem.Amount,
BaseUnitId = item.FirstOrDefault().UnitId,
BaseQuantity = baseQuantity,
BaseCost = baseCost
};
db.TrnPurchaseRequestItems.InsertOnSubmit(newPurchaseRequestItem);
if (objItems.Count() == 1)
{
newObject += auditTrail.GetObjectString(newPurchaseRequestItem);
}
else
{
if (count == objItems.Count())
{
newObject += auditTrail.GetObjectString(newPurchaseRequestItem);
}
else
{
newObject += auditTrail.GetObjectString(newPurchaseRequestItem) + ", ";
}
}
}
}
}
db.SubmitChanges();
newObject += "]";
auditTrail.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, "NA", newObject);
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, returnMessage));
}
}
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."));
}
}
