public HttpResponseMessage updateBranch(String id, Models.MstBranch branch) { try { var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault(); var branches = from d in db.MstBranches where d.Id == Convert.ToInt32(id) select d; if (branches.Any()) { var updateBranch = branches.FirstOrDefault(); updateBranch.CompanyId = branch.CompanyId; updateBranch.Branch = branch.Branch; updateBranch.Address = branch.Address; updateBranch.ContactNumber = branch.ContactNumber; updateBranch.TaxNumber = branch.TaxNumber; updateBranch.IsLocked = true; updateBranch.UpdatedById = userId; updateBranch.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public Int32 insertBranch(Models.MstBranch branch) { try { var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault(); var codeDefault = "101"; var lastBranch = from d in db.MstBranches.OrderByDescending(d => d.Id) select d; if (lastBranch.Any()) { codeDefault = lastBranch.FirstOrDefault().BranchCode; var lastBranchByCompanyId = from d in db.MstBranches.OrderByDescending(d => d.Id) where d.CompanyId == branch.CompanyId select d; if (lastBranchByCompanyId.Any()) { codeDefault = lastBranchByCompanyId.FirstOrDefault().BranchCode; var CVNumber = Convert.ToInt32(lastBranchByCompanyId.FirstOrDefault().BranchCode) + 001; codeDefault = zeroFill(CVNumber, 3); } else { var branchCodeIncrement = Convert.ToInt32(lastBranch.FirstOrDefault().BranchCode) + 100; var branchCode = Math.Round(Convert.ToDouble(branchCodeIncrement) / 100, 0) * 100; var CVNumber = branchCode + 001; codeDefault = zeroFill(Convert.ToInt32(CVNumber), 3); } } Data.MstBranch newBranch = new Data.MstBranch(); newBranch.CompanyId = branch.CompanyId; newBranch.Branch = branch.Branch; newBranch.BranchCode = codeDefault; newBranch.Address = branch.Address; newBranch.ContactNumber = branch.ContactNumber; newBranch.TaxNumber = branch.TaxNumber; newBranch.IsLocked = true; newBranch.CreatedById = userId; newBranch.CreatedDateTime = DateTime.Now; newBranch.UpdatedById = userId; newBranch.UpdatedDateTime = DateTime.Now; db.MstBranches.InsertOnSubmit(newBranch); db.SubmitChanges(); return(newBranch.Id); } catch { return(0); } }