public HttpResponseMessage putStockCount(String id, Entities.TrnStockCount stockCount)
{
try
{
var stockCounts = from d in db.TrnStockCounts where d.Id == Convert.ToInt32(id) select d;
if (stockCounts.Any())
{
var updateStockCount = stockCounts.FirstOrDefault();
updateStockCount.PeriodId = stockCount.PeriodId;
updateStockCount.StockCountDate = stockCount.StockCountDate;
updateStockCount.StockCountNumber = stockCount.StockCountNumber;
updateStockCount.Remarks = stockCount.Remarks;
updateStockCount.PreparedBy = stockCount.PreparedBy;
updateStockCount.CheckedBy = stockCount.CheckedBy;
updateStockCount.ApprovedBy = stockCount.ApprovedBy;
updateStockCount.IsLocked = -1;
updateStockCount.EntryUserId = UserId();
updateStockCount.EntryDateTime = DateTime.Today;
updateStockCount.UpdateUserId = UserId();
updateStockCount.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 SaveStockCount(Entities.TrnStockCount objStockCount, 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 stockCount = from d in db.TrnStockCounts where d.Id == Convert.ToInt32(id) select d;
if (stockCount.Any())
{
if (!stockCount.FirstOrDefault().IsLocked)
{
String oldObject = at.GetObjectString(stockCount.FirstOrDefault());
var saveStockCount = stockCount.FirstOrDefault();
saveStockCount.SCDate = Convert.ToDateTime(objStockCount.SCDate);
saveStockCount.Particulars = objStockCount.Particulars;
saveStockCount.CheckedById = objStockCount.CheckedById;
saveStockCount.ApprovedById = objStockCount.ApprovedById;
saveStockCount.Status = objStockCount.Status;
saveStockCount.UpdatedById = currentUserId;
saveStockCount.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
String newObject = at.GetObjectString(stockCount.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 count details are already locked."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These stock count 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 LockStockCount(Entities.TrnStockCount objStockCount, 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("StockCountDetail")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanLock)
{
var stockCount = from d in db.TrnStockCounts
where d.Id == Convert.ToInt32(id)
select d;
if (stockCount.Any())
{
if (!stockCount.FirstOrDefault().IsLocked)
{
var lockStockCount = stockCount.FirstOrDefault();
lockStockCount.SCDate = Convert.ToDateTime(objStockCount.SCDate);
lockStockCount.Particulars = objStockCount.Particulars;
lockStockCount.CheckedById = objStockCount.CheckedById;
lockStockCount.ApprovedById = objStockCount.ApprovedById;
lockStockCount.IsLocked = true;
lockStockCount.UpdatedById = currentUserId;
lockStockCount.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Locking Error. These stock count details are already locked."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These stock count details are not found in the server."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to lock stock count."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this stock count 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."));
}
}
