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.")); } }