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