public void ProcessRequest(HttpContext context)
{
string key = context.Request["key"];
eisEntities ctx = new eisEntities();
var users = from u in ctx.users
where u.SHA1 == key
select u;
var userList = users.ToList();
string response = "";
if (userList.Count > 0)
{
var user = userList[0];
string returnedKey = calculateSHA1(user.Password + user.SHA1);
response = "{\"success\":true, \"key\":\"" + returnedKey + "\"}";
}
else
{
response = "{\"success\":false, \"message\":\"รหัสผ่านไม่ถูกต้อง กรุณาลองอีกครั้ง\"}";
}
context.Response.ContentType = "application/json";
context.Response.Write(response);
}
// GET api/availableyear
public IEnumerable <AvailableYear> Get()
{
eisEntities ctx = new eisEntities();
var years = from year in ctx.AvailableYears1
select year;
return(years);
}
// GET api/fundmembertype
public IEnumerable <FundMemberType> Get()
{
eisEntities ctx = new eisEntities();
var types = from type in ctx.FundMemberTypes
select type;
return(types);
}
// GET api/firstcarstatustype
public IEnumerable <FirstCarStatusType> Get()
{
eisEntities ctx = new eisEntities();
var types = from type in ctx.FirstCarStatusTypes1
select type;
return(types);
}
// GET api/budgettype
public IEnumerable <BudgetType> Get()
{
eisEntities ctx = new eisEntities();
var types = from type in ctx.BudgetTypes1
select type;
return(types);
}
// GET api/retirementfundtype
public IEnumerable <RetirementFundType> Get()
{
eisEntities ctx = new eisEntities();
var types = from type in ctx.RetirementFundTypes1
select type;
return(types);
}
// GET api/warrantfund
public IEnumerable <WarrantFundProvider> Get()
{
eisEntities ctx = new eisEntities();
var providers = from provider in ctx.WarrantFundProviders
select provider;
return(providers);
}
// GET api/estimatedfundmember
public IEnumerable <EstimatedFundMember> Get(int year)
{
var ctx = new eisEntities();
var result = from record in ctx.EstimatedFundMembers1
where record.Year == year
select record;
return(result);
}
// GET api/bankloanapproval
public IEnumerable <BankLoanApproval> Get(int year)
{
eisEntities ctx = new eisEntities();
var result = from record in ctx.BankLoanApprovals1
where record.Year == year
select record;
return(result);
}
// GET api/numberofemployee/get
public IEnumerable <NumberOfEmployee> Get(int year)
{
var ctx = new eisEntities();
var result = from record in ctx.NumberOfEmployees1
where record.Year == year
select record;
return(result);
}
// GET api/employeerelatedbudgetusage
public IEnumerable <EmployeeRelatedBudgetUsage> Get(int year)
{
var ctx = new eisEntities();
var result = from record in ctx.EmployeeRelatedBudgetUsages1
where record.Year == year
select record;
return(result);
}
// GET api/retirementfundusage
public IEnumerable <RetirementFundUsage> Get(int year)
{
var ctx = new eisEntities();
var result = from record in ctx.RetirementFundUsages1
where record.Year == year
select record;
return(result);
}
// GET api/firstcarstatus
public IEnumerable <FirstCarStatus> Get(int year)
{
var ctx = new eisEntities();
var result = from record in ctx.FirstCarStatus
where record.Year == year
select record;
return(result);
}
// GET api/warrantfundproviding
public IEnumerable <WarrantFundProviding> Get(int year)
{
var ctx = new eisEntities();
var result = from record in ctx.WarrantFundProvidings1
where record.Year == year
select record;
return(result);
}
public void ProcessRequest(HttpContext context)
{
string yearString = context.Request["year"];
int year = -1;
if (yearString != null && int.TryParse(yearString, out year))
{
eisEntities ctx = new eisEntities();
var usages = from type in ctx.retirementfundusages
where type.Year == year
select type;
var usageList = usages.ToList();
List <string> xValues = new List <string>();
List <decimal> yValues = new List <decimal>();
DateTime lastUpdated = DateTime.MinValue;
foreach (var usage in usageList)
{
xValues.Add(usage.retirementfundtype.TypeName);
yValues.Add(usage.NumberOfUsage);
if (usage.LastUpdated > lastUpdated)
{
lastUpdated = usage.LastUpdated;
}
}
ColumnChart chart = new ColumnChart(xValues.ToArray());
chart.SetLastUpdated(lastUpdated);
chart.AddSeries("หน่วย (ล้านบาท) (คน)", SeriesChartType.Bar, yValues.ToArray());
Series series = chart.GetSeries("หน่วย (ล้านบาท) (คน)");
int runner = 0;
foreach (var usage in usageList)
{
series.Points[runner].Label = "(#VALY{N0}) (" + usage.NumberOfPeople.ToString("N0") + ")";
runner++;
}
Axis xAxis = chart.GetXAxis();
xAxis.Interval = 1;
byte[] dataArray = chart.Render();
string filename = "image.png";
context.Response.ContentType = "image/png";
context.Response.AddHeader("Content-Disposition", "attachment; filename=\"" + filename + "\"");
context.Response.OutputStream.Write(dataArray, 0, dataArray.Length);
}
else
{
context.Response.ContentType = "text/plain";
context.Response.Write("Error: Year was not specified");
}
}
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 ProcessRequest(HttpContext context)
{
string yearString = context.Request["year"];
int year = -1;
if (yearString != null && int.TryParse(yearString, out year))
{
eisEntities ctx = new eisEntities();
var types = from type in ctx.numberofemployees
where type.Year == year
select type;
int sum1 = 0;
int sum2 = 0;
int sum3 = 0;
DateTime lastUpdated = DateTime.MinValue;
foreach (var type in types)
{
sum1 += type.GovernmentOfficer;
sum2 += type.PermanentContractor;
sum3 += type.GeneralOfficer;
if (type.LastUpdated > lastUpdated)
{
lastUpdated = type.LastUpdated;
}
}
string[] xVal = { "ข้าราชการ", "ลูกจ้างประจำ", "พนักงานราชการ" };
double[] yVal = { sum1, sum2, sum3 };
ColumnChart chart = new ColumnChart(xVal);
chart.AddSeries("จำนวนอัตรา", yVal);
chart.GetChartArea().Area3DStyle.Enable3D = true;
chart.GetChartArea().Area3DStyle.PointDepth = 30;
chart.GetChartArea().Area3DStyle.IsRightAngleAxes = true;
chart.GetChartArea().Area3DStyle.Rotation = 20;
chart.GetChartArea().Area3DStyle.Inclination = 20;
chart.GetSeries("จำนวนอัตรา")["DrawingStyle"] = "Cylinder";
chart.SetLastUpdated(lastUpdated);
chart.SetSummary("*ไม่มีข้อมูลพนักงานราชการ", Color.Red);
byte[] dataArray = chart.Render();
string filename = "image.png";
context.Response.ContentType = "image/png";
context.Response.AddHeader("Content-Disposition", "attachment; filename=\"" + filename + "\"");
context.Response.OutputStream.Write(dataArray, 0, dataArray.Length);
}
else
{
context.Response.ContentType = "text/plain";
context.Response.Write("Error: Year was not specified");
}
}
public void ProcessRequest(HttpContext context)
{
string yearString = context.Request["year"];
int year = -1;
if (yearString != null && int.TryParse(yearString, out year))
{
eisEntities ctx = new eisEntities();
var providings = from type in ctx.warrantfundprovidings
where type.Year == year
select type;
var providingList = providings.ToList();
List <string> xValues = new List <string>();
List <decimal> yValues = new List <decimal>();
DateTime lastUpdated = DateTime.MinValue;
decimal sum = 0;
foreach (var providing in providingList)
{
xValues.Add(providing.warrantfundprovider.ProviderName);
yValues.Add(providing.Amount);
sum += providing.Amount;
if (providing.LastUpdated > lastUpdated)
{
lastUpdated = providing.LastUpdated;
}
}
ColumnChart chart = new ColumnChart(xValues.ToArray());
chart.SetLastUpdated(lastUpdated);
chart.SetSummary("รวม " + sum.ToString("#,##0") + " ล้านบาท");
chart.AddSeries("จำนวนเงิน (ล้านบาท)", yValues.ToArray());
chart.GetChartArea().Area3DStyle.Enable3D = true;
chart.GetChartArea().Area3DStyle.PointDepth = 30;
chart.GetChartArea().Area3DStyle.IsRightAngleAxes = true;
chart.GetChartArea().Area3DStyle.Rotation = 20;
chart.GetChartArea().Area3DStyle.Inclination = 20;
chart.GetSeries("จำนวนเงิน (ล้านบาท)")["DrawingStyle"] = "Cylinder";
Series series = chart.GetSeries("จำนวนเงิน (ล้านบาท)");
series.Color = ColorPalette.GetColor(1);
byte[] dataArray = chart.Render();
context.Response.ContentType = "image/png";
context.Response.OutputStream.Write(dataArray, 0, dataArray.Length);
}
else
{
context.Response.ContentType = "text/plain";
context.Response.Write("Error: Year was not specified");
}
}
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] 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] 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] 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 ProcessRequest(HttpContext context)
{
string yearString = context.Request["year"];
int year = -1;
if (yearString != null && int.TryParse(yearString, out year))
{
eisEntities ctx = new eisEntities();
var types = from type in ctx.estimatedfundmembers
where type.Year == year
select type;
var typeList = types.ToList();
List <string> yValues = new List <string>();
List <int> xValues = new List <int>();
DateTime lastUpdated = DateTime.MinValue;
foreach (var type in typeList)
{
yValues.Add(type.fundmembertype.TypeName);
xValues.Add(type.EstimatedValue);
if (type.LastUpdated > lastUpdated)
{
lastUpdated = type.LastUpdated;
}
}
ColumnChart chart = new ColumnChart(yValues.ToArray());
chart.SetLastUpdated(lastUpdated);
chart.AddSeries("จำนวนคน", xValues.ToArray());
chart.GetChartArea().Area3DStyle.Enable3D = true;
chart.GetChartArea().Area3DStyle.PointDepth = 30;
chart.GetChartArea().Area3DStyle.IsRightAngleAxes = true;
chart.GetChartArea().Area3DStyle.Rotation = 20;
chart.GetChartArea().Area3DStyle.Inclination = 20;
chart.GetSeries("จำนวนคน")["DrawingStyle"] = "Cylinder";
byte[] dataArray = chart.Render();
string filename = "image.png";
context.Response.ContentType = "image/png";
context.Response.AddHeader("Content-Disposition", "attachment; filename=\"" + filename + "\"");
context.Response.OutputStream.Write(dataArray, 0, dataArray.Length);
}
else
{
context.Response.ContentType = "text/plain";
context.Response.Write("Error: Year was not specified");
}
}
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);
}
public void ProcessRequest(HttpContext context)
{
string yearString = context.Request["year"];
int year = -1;
if (yearString != null && int.TryParse(yearString, out year))
{
eisEntities ctx = new eisEntities();
var statuses = from type in ctx.firstcarstatus
where type.Year == year
select type;
var statusList = statuses.ToList();
List <string> xValues = new List <string>();
List <decimal> yValues = new List <decimal>();
DateTime lastUpdated = DateTime.MinValue;
foreach (var status in statusList)
{
xValues.Add(status.firstcarstatustype.StatusName + " (คน)");
yValues.Add(status.NumberOfPeople);
if (status.LastUpdated > lastUpdated)
{
lastUpdated = status.LastUpdated;
}
}
PieChart chart = new PieChart(xValues.ToArray());
chart.SetLastUpdated(lastUpdated);
chart.AddSeries("จำนวนคน", yValues.ToArray());
byte[] dataArray = chart.Render();
string filename = "image.png";
context.Response.ContentType = "image/png";
context.Response.AddHeader("Content-Disposition", "attachment; filename=\"" + filename + "\"");
context.Response.OutputStream.Write(dataArray, 0, dataArray.Length);
}
else
{
context.Response.ContentType = "text/plain";
context.Response.Write("Error: Year was not specified");
}
}
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 ProcessRequest(HttpContext context)
{
string yearString = context.Request["year"];
int year = -1;
if (yearString != null && int.TryParse(yearString, out year))
{
int firstYear = year - 4;
List <string> xVal = new List <string>();
for (int i = firstYear; i <= year; i++)
{
int actualYear = ((i - 2500) % 100);
xVal.Add(actualYear.ToString());
}
eisEntities ctx = new eisEntities();
var usages = from type in ctx.estimatedfundmembers
where type.Year >= firstYear && type.Year <= year
select type;
var usageList = usages.ToList();
var memberTypes = from type in ctx.fundmembertypes
select type.TypeName;
Dictionary <string, Dictionary <string, decimal> > dataTable = new Dictionary <string, Dictionary <string, decimal> >();
Dictionary <string, Dictionary <string, decimal> > dataTable2 = new Dictionary <string, Dictionary <string, decimal> >();
DateTime lastUpdated = DateTime.MinValue;
decimal maximumValue = 0;
foreach (var usage in usageList)
{
string typeName = usage.fundmembertype.TypeName;
string shortYear = ((usage.Year - 2500) % 100).ToString();
if (!dataTable.ContainsKey(typeName))
{
dataTable[typeName] = new Dictionary <string, decimal>();
dataTable2[typeName] = new Dictionary <string, decimal>();
}
dataTable[typeName][shortYear] = usage.EstimatedValue;
maximumValue = Math.Max(maximumValue, usage.EstimatedValue);
if (usage.LastUpdated > lastUpdated)
{
lastUpdated = usage.LastUpdated;
}
}
ColumnChart chart = new ColumnChart(xVal.ToArray(), memberTypes.Count());
chart.SetLastUpdated(lastUpdated);
chart.AddLeftAnnotation("จำนวนคน", 2, 15);
chart.SetAxisFont(new Font("Circular", 16, FontStyle.Bold));
chart.GetLegendBox().Enabled = false;
int runner = 0;
foreach (var type in memberTypes)
{
List <decimal> s1y = new List <decimal>();
Dictionary <string, decimal> dataList = dataTable[type];
foreach (string x in xVal)
{
s1y.Add(dataList[x]);
}
chart.AddSeries(type, "" + runner, SeriesChartType.StackedColumn, xVal.ToArray(), s1y.ToArray());
chart.GetSeries(type).IsValueShownAsLabel = false;
chart.GetSeries(type).IsVisibleInLegend = false;
chart.GetSeries(type).Color = ColorPalette.GetColor(0);
chart.GetChartArea("" + runner).AxisY.Maximum = (double)maximumValue;
chart.GetChartArea("" + runner).AxisY.MajorTickMark.Enabled = false;
chart.GetChartArea("" + runner).AxisY.LabelStyle.Enabled = true;
chart.GetChartArea("" + runner).AxisX.CustomLabels.Add(0, 6, type, 1, LabelMarkStyle.LineSideMark);
runner++;
}
byte[] dataArray = chart.Render();
context.Response.ContentType = "image/png";
context.Response.OutputStream.Write(dataArray, 0, dataArray.Length);
}
else
{
context.Response.ContentType = "text/plain";
context.Response.Write("Error: Year was not specified");
}
}
public void ProcessRequest(HttpContext context)
{
string yearString = context.Request["year"];
int year = -1;
if (yearString != null && int.TryParse(yearString, out year))
{
int firstYear = year - 4;
eisEntities ctx = new eisEntities();
var types = from type in ctx.numberofemployees
where type.Year >= firstYear && type.Year <= year
select type;
var empTypes = from empType in ctx.employeetypes
select empType.TypeName;
List <string> xVal = new List <string>();
for (int i = firstYear; i <= year; i++)
{
int actualYear = ((i - 2500) % 100);
xVal.Add(actualYear.ToString());
}
Dictionary <string, decimal> dataTable1 = new Dictionary <string, decimal>();
Dictionary <string, decimal> dataTable2 = new Dictionary <string, decimal>();
Dictionary <string, decimal> dataTable3 = new Dictionary <string, decimal>();
DateTime lastUpdated = DateTime.MinValue;
decimal maximumValue = 0;
foreach (var type in types)
{
string shortYear = ((type.Year - 2500) % 100).ToString();
if (!dataTable1.ContainsKey(shortYear))
{
dataTable1[shortYear] = 0;
dataTable2[shortYear] = 0;
dataTable3[shortYear] = 0;
}
dataTable1[shortYear] += type.GovernmentOfficer;
dataTable2[shortYear] += type.PermanentContractor;
dataTable3[shortYear] += type.GeneralOfficer;
if (type.LastUpdated > lastUpdated)
{
lastUpdated = type.LastUpdated;
}
maximumValue = Math.Max(maximumValue, dataTable1[shortYear]);
maximumValue = Math.Max(maximumValue, dataTable2[shortYear]);
maximumValue = Math.Max(maximumValue, dataTable3[shortYear]);
}
//Series1
List <string> s1x = new List <string>();
List <decimal> s1y = new List <decimal>();
for (int i = 0; i < 5; i++)
{
s1x.Add(xVal[i]);
s1y.Add(dataTable1[xVal[i]]);
}
//Series2
List <string> s2x = new List <string>();
List <decimal> s2y = new List <decimal>();
for (int i = 0; i < 5; i++)
{
s2x.Add(xVal[i]);
s2y.Add(dataTable2[xVal[i]]);
}
//Series3
List <string> s3x = new List <string>();
List <decimal> s3y = new List <decimal>();
for (int i = 0; i < 5; i++)
{
s3x.Add(xVal[i]);
s3y.Add(dataTable3[xVal[i]]);
}
ColumnChart chart = new ColumnChart(xVal, 3, 1, 75);
chart.SetLastUpdated(lastUpdated);
chart.SetSummary("*ไม่มีข้อมูลพนักงานราชการ", Color.Red);
chart.AddLeftAnnotation("จำนวนคน ", 82, 15);
chart.SetAxisFont(new Font("Circular", 16, FontStyle.Bold));
chart.AddSeries("0", "0", SeriesChartType.Column, s1x.ToArray(), s1y.ToArray());
chart.AddSeries("1", "1", SeriesChartType.Column, s2x.ToArray(), s2y.ToArray());
chart.AddSeries("2", "2", SeriesChartType.Column, s3x.ToArray(), s3y.ToArray());
chart.GetSeries("0").Color = ColorPalette.GetColor(0);
chart.GetSeries("1").Color = ColorPalette.GetColor(0);
chart.GetSeries("2").Color = ColorPalette.GetColor(0);
chart.GetSeries("0").Points[4].Color = ColorPalette.GetColor(1);
chart.GetSeries("1").Points[4].Color = ColorPalette.GetColor(1);
chart.GetSeries("2").Points[4].Color = ColorPalette.GetColor(1);
for (int i = 0; i < 3; i++)
{
chart.GetSeries("" + i).SmartLabelStyle.Enabled = false;
chart.GetSeries("" + i).LabelAngle = -90;
chart.GetSeries("" + i).SmartLabelStyle.MaxMovingDistance = 100;
chart.GetSeries("" + i).SmartLabelStyle.MovingDirection = LabelAlignmentStyles.Top;
chart.GetSeries("" + i).SetCustomProperty("RenderType", "Cylinder");
}
chart.GetChartArea("0").AxisY.LabelStyle.Enabled = false;
chart.GetChartArea("0").AxisY.MajorTickMark.Enabled = false;
chart.GetChartArea("1").AxisY.LabelStyle.Enabled = false;
chart.GetChartArea("1").AxisY.MajorTickMark.Enabled = false;
chart.GetChartArea("2").AxisY.LabelStyle.Enabled = false;
chart.GetChartArea("2").AxisY.MajorTickMark.Enabled = false;
chart.GetChartArea("0").AxisY.Maximum = (double)maximumValue;
chart.GetChartArea("1").AxisY.Maximum = (double)maximumValue;
chart.GetChartArea("2").AxisY.Maximum = (double)maximumValue;
chart.GetChartArea("0").AxisX.CustomLabels.Add(0, 6, "ข้าราชการ", 1, LabelMarkStyle.LineSideMark);
chart.GetChartArea("1").AxisX.CustomLabels.Add(0, 6, "ลูกจ้างประจำ", 1, LabelMarkStyle.LineSideMark);
chart.GetChartArea("2").AxisX.CustomLabels.Add(0, 6, "พนักงานราชการ", 1, LabelMarkStyle.LineSideMark);
chart.GetLegendBox().Enabled = false;
byte[] dataArray = chart.Render();
context.Response.ContentType = "image/png";
context.Response.OutputStream.Write(dataArray, 0, dataArray.Length);
}
else
{
context.Response.ContentType = "text/plain";
context.Response.Write("Error: Year was not specified");
}
}
public ActionResponse Create(int year)
{
eisEntities ctx = new eisEntities();
//Add available year
var newAvailableYear = ctx.AvailableYears1.CreateObject();
newAvailableYear.Year = year;
newAvailableYear.CreatedDate = DateTime.Now;
ctx.AvailableYears1.AddObject(newAvailableYear);
//Warrant Fund Provider
var warrantFundProviders = from provider in ctx.WarrantFundProviders select provider;
foreach (var p in warrantFundProviders)
{
var providing = ctx.WarrantFundProvidings1.CreateObject();
providing.Year = year;
providing.WarrantFundProviderId = p.WarrantFundProviderId;
providing.LastUpdated = DateTime.Now;
ctx.WarrantFundProvidings1.AddObject(providing);
}
//RetirementFundUsage
var retirementFundType = from type in ctx.RetirementFundTypes1 select type;
foreach (var rft in retirementFundType)
{
var fundUsage = ctx.RetirementFundUsages1.CreateObject();
fundUsage.Year = year;
fundUsage.RetirementFundTypeId = rft.RetirementFundTypeId;
fundUsage.LastUpdated = DateTime.Now;
ctx.RetirementFundUsages1.AddObject(fundUsage);
}
//EmployeeRelatedBudgetUsage
var empBudgetTypes = from type in ctx.EmployeeRelatedBudgetTypes1 select type;
foreach (var type in empBudgetTypes)
{
var empBudgetUsage = ctx.EmployeeRelatedBudgetUsages1.CreateObject();
empBudgetUsage.Year = year;
empBudgetUsage.EmployeeRelatedBudgetTypeId = type.EmployeeRelatedBudgetTypeId;
empBudgetUsage.LastUpdated = DateTime.Now;
ctx.EmployeeRelatedBudgetUsages1.AddObject(empBudgetUsage);
}
//EstimatedRetirement
var retirementType = from type in ctx.RetirementTypes1 select type;
foreach (var type in retirementType)
{
var est = ctx.EstimatedRetirements1.CreateObject();
est.Year = year;
est.RetirementTypeId = type.RetirementTypeId;
est.LastUpdated = DateTime.Now;
ctx.EstimatedRetirements1.AddObject(est);
}
//NumberOfEmployee
var empType = from type in ctx.EmployeeTypes1 select type;
foreach (var type in empType)
{
var noEmp = ctx.NumberOfEmployees1.CreateObject();
noEmp.Year = year;
noEmp.EmployeeTypeId = type.EmployeeTypeId;
noEmp.LastUpdated = DateTime.Now;
ctx.NumberOfEmployees1.AddObject(noEmp);
}
//BudgetUsage
var budgetType = from type in ctx.BudgetTypes1 select type;
foreach (var type in budgetType)
{
var usage = ctx.BudgetUsages1.CreateObject();
usage.Year = year;
usage.BudgetTypeId = type.BudgetTypeId;
usage.LastUpdated = DateTime.Now;
ctx.BudgetUsages1.AddObject(usage);
}
//EstimatedFundmember
var memberType = from type in ctx.FundMemberTypes select type;
foreach (var type in memberType)
{
var est = ctx.EstimatedFundMembers1.CreateObject();
est.Year = year;
est.FundMemberTypeId = type.FundMemberTypeId;
est.LastUpdated = DateTime.Now;
ctx.EstimatedFundMembers1.AddObject(est);
}
//FirstCarStatus
var firstCarStatusTypes = from type in ctx.FirstCarStatusTypes1 select type;
foreach (var type in firstCarStatusTypes)
{
var status = ctx.FirstCarStatus.CreateObject();
status.Year = year;
status.StatusTypeId = type.FirstCarStatusTypeId;
status.LastUpdated = DateTime.Now;
ctx.FirstCarStatus.AddObject(status);
}
//BankLoadApproval
var bankType = from type in ctx.BankTypes1 select type;
foreach (var bank in bankType)
{
var approval = ctx.BankLoanApprovals1.CreateObject();
approval.Year = year;
approval.BankTypeId = bank.BankTypeId;
approval.LastUpdated = DateTime.Now;
ctx.BankLoanApprovals1.AddObject(approval);
}
try {
ctx.SaveChanges();
return(new ActionResponse()
{
Success = true
});
}
catch (Exception ex) {
return(new ActionResponse()
{
Success = false,
Message = ex.Message
});
}
}
