public HttpResponseMessage unlockCollection(String id, Models.TrnCollection collection) { try { var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault(); var collections = from d in db.TrnCollections where d.Id == Convert.ToInt32(id) select d; if (collections.Any()) { var updateCollection = collections.FirstOrDefault(); updateCollection.IsLocked = false; updateCollection.UpdatedById = userId; updateCollection.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); journal.DeleteOfficialReceiptJournal(Convert.ToInt32(id)); UpdateARCollection(Convert.ToInt32(id)); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public HttpResponseMessage updateCollection(String id, Models.TrnCollection collection) { try { var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault(); var collections = from d in db.TrnCollections where d.Id == Convert.ToInt32(id) select d; if (collections.Any()) { var updateCollection = collections.FirstOrDefault(); updateCollection.BranchId = collection.BranchId; updateCollection.ORNumber = collection.ORNumber; updateCollection.ORDate = Convert.ToDateTime(collection.ORDate); updateCollection.CustomerId = collection.CustomerId; updateCollection.Particulars = collection.Particulars; updateCollection.ManualORNumber = collection.ManualORNumber; updateCollection.PreparedById = collection.PreparedById; updateCollection.CheckedById = collection.CheckedById; updateCollection.ApprovedById = collection.ApprovedById; updateCollection.IsLocked = true; updateCollection.UpdatedById = userId; updateCollection.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); journal.InsertOfficialReceiptJournal(Convert.ToInt32(id)); UpdateARCollection(Convert.ToInt32(id)); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public Int32 insertCollection(Models.TrnCollection collection) { try { var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault(); var lastORNumber = from d in db.TrnCollections.OrderByDescending(d => d.Id) where d.BranchId == currentBranchId() select d; var ORNumberResult = "0000000001"; if (lastORNumber.Any()) { var ORNumber = Convert.ToInt32(lastORNumber.FirstOrDefault().ORNumber) + 0000000001; ORNumberResult = zeroFill(ORNumber, 10); } Data.TrnCollection newCollection = new Data.TrnCollection(); newCollection.BranchId = currentBranchId(); newCollection.ORNumber = ORNumberResult; newCollection.ORDate = DateTime.Today; newCollection.CustomerId = (from d in db.MstArticles where d.ArticleTypeId == 2 select d.Id).FirstOrDefault(); newCollection.Particulars = "NA"; newCollection.ManualORNumber = "NA"; newCollection.PreparedById = userId; newCollection.CheckedById = userId; newCollection.ApprovedById = userId; newCollection.IsLocked = false; newCollection.CreatedById = userId; newCollection.CreatedDateTime = DateTime.Now; newCollection.UpdatedById = userId; newCollection.UpdatedDateTime = DateTime.Now; db.TrnCollections.InsertOnSubmit(newCollection); db.SubmitChanges(); return(newCollection.Id); } catch { return(0); } }