public ActionResponse Delete(int year)
{
eisEntities ctx = new eisEntities();
ctx.ExecuteStoreCommand("DELETE FROM BankLoanApproval WHERE Year = {0}", year);
ctx.ExecuteStoreCommand("DELETE FROM BudgetUsage WHERE Year = {0}", year);
ctx.ExecuteStoreCommand("DELETE FROM EmployeeRelatedBudgetUsage WHERE Year = {0}", year);
ctx.ExecuteStoreCommand("DELETE FROM EstimatedFundMember WHERE Year = {0}", year);
ctx.ExecuteStoreCommand("DELETE FROM EstimatedRetirement WHERE Year = {0}", year);
ctx.ExecuteStoreCommand("DELETE FROM FirstCarStatus WHERE Year = {0}", year);
ctx.ExecuteStoreCommand("DELETE FROM NumberOfEmployee WHERE Year = {0}", year);
ctx.ExecuteStoreCommand("DELETE FROM RetirementFundUsage WHERE Year = {0}", year);
ctx.ExecuteStoreCommand("DELETE FROM WarrantFundProviding WHERE Year = {0}", year);
ctx.ExecuteStoreCommand("DELETE FROM AvailableYears WHERE Year = {0}", year);
return(new ActionResponse()
{
Success = true
});
}
public void Update([FromBody] EmployeeRelatedBudgetUsage model)
{
var ctx = new eisEntities();
ctx.ExecuteStoreCommand("UPDATE EmployeeRelatedBudgetUsage " +
" SET Amount = {0} " +
" ,LastUpdated = {1} " +
" WHERE Id = {2} ",
model.Amount,
DateTime.Now,
model.Id);
}
public void Update([FromBody] EstimatedFundMember model)
{
var ctx = new eisEntities();
ctx.ExecuteStoreCommand("UPDATE EstimatedFundMember " +
" SET EstimatedValue = {0} " +
" ,LastUpdated = {1} " +
" WHERE Id = {2} ",
model.EstimatedValue,
DateTime.Now,
model.Id);
}
public void Update([FromBody] FirstCarStatus model)
{
var ctx = new eisEntities();
ctx.ExecuteStoreCommand("UPDATE FirstCarStatus " +
" SET NumberOfPeople = {0} " +
" ,Amount = {1} " +
" ,LastUpdated = {2} " +
" WHERE Id = {3} ",
model.NumberOfPeople,
model.Amount,
DateTime.Now,
model.Id);
}
public void Update([FromBody] WarrantFundProviding model)
{
var ctx = new eisEntities();
ctx.ExecuteStoreCommand("UPDATE WarrantFundProviding " +
" SET NumberOfPeople = {0} " +
" ,Amount = {1} " +
" ,LastUpdated = {2} " +
" WHERE Id = {3} ",
model.NumberOfPeople,
model.Amount,
DateTime.Now,
model.Id);
}
public void Update([FromBody] RetirementFundUsage model)
{
var ctx = new eisEntities();
ctx.ExecuteStoreCommand("UPDATE RetirementFundUsage " +
" SET NumberOfPeople = {0} " +
" ,NumberOfUsage = {1} " +
" ,LastUpdated = {2} " +
" WHERE Id = {3} ",
model.NumberOfPeople,
model.NumberOfUsage,
DateTime.Now,
model.Id);
}
public void Update([FromBody] BudgetUsage model)
{
var ctx = new eisEntities();
ctx.ExecuteStoreCommand("UPDATE BudgetUsage " +
" SET BudgetAmount = {0} " +
" ,Used = {1} " +
" ,LastUpdated = {2} " +
" WHERE Id = {3} ",
model.BudgetAmount,
model.Used,
DateTime.Now,
model.Id);
}
public void Update([FromBody] NumberOfEmployee model)
{
var ctx = new eisEntities();
ctx.ExecuteStoreCommand("UPDATE NumberOfEmployee " +
" SET GovernmentOfficer = {0} " +
" ,PermanentContractor = {1} " +
" ,GeneralOfficer = {2} " +
" ,LastUpdated = {3} " +
" WHERE Id = {4} ",
model.GovernmentOfficer,
model.PermanentContractor,
model.GeneralOfficer,
DateTime.Now,
model.Id);
}