public Int32 postPurchaseOrder(Entities.TrnPurchaseOrder add)
{
try
{
var period = from d in db.MstPeriods select d.Id;
var supplier = from d in db.MstSuppliers select d;
var collection = from d in db.TrnCollections select d;
var purcherOrder = from d in db.TrnPurchaseOrders select d;
var user = from d in db.MstUsers select d;
var stockIn = from d in db.TrnStockIns.OrderByDescending(m => m.StockInNumber) select d;
var userId = (from d in db.MstUsers where d.AspNetUserId == User.Identity.GetUserId() select d).FirstOrDefault().Id;
Data.TrnPurchaseOrder addPurchaseOrder = new Data.TrnPurchaseOrder();
addPurchaseOrder.PeriodId = period.FirstOrDefault();
addPurchaseOrder.PurchaseOrderDate = DateTime.Today;
addPurchaseOrder.PurchaseOrderNumber = purcherOrder.Select(m => m.PurchaseOrderNumber).FirstOrDefault();
addPurchaseOrder.Amount = 0;
addPurchaseOrder.SupplierId = supplier.Select(m => m.Id).FirstOrDefault();
addPurchaseOrder.Remarks = "n/a";
addPurchaseOrder.PreparedBy = user.Select(m => m.Id).FirstOrDefault();
addPurchaseOrder.CheckedBy = user.Select(m => m.Id).FirstOrDefault();
addPurchaseOrder.ApprovedBy = user.Select(m => m.Id).FirstOrDefault();
addPurchaseOrder.IsLocked = false;
addPurchaseOrder.EntryUserId = userId;
addPurchaseOrder.EntryDateTime = DateTime.Today;
addPurchaseOrder.UpdateUserId = userId;
addPurchaseOrder.UpdateDateTime = DateTime.Today;
db.TrnPurchaseOrders.InsertOnSubmit(addPurchaseOrder);
db.SubmitChanges();
return(addPurchaseOrder.Id);
}
catch (Exception e)
{
Debug.WriteLine(e);
return(0);
}
}
public HttpResponseMessage putUser(String id, Entities.TrnPurchaseOrder purchaseOrder)
{
try
{
var purchaseOrders = from d in db.TrnPurchaseOrders where d.Id == Convert.ToInt32(id) select d;
if (purchaseOrders.Any())
{
//var userId = (from d in db.MstUsers where d.AspNetUserId == User.Identity.GetUserId() select d).FirstOrDefault().Id;
var updatePurchaseOrder = purchaseOrders.FirstOrDefault();
updatePurchaseOrder.PeriodId = purchaseOrder.PeriodId;
updatePurchaseOrder.PurchaseOrderDate = Convert.ToDateTime(purchaseOrder.PurchaseOrderDate);
updatePurchaseOrder.PurchaseOrderNumber = purchaseOrder.PurchaseOrderNumber;
updatePurchaseOrder.Amount = purchaseOrder.Amount;
updatePurchaseOrder.SupplierId = purchaseOrder.SupplierId;
updatePurchaseOrder.Remarks = purchaseOrder.Remarks;
updatePurchaseOrder.PreparedBy = purchaseOrder.PreparedBy;
updatePurchaseOrder.CheckedBy = purchaseOrder.CheckedBy;
updatePurchaseOrder.ApprovedBy = purchaseOrder.ApprovedBy;
updatePurchaseOrder.IsLocked = purchaseOrder.IsLocked;
updatePurchaseOrder.EntryUserId = purchaseOrder.EntryUserId;
updatePurchaseOrder.EntryDateTime = DateTime.Now;
updatePurchaseOrder.UpdateUserId = purchaseOrder.UpdateUserId;
updatePurchaseOrder.UpdateDateTime = DateTime.Now;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public HttpResponseMessage LockPurchaseOrder(Entities.TrnPurchaseOrder objPurchaseOrder, 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("PurchaseOrderDetail")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanLock)
{
var purchaseOrder = from d in db.TrnPurchaseOrders
where d.Id == Convert.ToInt32(id)
select d;
if (purchaseOrder.Any())
{
if (!purchaseOrder.FirstOrDefault().IsLocked)
{
var lockPurchaseOrder = purchaseOrder.FirstOrDefault();
lockPurchaseOrder.PODate = Convert.ToDateTime(objPurchaseOrder.PODate);
lockPurchaseOrder.SupplierId = objPurchaseOrder.SupplierId;
lockPurchaseOrder.TermId = objPurchaseOrder.TermId;
lockPurchaseOrder.ManualRequestNumber = objPurchaseOrder.ManualRequestNumber;
lockPurchaseOrder.ManualPONumber = objPurchaseOrder.ManualPONumber;
lockPurchaseOrder.DateNeeded = Convert.ToDateTime(objPurchaseOrder.DateNeeded);
lockPurchaseOrder.Remarks = objPurchaseOrder.Remarks;
lockPurchaseOrder.IsClose = objPurchaseOrder.IsClose;
lockPurchaseOrder.RequestedById = objPurchaseOrder.RequestedById;
lockPurchaseOrder.CheckedById = objPurchaseOrder.CheckedById;
lockPurchaseOrder.ApprovedById = objPurchaseOrder.ApprovedById;
lockPurchaseOrder.IsLocked = true;
lockPurchaseOrder.UpdatedById = currentUserId;
lockPurchaseOrder.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
if (purchaseOrder.FirstOrDefault().TrnPurchaseOrderItems.Any())
{
foreach (var purchaseOrderItem in purchaseOrder.FirstOrDefault().TrnPurchaseOrderItems.ToList())
{
var item = from d in db.MstArticles
where d.Id == purchaseOrderItem.ItemId
select d;
if (item.Any())
{
var updateItem = item.FirstOrDefault();
updateItem.Cost = purchaseOrderItem.Cost;
}
}
db.SubmitChanges();
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Locking Error. These purchase order details are already locked."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These purchase order details are not found in the server."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to lock purchase order."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this purchase order 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."));
}
}
