public HttpResponseMessage SaveStockTransfer(Entities.TrnStockTransfer objStockTransfer, 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 stockTransfer = from d in db.TrnStockTransfers where d.Id == Convert.ToInt32(id) select d;
if (stockTransfer.Any())
{
if (!stockTransfer.FirstOrDefault().IsLocked)
{
String oldObject = at.GetObjectString(stockTransfer.FirstOrDefault());
var saveStockTransfer = stockTransfer.FirstOrDefault();
saveStockTransfer.STDate = Convert.ToDateTime(objStockTransfer.STDate);
saveStockTransfer.ToBranchId = objStockTransfer.ToBranchId;
saveStockTransfer.ArticleId = objStockTransfer.ArticleId;
saveStockTransfer.Particulars = objStockTransfer.Particulars;
saveStockTransfer.ManualSTNumber = objStockTransfer.ManualSTNumber;
saveStockTransfer.CheckedById = objStockTransfer.CheckedById;
saveStockTransfer.ApprovedById = objStockTransfer.ApprovedById;
saveStockTransfer.Status = objStockTransfer.Status;
saveStockTransfer.UpdatedById = currentUserId;
saveStockTransfer.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
String newObject = at.GetObjectString(stockTransfer.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 transfer details are already locked."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These stock transfer 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 LockStockTransfer(Entities.TrnStockTransfer objStockTransfer, 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("StockTransferDetail")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanLock)
{
var stockTransfer = from d in db.TrnStockTransfers
where d.Id == Convert.ToInt32(id)
select d;
if (stockTransfer.Any())
{
if (!stockTransfer.FirstOrDefault().IsLocked)
{
String oldObject = at.GetObjectString(stockTransfer.FirstOrDefault());
var lockStockTransfer = stockTransfer.FirstOrDefault();
lockStockTransfer.STDate = Convert.ToDateTime(objStockTransfer.STDate);
lockStockTransfer.ToBranchId = objStockTransfer.ToBranchId;
lockStockTransfer.ArticleId = objStockTransfer.ArticleId;
lockStockTransfer.Particulars = objStockTransfer.Particulars;
lockStockTransfer.ManualSTNumber = objStockTransfer.ManualSTNumber;
lockStockTransfer.CheckedById = objStockTransfer.CheckedById;
lockStockTransfer.ApprovedById = objStockTransfer.ApprovedById;
lockStockTransfer.Status = objStockTransfer.Status;
lockStockTransfer.IsLocked = true;
lockStockTransfer.UpdatedById = currentUserId;
lockStockTransfer.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
// =====================
// Journal and Inventory
// =====================
Business.Journal journal = new Business.Journal();
Business.Inventory inventory = new Business.Inventory();
if (lockStockTransfer.IsLocked)
{
journal.InsertStockTransferJournal(Convert.ToInt32(id));
inventory.InsertStockTransferInventory(Convert.ToInt32(id));
}
String newObject = at.GetObjectString(stockTransfer.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 transfer details are already locked."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These stock transfer details are not found in the server."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to lock stock transfer."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this stock transfer 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."));
}
}
