public async Task <IActionResult> AddBudgetCode(BudgetCodeWithAmount bc)
{
if (!ModelState.IsValid)
{
return(View(bc));
}
var code = new BudgetCode()
{
BudgetCodeName = bc.BudgetCodeName,
DA = bc.DA,
Type = bc.Type,
BudgetAmounts = new List <BudgetAmount>
{
new BudgetAmount
{
TotalAmount = bc.TotalAmount
}
}
};
var codeResult = await _webApiCalls.CreateAsync(code);
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "ID,CodeType")] BudgetCode budgetCode)
{
try
{
if (ModelState.IsValid)
{
db.BudgetCodes.Add(budgetCode);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (RetryLimitExceededException)
{
ModelState.AddModelError("", "Unable to save changes after multiple attempts. Try again, and if the problem persists, see your system administrator.");
}
catch (DataException dex)
{
if (dex.InnerException.InnerException.Message.Contains("IX_"))
{
ModelState.AddModelError("", "Unable to save changes. The budget code must be unique.");
}
else
{
ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists contact your system administrator.");
}
}
return(View(budgetCode));
}
public ActionResult DeleteConfirmed(int id)
{
BudgetCode budgetCode = db.BudgetCodes.Find(id);
db.BudgetCodes.Remove(budgetCode);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public BudgetCodeEditDto(BudgetCode budgetCode)
{
Active = budgetCode.Active;
Code = budgetCode.Code;
Name = budgetCode.Name;
OrganizationNumber = budgetCode.OrganizationNumber;
ProjectNumber = budgetCode.ProjectNumber;
}
public BudgetCodeSummaryDto(BudgetCode budgetCode)
{
Id = budgetCode.Id;
Active = budgetCode.Active;
Code = budgetCode.Code;
Name = budgetCode.Name;
OrganizationNumber = budgetCode.OrganizationNumber;
ProjectNumber = budgetCode.ProjectNumber;
}
public IActionResult Create([FromBody] BudgetCode model)
{
if (model == null || !ModelState.IsValid)
{
return(BadRequest());
}
_repo.Add(model);
return(CreatedAtAction("Create", model));
}
public ActionResult Edit([Bind(Include = "ID,DA_CODE,BudgetCodeName,Type,Active,TimeStamp")] BudgetCode budgetCode)
{
if (ModelState.IsValid)
{
db.Entry(budgetCode).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(budgetCode));
}
public void CaseFour()
{
BudgetCode tempBudgetCode = _db.BudgetCodes.Where(x => x.DA == 731180007).ToList().First();
//tempBudgetCode.TotalAmount = 7000;
_db.BudgetCodes.Update(tempBudgetCode);
_db.SaveChanges();
//Assert.Equal(7000, _db.BudgetCodes.Where(x => x.DA == 731180007).ToList().First().TotalAmount);
}
public void Case04()
{
BudgetCode tempBudgetCode = (BudgetCode)_db.BudgetCodes.Where(x => x.DA == 731180007).ToList().First();
tempBudgetCode.Active = false;
_db.BudgetCodes.Update(tempBudgetCode);
_db.SaveChanges();
Assert.False(_db.BudgetCodes.Where(x => x.DA == 731180007).ToList().First().Active);
}
public IActionResult Update(int budgetCodeId, [FromBody] BudgetCode model)
{
if (model == null || budgetCodeId != model.Id || !ModelState.IsValid)
{
return(BadRequest());
}
_repo.Update(model);
return(CreatedAtAction("Update", model));
}
public void Case05()
{
BudgetCode tempBudgetCode = _db.BudgetCodes.Where(x => x.BudgetCodeName == "CS Budget").ToList().First();
// decimal CSBudget = _db.BudgetCodes.Where(x => x.BudgetCodeName == "CS Budget").ToList().First().TotalAmount;
// tempBudgetCode.TotalAmount += 2000;
_db.Update(tempBudgetCode);
_db.SaveChanges();
//Assert.Equal(CSBudget + 2000, _db.BudgetCodes.Where(x => x.BudgetCodeName == "CS Budget").ToList().First().TotalAmount);
}
public ActionResult Create([Bind(Include = "ID,DA_CODE,BudgetCodeName,Type,Active,TimeStamp")] BudgetCode budgetCode)
{
if (ModelState.IsValid)
{
db.BudgetCodes.Add(budgetCode);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(budgetCode));
}
public void Case03()
{
BudgetCode newBudget = new BudgetCode {
Type = true, BudgetCodeName = "BakeSale Budget", Active = true, DA = 731180007
};
_db.BudgetCodes.Add(newBudget);
_db.SaveChanges();
int id = _db.BudgetCodes.Where(x => x.BudgetCodeName == "BakeSale Budget").ToList().First().Id;
Assert.Equal("BakeSale Budget", _db.BudgetCodes.Find(id).BudgetCodeName);
}
public ActionResult CreateBudgetAndAmount(BudgetCode budgetCode, BudgetAmount budgetAmount)
{
if (ModelState.IsValid)
{
db.BudgetAmounts.Add(budgetAmount);
db.BudgetCodes.Add(budgetCode);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(budgetCode));
}
// GET: BudgetCodes/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BudgetCode budgetCode = db.BudgetCodes.Find(id);
if (budgetCode == null)
{
return(HttpNotFound());
}
return(View(budgetCode));
}
public void GiveEmployeeABudget()
{
Employee employee = _db.Employees.Where(x => x.FirstName == "Charles").ToList().First();
BudgetCode code = _db.BudgetCodes.Where(x => x.BudgetCodeName == "CS Budget").ToList().First();
string id = employee.Id;
employee.EmployeesBudgetCode = new List <EmployeesBudgetCodes> {
new EmployeesBudgetCodes
{
Employee = employee,
BudgetCode = code,
}
};
_db.SaveChanges();
Assert.Equal(id, _db.EmployeesBudgetCodes.Where(x => x.EmployeeId == id).ToList().First().EmployeeId);
}
public static BudgetCode CreateBudgetCode(string dataAreaId, string budgetCode1, global::Microsoft.Dynamics.DataEntities.BudgetRegisterEntryHeader budgetRegisterEntryHeaderBudgetCode, global::Microsoft.Dynamics.DataEntities.BudgetRegisterEntry budgetRegisterEntryBudgetCode)
{
BudgetCode budgetCode = new BudgetCode();
budgetCode.dataAreaId = dataAreaId;
budgetCode.BudgetCode1 = budgetCode1;
if ((budgetRegisterEntryHeaderBudgetCode == null))
{
throw new global::System.ArgumentNullException("budgetRegisterEntryHeaderBudgetCode");
}
budgetCode.BudgetRegisterEntryHeaderBudgetCode = budgetRegisterEntryHeaderBudgetCode;
if ((budgetRegisterEntryBudgetCode == null))
{
throw new global::System.ArgumentNullException("budgetRegisterEntryBudgetCode");
}
budgetCode.BudgetRegisterEntryBudgetCode = budgetRegisterEntryBudgetCode;
return(budgetCode);
}
public async Task <IActionResult> EditBudgetCode(BudgetCodeWithAmount code)
{
if (!ModelState.IsValid)
{
return(View(code));
}
var budget = new BudgetCode()
{
Id = code.Id,
Active = code.Active,
BudgetCodeName = code.BudgetCodeName,
DA = code.DA,
Type = code.Type,
TimeStamp = code.TimeStamp,
};
var result = await _webApiCalls.UpdateAsync(code.Id, budget);
return(RedirectToAction("Index"));
}
internal EmployeeBudgetCodeViewModel GetRecord(EmployeesBudgetCodes eb, Employee e, BudgetCode b)
=> new EmployeeBudgetCodeViewModel()
{
Id = eb.Id,
Active = eb.Active,
BudgetCodeId = b.Id,
EmployeeId = e.Id,
TimeStamp = eb.TimeStamp,
BudgetCodeName = b.BudgetCodeName,
EmployeeName = e.FullName
};
internal PRWithRequest GetRecord(Employee user, Employee supervisor, Status status, Category c, BudgetCode bc, Order o)
{
//BusinessJustification & DateOrdered && CategoryId && BudgetCodeId
var order = new PRWithRequest()
{
Id = o.Id,
BusinessJustification = o.BusinessJustification,
DateMade = o.DateMade,
DateOrdered = o.DateOrdered,
StateContract = o.StateContract,
StatusId = status.Id,
StatusName = status.StatusName,
};
var request = RequestRepo.GetAllForOrder(o.Id).ToList();
if (request.Count > 0)
{
order.RequestsWithVendor = request;
}
if (o.TimeStamp != null)
{
order.TimeStamp = o.TimeStamp;
}
if (user != null)
{
order.EmployeeFullName = user.FullName;
order.EmployeeId = user.Id;
}
if (supervisor != null)
{
order.SupervisorId = supervisor.Id;
order.SupervisorFullName = supervisor.FullName;
}
if (bc != null)
{
order.BudgetCodeId = bc.Id;
order.BudgetCodeName = bc.BudgetCodeName;
}
if (c != null)
{
order.CategoryId = c.Id;
order.CategoryName = c.CategoryName;
}
return(order);
}
