public HttpResponseMessage unlockPurchaseOrder(String id, Models.TrnPurchaseOrder purchaseOrder)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
var purchaseOrders = from d in db.TrnPurchaseOrders where d.Id == Convert.ToInt32(id) select d;
if (purchaseOrders.Any())
{
var unlockPurchaseOrder = purchaseOrders.FirstOrDefault();
unlockPurchaseOrder.IsLocked = false;
unlockPurchaseOrder.UpdatedById = userId;
unlockPurchaseOrder.UpdatedDateTime = DateTime.Now;;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public Int32 insertPurchaseOrder(Models.TrnPurchaseOrder purchaseOrder)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
var PONumberResult = "0000000001";
var lastPONumber = from d in db.TrnPurchaseOrders.OrderByDescending(d => d.Id) where d.BranchId == currentBranchId() select d;
if (lastPONumber.Any())
{
var PONumber = Convert.ToInt32(lastPONumber.FirstOrDefault().PONumber) + 0000000001;
PONumberResult = zeroFill(PONumber, 10);
}
Data.TrnPurchaseOrder newPurchaseOrder = new Data.TrnPurchaseOrder();
newPurchaseOrder.BranchId = currentBranchId();
newPurchaseOrder.PONumber = PONumberResult;
newPurchaseOrder.PODate = DateTime.Today;
newPurchaseOrder.SupplierId = (from d in db.MstArticles where d.ArticleTypeId == 3 select d.Id).FirstOrDefault();
newPurchaseOrder.TermId = (from d in db.MstTerms select d.Id).FirstOrDefault();
newPurchaseOrder.ManualRequestNumber = "NA";
newPurchaseOrder.ManualPONumber = "NA";
newPurchaseOrder.DateNeeded = DateTime.Today;
newPurchaseOrder.Remarks = "NA";
newPurchaseOrder.IsClose = false;
newPurchaseOrder.RequestedById = userId;
newPurchaseOrder.PreparedById = userId;
newPurchaseOrder.CheckedById = userId;
newPurchaseOrder.ApprovedById = userId;
newPurchaseOrder.IsLocked = false;
newPurchaseOrder.CreatedById = userId;
newPurchaseOrder.CreatedDateTime = DateTime.Now;
newPurchaseOrder.UpdatedById = userId;
newPurchaseOrder.UpdatedDateTime = DateTime.Now;
db.TrnPurchaseOrders.InsertOnSubmit(newPurchaseOrder);
db.SubmitChanges();
return(newPurchaseOrder.Id);
}
catch
{
return(0);
}
}
public HttpResponseMessage updatePurchaseOrder(String id, Models.TrnPurchaseOrder purchaseOrder)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
var purchaseOrders = from d in db.TrnPurchaseOrders where d.Id == Convert.ToInt32(id) select d;
if (purchaseOrders.Any())
{
var updatePurchaseOrder = purchaseOrders.FirstOrDefault();
updatePurchaseOrder.BranchId = purchaseOrder.BranchId;
updatePurchaseOrder.PONumber = purchaseOrder.PONumber;
updatePurchaseOrder.PODate = Convert.ToDateTime(purchaseOrder.PODate);
updatePurchaseOrder.SupplierId = purchaseOrder.SupplierId;
updatePurchaseOrder.TermId = purchaseOrder.TermId;
updatePurchaseOrder.ManualRequestNumber = purchaseOrder.ManualRequestNumber;
updatePurchaseOrder.ManualPONumber = purchaseOrder.ManualPONumber;
updatePurchaseOrder.DateNeeded = Convert.ToDateTime(purchaseOrder.DateNeeded);
updatePurchaseOrder.Remarks = purchaseOrder.Remarks;
updatePurchaseOrder.IsClose = purchaseOrder.IsClose;
updatePurchaseOrder.RequestedById = purchaseOrder.RequestedById;
updatePurchaseOrder.PreparedById = purchaseOrder.PreparedById;
updatePurchaseOrder.CheckedById = purchaseOrder.CheckedById;
updatePurchaseOrder.ApprovedById = purchaseOrder.ApprovedById;
updatePurchaseOrder.IsLocked = true;
updatePurchaseOrder.UpdatedById = userId;
updatePurchaseOrder.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
