public override void ViewDidLoad()
{
base.ViewDidLoad();
referenceBD = Database.DefaultInstance.GetRootReference();
lstIngreso = new List <Ingreso>();
ConsultarIngresos();
IncomeTable.DataSource = this;
IncomeTable.ReloadData();
}
void ConsultarIngresos()
{
lstIngreso.Clear();
DatabaseReference incomes = referenceBD.GetChild("Ingresos");
nuint handleReference = incomes.ObserveEvent(DataEventType.Value, (snapshot) =>
{
var data = snapshot.GetValue <NSDictionary>();
var ingreso = new Ingreso
{
Monto = float.Parse(data["Monto"].ToString()),
Descripcion = data["Descripcion"].ToString(),
Fecha = DateTime.Parse(data["Fecha"].ToString())
};
lstIngreso.Add(ingreso);
IncomeTable.ReloadData();
});
}
public void RegisterDefaultAdmin(String secretCode)
{
if (secretCode.Equals("7617ed14946fe0c5005b301a30b15820e8a012db"))
{
XmlDocument doc = new XmlDocument();
//doc.Load("books.xml");
doc.Load(System.Web.Hosting.HostingEnvironment.MapPath("~/admin.xml"));
//Display all the book titles.
XmlNodeList nodes = doc.DocumentElement.SelectNodes("/admin");
foreach (XmlNode node in nodes)
{
string adminEmail = node.SelectSingleNode("email").InnerText;
string pass = node.SelectSingleNode("pass").InnerText;
var user = new ApplicationUser {
UserName = adminEmail, Email = adminEmail
};
var result = UserManager.Create(user, pass);
if (result.Succeeded)
{
// Create the Users Model
UserModel _userModel = new UserModel();
using (UserContext db = new UserContext())
{
Guid newGuid = Guid.Parse(user.Id);
/*
* Need to create the association between database
* Should create this on user registration which should be first form!
* NOTE! We are not creating the array'd objects yet as we need to still
* figure out how to handle them in the database
*/
_userModel.UserID = newGuid;
_userModel.Email = user.Email;
//_userModel.Birthday = new Date();
//_userModel.Birthday
_userModel.Birthday = DateTime.Now;
_userModel.BirthPlace = new BirthPlaceLocation();
_userModel.BirthPlace.UserID = newGuid;
_userModel.ConsideredRaceAndEthnicity = new RaceEthnicity();
_userModel.ConsideredRaceAndEthnicity.UserID = newGuid;
_userModel.HealthInfo = new Health();
_userModel.HealthInfo.UserID = newGuid;
_userModel.HealthInfo.SeriousInjuryOrSurgeryDate = DateTime.Now;
_userModel.SchoolInfo = new SchoolInfo();
_userModel.SchoolInfo.UserID = newGuid;
_userModel.LivesWith = new LivesWith();
_userModel.LivesWith.UserID = newGuid;
_userModel.MilitaryInfo = new MilitaryInfo();
_userModel.MailingAddress = new Address();
_userModel.MailingAddress.UserID = newGuid;
_userModel.Name = new Name();
_userModel.Name.UserID = newGuid;
_userModel.PhoneInfo = new Phone();
_userModel.PhoneInfo.UserID = newGuid;
_userModel.ResidentAddress = new Address();
_userModel.ResidentAddress.UserID = newGuid;
_userModel.Retainment = new Retained();
_userModel.Retainment.UserID = newGuid;
_userModel.StudentChildCare = new ChildCare();
_userModel.StudentChildCare.UserID = newGuid;
_userModel.StudentsParentingPlan = new ParentPlan();
_userModel.StudentsParentingPlan.UserID = newGuid;
_userModel.LastUpdateDate = DateTime.Now;
_userModel.role = new Roles();
_userModel.role.isAdmin = true;
// now add the form info
db.Users.Add(_userModel);
try
{
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
}
}
if (!CheckIfOpenHouseTableExists())
{
OpenHouse ohObj = new OpenHouse();
ohObj.OpenDays = "Every Tuesday at 5:30PM & Thursday at 11AM";
ohObj.WhatToBring = "A picture id as well as signed forms";
using (OpenHouseContext ohc = new OpenHouseContext())
{
ohc.OpenHouse.Add(ohObj);
try
{
ohc.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
}
}
if (!CheckIfIncomeTableExists())
{
//await SignInManager.SignInAsync(user, isPersistent: false, rememberBrowser: false);
string[] income1 = { "$ 0 to 1, 860", "$ 0 to 930", "$ 0 to 859", "$ 0 to 430", "$ 0 to 22,311" };
string[] income2 = { "$ 1,861 to 2,504", "$ 931 to 1,252", "$ 860 to 1,156", "$ 431 to 578", "$ 22,312 to 30,044" };
string[] income3 = { "$ 2,505 to 3,149", "$ 1,253 to 1,575", "$ 1,157 to 1,453", "$ 579 to 727", "$ 30,045 to 37,777" };
string[] income4 = { "$ 3,150 to 3,793", "$ 1,576 to 1,897", "$ 1,454 to 1,751", "$ 728 to 876", "$ 37,778 to 45,510" };
string[] income5 = { "$ 3,794 to 4,437", "$ 1,898 to 2,219", "$ 1,752 to 2,048", "$ 877 to 1,024", "$ 46,511 to 53,243" };
string[] income6 = { "$ 4,438 to 5,082", "$ 2,220 to 2,541", "$ 2,049 to 2,346", "$ 1,025 to 1,173", "$ 53,244 to 60,976" };
string[] income7 = { "$ 5,083 to 5,726", "$ 2,542 to 2,863", "$ 2,347 to 2,643", "$ 1,174 to 1,322", "$ 60,977 to 68,709" };
string[] income8 = { "$ 5,727 to 6,371", "$ 2,864 to 3,186", "$ 2,644 to 2,941", "$ 1,323 to 1,471", "$ 68,710 to 76,442" };
string[] income9 = { "$ 6,372 to 7,016", "$ 3, 187 to 3,509", "$ 2,942 to 3,239", "$ 1,472 to 1,620", "$ 76,443 to 84,175" };
string[] income10 = { "$ 7,107 to 7,661", "$ 3,510 to 3,832", "$ 3,240 to 3,537", "$ 1,621 to 1,769", "$ 84,176 to 91,908" };
string[] income11 = { "$ 7,662 to 8,306", "$ 3,833 to 4,155", "$ 3,538 to 3,835", "$ 1,770 to 1,918", "$ 91,909 to 99,641" };
string[] income12 = { "$ 8,307 to 8,951", "$ 4,156 to 4,478", "$ 3,836 to 4,133", "$ 1,919 to 2,067", "$ 99,642 to 107,374" };
string[] income13 = { "$ 8,952 to 9,596", "$ 4,479 to 4,801", "$ 4,134 to 4,431", "$ 2,068 to 2,216", "$ 107,375 to 115,107" };
string[] income14 = { "$ 9,597 to 10,241", "$ 4,802 to 5,124", "$ 4,432 to 4,729", "$ 2,217 to 2,365", "$ 115,108 to 122,840" };
string[] income15 = { "$ 10,242 to 10,886", "$ 5,125 to 5,447", "$ 4,730 to 5,027", "$ 2,366 to 2,514", "$ 122,841 to 130,573" };
using (var ic = new IncomeContext())
{
List <string[]> list = new List <string[]>();
list.Add(income1);
list.Add(income2);
list.Add(income3);
list.Add(income4);
list.Add(income5);
list.Add(income6);
list.Add(income7);
list.Add(income8);
list.Add(income9);
list.Add(income10);
list.Add(income11);
list.Add(income12);
list.Add(income13);
list.Add(income14);
list.Add(income15);
FamilyIncome income = new FamilyIncome();
income.incomeTable = new List <IncomeTable>();
income.id = 0;
income.EffectiveDates = "Income Chart Effective from July 1, 2017 through June 30, 2018";
income.IncomeTableYears = "2017-18 Family Income Survey";
for (int i = 0; i < list.Count; i++)
{
IncomeTable table = new IncomeTable();
table.Monthly = list[i][0];
table.TwiceMonthly = list[i][1];
table.TwoWeeks = list[i][2];
table.Weekly = list[i][3];
table.Annually = list[i][4];
income.incomeTable.Add(table);
}
ic.Income.Add(income);
try
{
ic.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
}
}
}
}
}
public void DrawDistributionTable()
{
HtmlTableRow tr;
HtmlTableCell td;
HtmlInputText txt;
var ds = FSDataServices.GetFSReportConfiguration();
int group_cd;
string row_name;
foreach (DataRow drConfig in ds.Tables[0].Rows)
{
//skip headers and totals rows
if ((int)drConfig["GROUP_CD"] != 0)
{
group_cd = (int)drConfig["GROUP_CD"];
row_name = (string)drConfig["Name"];
tr = new HtmlTableRow();
tr.AddReportRow();
tr.Cells.AddCell(row_name, "reportCaption");
var dr = IncomeTable.Select(String.Format("GROUP_CD={0} and BookMonth='{1}'", group_cd, BookMonth));
if (dr.Length > 0)
{
td = DisplayedMoneyCell((decimal)Utility.GetNotNullValue(dr[0]["Income"], "Decimal"), "reportTotal", "right");
}
else
{
td = DisplayedMoneyCell(0, "reportTotal", "right");
}
td.Attributes.Add("alt", group_cd.ToString());
tr.Cells.Add(td);
td = new HtmlTableCell();
txt = new HtmlInputText();
td.Controls.Add(txt);
txt.AddStyle("width:90px;height:15px;text-align:right");
if (!ReadOnly)
{
txt.AddOnMouseOut("extractNumber(this,0,false,0);");
txt.AddOnKeyUp("extractNumber(this,0,false,0);");
txt.AddKeyPressBlockNonNumbers();
}
else
{
txt.SetReadOnly();
}
dr = ProjectionTable.Select(String.Format("GROUP_CD={0} and BookMonth='{1}'", group_cd, BookMonth));
if (dr.Length > 0)
{
txt.Value = String.Format("{0:0}", (decimal)Utility.GetNotNullValue(dr[0]["Amount"], "Decimal"));
}
tr.Cells.Add(td);
tr.Cells.AddDisplayedMoneyCell(0, "reportTotal", "right");
ChartTable.Rows.Add(tr);
}
}
}
