public HttpResponseMessage SaveStockOut(Entities.TrnStockOut objStockOut, 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 stockOut = from d in db.TrnStockOuts where d.Id == Convert.ToInt32(id) select d;
if (stockOut.Any())
{
if (!stockOut.FirstOrDefault().IsLocked)
{
String oldObject = at.GetObjectString(stockOut.FirstOrDefault());
var saveStockOut = stockOut.FirstOrDefault();
saveStockOut.OTDate = Convert.ToDateTime(objStockOut.OTDate);
saveStockOut.AccountId = objStockOut.AccountId;
saveStockOut.ArticleId = objStockOut.ArticleId;
saveStockOut.Particulars = objStockOut.Particulars;
saveStockOut.ManualOTNumber = objStockOut.ManualOTNumber;
saveStockOut.CheckedById = objStockOut.CheckedById;
saveStockOut.ApprovedById = objStockOut.ApprovedById;
saveStockOut.Status = objStockOut.Status;
saveStockOut.UpdatedById = currentUserId;
saveStockOut.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
String newObject = at.GetObjectString(stockOut.FirstOrDefault());
at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, oldObject, newObject);
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Saving Error. These stock out details are already locked."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These stock out details are not found in the server."));
}
}
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 putStockOut(String id, Entities.TrnStockOut stockOut)
{
try
{
var stockOuts = from d in db.TrnStockOuts where d.Id == Convert.ToInt32(id) select d;
if (stockOuts.Any())
{
var updateStockOut = stockOuts.FirstOrDefault();
updateStockOut.PeriodId = stockOut.PeriodId;
updateStockOut.StockOutDate = stockOut.StockOutDate;
updateStockOut.StockOutNumber = stockOut.StockOutNumber;
updateStockOut.AccountId = stockOut.AccountId;
updateStockOut.Remarks = stockOut.Remarks;
updateStockOut.PreparedBy = stockOut.PreparedBy;
updateStockOut.CheckedBy = stockOut.CheckedBy;
updateStockOut.ApprovedBy = stockOut.ApprovedBy;
updateStockOut.IsLocked = true;
updateStockOut.EntryUserId = UserId();
updateStockOut.EntryDateTime = DateTime.Today;
updateStockOut.UpdateUserId = UserId();
updateStockOut.UpdateDateTime = DateTime.Today;
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 LockStockOut(Entities.TrnStockOut objStockOut, 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("StockOutDetail")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanLock)
{
var stockOut = from d in db.TrnStockOuts
where d.Id == Convert.ToInt32(id)
select d;
if (stockOut.Any())
{
if (!stockOut.FirstOrDefault().IsLocked)
{
String oldObject = at.GetObjectString(stockOut.FirstOrDefault());
var lockStockOut = stockOut.FirstOrDefault();
lockStockOut.OTDate = Convert.ToDateTime(objStockOut.OTDate);
lockStockOut.AccountId = objStockOut.AccountId;
lockStockOut.ArticleId = objStockOut.ArticleId;
lockStockOut.Particulars = objStockOut.Particulars;
lockStockOut.ManualOTNumber = objStockOut.ManualOTNumber;
lockStockOut.CheckedById = objStockOut.CheckedById;
lockStockOut.ApprovedById = objStockOut.ApprovedById;
lockStockOut.Status = objStockOut.Status;
lockStockOut.IsLocked = true;
lockStockOut.UpdatedById = currentUserId;
lockStockOut.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
// =====================
// Journal and Inventory
// =====================
Business.Journal journal = new Business.Journal();
Business.Inventory inventory = new Business.Inventory();
if (lockStockOut.IsLocked)
{
journal.InsertStockOutJournal(Convert.ToInt32(id));
inventory.InsertStockOutInventory(Convert.ToInt32(id));
}
String newObject = at.GetObjectString(stockOut.FirstOrDefault());
at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, oldObject, newObject);
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Locking Error. These stock out details are already locked."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These stock out details are not found in the server."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to lock stock out."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this stock out 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."));
}
}
