public void InitValues()
{
using (var eb = new EBarangayEntities())
{
captainTxt.Text = eb.Officials.FirstOrDefault(x => x.Position == "Punong Barangay").Name;
var sb = from sbmemb in eb.Officials
where sbmemb.Position == "Sangguniang Barangay Member"
select sbmemb;
LoadSB(sb.ToList(), sbTxt0, sbTxt1, sbTxt2, sbTxt3, sbTxt4, sbTxt5, sbTxt6);
secTxt.Text = eb.Officials.FirstOrDefault(o => o.Position == "Barangay Secretary").Name;
treasTxt.Text = eb.Officials.FirstOrDefault(o => o.Position == "Barangay Treasurer").Name;
PopulationTxt.Text = eb.Citizens.Count().ToString();
var area = eb.Areas;
areaList.Items.Clear();
foreach (var a in area)
{
string s = a.Name;
areaList.Items.Add(s);
}
}
}
public EditOfficials()
{
InitializeComponent();
using (var eb = new EBarangayEntities())
{
officialsMarker[0].Id = eb.Officials.FirstOrDefault(x => x.Position == "Punong_Barangay").ID;
pbText.Text = eb.Officials.FirstOrDefault(x => x.Position == "Punong_Barangay").Name;
var sbs = eb.Officials.Where(x => x.Position == "Sangguniang Barangay Member").OrderBy(x => x.ID).ToArray();
LoadSB(eb.Officials.Where(x => x.Position == "Sangguniang Barangay Member").OrderBy(x => x.ID).ToArray(),
sbText1, sbText2, sbText3, sbText4, sbText5, sbText6, sbText7);
for (int i = 1; i < officialsMarker.Length - 2; i++)
{
officialsMarker[i].Id = sbs[i - 1].ID;
}
var sec = eb.Officials.FirstOrDefault(x => x.Position == "Barangay_Secretary");
officialsMarker[8].Id = sec.ID;
secText.Text = sec.Name;
var tres = eb.Officials.FirstOrDefault(x => x.Position == "Barangay_Treasurer");
officialsMarker[9].Id = tres.ID;
tresText.Text = tres.Name;
}
for (int i = 0; i < officialsMarker.Length; i++)
{
officialsMarker[i].save = false;
}
}
private void YesOrNo_onBtnClick(object sender, bool e)
{
this.Enabled = true;
Form f = (Form)sender;
//this.Close();
if (e)
{
using (var eb = new EBarangayEntities())
{
var c = eb.Citizens.FirstOrDefault(x => x.IdNumber == IDTxt.Text);
//foreach (var rec in c.Records.ToArray())
// eb.Records.Remove(rec);
var instances = eb.CitizenToComplaints.Where(x => x.Citizen.IdNumber == IDTxt.Text);
foreach (var i in instances)
{
eb.CitizenToComplaints.Remove(i);
}
eb.Citizens.Remove(c);
eb.SaveChanges();
f.Close();
MessageBox.Show("successfully deleted Entry with id(" + IDTxt.Text + ")");
OnRecordDeleted?.Invoke(this, new EventArgs());
this.Close();
}
}
///throw new NotImplementedException();
}
private void Id_Leave(object sender, EventArgs e)
{
TextBox t = sender as TextBox;
//if (string.IsNullOrEmpty(t.Text))
// return;
//if (t.TextLength > t.MaxLength)
//{
// t.Text = t.Text.Remove(t.MaxLength);
// return;
//}
//t.Text = t.Text.Replace(" ", "");
//t.Text = t.Text.PadLeft(t.MaxLength, '0');
using (var eb = new EBarangayEntities())
{
if (eb.Citizens.Where(x => x.IdNumber != citizen.IdNumber).Any(x => x.IdNumber == t.Text))
{
MessageBox.Show("Id already taken.");
t.Text = citizen.IdNumber;
ActiveControl = t;
t.SelectAll();
}
}
}
void connectComplaintToCitizen(Complaint comp, DataGridView dgv)
{
using (var ent = new EBarangayEntities())
{
for (int i = 0; i < dgv.RowCount; i++)
{
if (dgv.Rows[i].Cells[0].Value != null)
{
string id = dgv.Rows[i].Cells[1].Value.ToString();
Citizen c = ent.Citizens.FirstOrDefault(x => x.IdNumber == id);
if (c != null)
{
//c.RefRecords += (string.IsNullOrEmpty(c.RefRecords)) ? controlNumber : "," + controlNumber;
CitizenToComplaint cc = new CitizenToComplaint();
//cc.Id = 1;
cc.ComplaintId = comp.ID;
cc.Citizen = c;
ent.CitizenToComplaints.Add(cc);
}
}
}
ent.SaveChanges();
}
}
private void AdvancedSearchForm_Load(object sender, EventArgs e)
{
using (var eb = new EBarangayEntities())
{
var areas = eb.Areas.ToArray();
foreach (var a in areas)
{
areaOptions.Items.Add(a.Name);
}
}
var gender = new string[] { "Male", "Female" };
foreach (var a in gender)
{
sexOption.Items.Add(a);
}
var cStatus = new string[] { "Single", "Married", "Separated", "Widow" };
foreach (var a in cStatus)
{
civilStatusOption.Items.Add(a);
}
using (var eb = new EBarangayEntities())
PopulateTable(eb.Citizens.ToArray());
}
private void Onsave_Callback(object sender, EventArgs e)
{
using (var eb = new EBarangayEntities())
{
PopulateTable(eb.Citizens.ToArray());
}
//throw new NotImplementedException();
}
public void LoadValues()
{
using (var ent = new EBarangayEntities())
recs = ent.Complaints.ToArray();
fillDgv(recs);
//forToday();
}
private void FileComplaintForm_Load(object sender, EventArgs e)
{
//wordCounter.Text = "0/" + narrativeField.MaxLength;
using (var ent = new EBarangayEntities())
{
citizenNames = ent.Citizens.Select(x => x.FirstName + " " + x.MiddleName + " " + x.LastName + (string.IsNullOrEmpty(x.Extension) ? "" : " " + x.Extension)).ToArray();
}
}
void AssignValuesToText()
{
if (target == null)
{
MessageBox.Show("Citizen instance not assigned.");
return;
}
IDTxt.Text = target.IdNumber;
NameTxt.Text = target.getNameWithSpace();
AddressTxt.Text = target.Address;
BdayTxt.Text = target.Birthday.ToString("MMMM dd, yyyy");
SexTxt.Text = target.Gender;
ContactTxt.Text = target.ContactInfo;
CivilStatusTxt.Text = target.CivilStatus;
MotherTxt.Text = target.MothersName;
FatherTxt.Text = target.FathersName;
SpouseTxt.Text = target.SpouseName ?? emptyField;
VotersID.Text = target.VoterID ?? emptyField;
PrecinctNumber.Text = target.PrecinctNumber ?? emptyField;
SSS.Text = target.SSS ?? emptyField;
PagIbig.Text = target.PagIbig ?? emptyField;
Philhealth.Text = target.Philhealth ?? emptyField;
Class.Date date = new Class.Date();
Class.DateTimeExtension.ToAgeString(target.Birthday, ref date);
AgeTxt.Text = target.getAGe().ToString();
//AgeTxt.Text = Class.DateTimeExtension.ToAge(target.Birthday).years.ToString();
IsIndigent.Checked = target.Indigent ? true : false;
IsStudent.Checked = target.Student ? true : false;
IsSenior.Checked = target.SeniorCitizen ? true : false;
IsPwd.Checked = target.PWD ? true : false;
RecordsTable.Rows.Clear();
using (var ent = new EBarangayEntities())
{
var t = ent.Citizens.FirstOrDefault(r => r.ID == target.ID);
ImageBox.Image = t.Picture == null ? null : Class.ImageConverter.byteArrayToImage(t.Picture);
area.Text = (t.Area?.Name) ?? "Not Asigned";
var connector = ent.CitizenToComplaints.Where(x => x.CitizenId == target.ID);
foreach (var c in connector)
{
var comp = c.Complaint;
RecordsTable.Rows.Add(comp.ID, comp.SettlementDate.ToString("MMMM dd, yyyy"), comp.Status);
}
foreach (var c in ent.Documents.Where(x => x.CitizenId == target.ID).OrderByDescending(y => y.DateIssued))
{
docTable.Rows.Add(c.ControlNumber,
c.DateIssued.Value.ToString("MMMM dd, yyyy hh:mm tt"),
c.DocumentTitle);
}
}
}
public ComplaintViewForm(int id)
{
InitializeComponent();
using (var ent = new EBarangayEntities())
{
currRec = ent.Complaints.FirstOrDefault(x => x.ID == id);
initializeFields();
}
}
private void areaTable_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
using (var p = new EBarangayEntities())
{
var t = p.Areas.FirstOrDefault(x => x.ID == targetId);
t.Name = areaTable.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
p.SaveChanges();
}
}
public static bool CitizenFound(string fullName, out Citizen citizen)
{
string n = fullName.Replace(' ', '\0');
using (var e = new EBarangayEntities())
{
citizen = e.Citizens.FirstOrDefault(x => x.FirstName + x.MiddleName + x.LastName + x.Extension == n);
}
return(citizen != null);
}
public static bool CitizenById(string id, out Citizen citizen)
{
string i = id.Trim(' ');
using (var e = new EBarangayEntities())
{
citizen = e.Citizens.FirstOrDefault(x => x.IdNumber == i);
}
return(citizen != null);
}
private void AreaForm_Load(object sender, EventArgs e)
{
using (var p = new EBarangayEntities())
{
foreach (var i in p.Areas)
{
areaTable.Rows.Add(i.ID, i.Name, "Remove");
}
}
}
private void settleSched_ValueChanged(object sender, EventArgs e)
{
using (var eb = new EBarangayEntities())
{
var id = Convert.ToInt32(controlNumberField.Text);
var c = eb.Complaints.FirstOrDefault(x => x.ID == id);
c.SettlementDate = settleSched.Value;
eb.SaveChanges();
}
OnComplaintChanges?.Invoke(this, new EventArgs());
}
public OfficerInfo()
{
using (var ent = new EBarangayEntities())
{
var sb = ent.Officials.Where(x => x.Position == "Sangguniang Barangay Member");
foreach (var s in sb)
{
sbMemebers.Add(s.Name);
}
captName = ent.Officials.FirstOrDefault(x => x.Position == "Punong Barangay").Name;
}
}
private void openStatistics_Callback(object sender, EventArgs e)
{
using (var ent = new EBarangayEntities())
{
if (ent.Citizens.Count() == 0)
{
MessageBox.Show("Empty Record");
return;
}
}
OpenStats();
}
public void PerformQuery()
{
if (SearchBox.Text == string.Empty)
{
MessageBox.Show("Search bar is empty!");
showData();
return;
}
DataTable.Rows.Clear();
using (var context = new EBarangayEntities())
{
SearchedElements = context.Citizens.Where(x => (x.FirstName + x.MiddleName + x.LastName + x.Extension).Contains(SearchBox.Text));
if (SearchedElements.Count() > 0)
{
PopulateTable(SearchedElements.ToArray());
return;
}
else
{
SearchedElements = context.Citizens.Where(x => x.Address.Contains(SearchBox.Text));
if (SearchedElements.Count() > 0)
{
PopulateTable(SearchedElements.ToArray());
return;
}
}
Citizen c = context.Citizens.FirstOrDefault(x => x.IdNumber == SearchBox.Text);
if (c == null && UserManager.instance.currentUser.Rec_Create)
{
var yesorno = new YesOrNoPrompt("Entry Not found. Would you like to go register instead?");
yesorno.FormClosed += (xx, yy) => { Enabled = true; };
yesorno.onBtnClick += (xx, yy) =>
{
if (yy)
{
IDEmptySearch?.Invoke(this, new EventArgs());
return;
}
/// set the total entries tag to 0
ResultTxt.Text = 0.ToString();
};
yesorno.Show();
Enabled = false;
return;
}
OpenPreview(c);
}
}
private void searchBtn_Click(object sender, EventArgs e)
{
using (var eb = new EBarangayEntities())
{
//citizen = eb.Citizens.ToArray();
var filtered = eb.Citizens.ToArray().AsQueryable();
if (areaOptions.Text != string.Empty)
{
var area = eb.Areas.FirstOrDefault(x => x.Name == areaOptions.Text);
filtered = area.Citizens.AsQueryable();
}
if (sexOption.Text != string.Empty)
{
filtered = filtered.Where(x => x.Gender == sexOption.Text);
}
if (civilStatusOption.Text != string.Empty)
{
filtered = filtered.Where(x => x.CivilStatus == civilStatusOption.Text);
}
if (isPwd.Checked)
{
filtered = filtered.Where(x => x.PWD);
}
if (isStudent.Checked)
{
filtered = filtered.Where(x => x.Student);
}
if (isIndigent.Checked)
{
filtered = filtered.Where(x => x.Indigent);
}
if (isSeniorCitizen.Checked)
{
filtered = filtered.Where(x => x.SeniorCitizen);
}
if (isVoter.Checked)
{
filtered = filtered.Where(x => !string.IsNullOrEmpty(x.VoterID));
}
PopulateTable(filtered.ToArray());
}
}
void registerCitizen()
{
using (var eb = new EBarangayEntities())
{
var c = eb.Citizens.FirstOrDefault(x => x.IdNumber == Id.Text);
if (c != null)
{
MessageBox.Show("Id is already taken.");
return;
}
Citizen citizen = new Citizen();
var a = eb.Areas.FirstOrDefault(x => x.Name == area.Text);
citizen.Area = a;
citizen.Picture = Class.ImageConverter.imageToByteArray(picBox.Image);
citizen.IdNumber = Id.Text;
citizen.FirstName = firstName.Text;
citizen.MiddleName = middleName.Text;
citizen.LastName = lastName.Text;
citizen.Extension = extensionName.Text;
citizen.Address = address.Text;
citizen.Birthday = birthdate.Value;
citizen.Gender = sex.Text;
citizen.ContactInfo = contact.Text;
citizen.CivilStatus = civilStatus.Text;
citizen.SpouseName = !string.IsNullOrEmpty(spouseName.Text) ? spouseName.Text : null;
citizen.FathersName = !string.IsNullOrEmpty(fathersName.Text) ? fathersName.Text : null;
citizen.MothersName = !string.IsNullOrEmpty(mothersName.Text) ? mothersName.Text : null;
citizen.Indigent = indigent.Checked;
citizen.Student = student.Checked;
citizen.PWD = pwd.Checked;
citizen.SeniorCitizen = senior.Checked;
citizen.SSS = !string.IsNullOrEmpty(sss.Text) ? sss.Text : null;
citizen.Philhealth = !string.IsNullOrEmpty(philhealth.Text) ? philhealth.Text : null;
citizen.PagIbig = !string.IsNullOrEmpty(pagibig.Text) ? pagibig.Text : null;
citizen.VoterID = !string.IsNullOrEmpty(votersId.Text) ? votersId.Text : null;
citizen.PrecinctNumber = !string.IsNullOrEmpty(precinctNumber.Text) ? precinctNumber.Text : null;
eb.Citizens.Add(citizen);
eb.SaveChanges();
}
}
void LoadOfficials()
{
using (var eb = new EBarangayEntities())
{
captainTxt.Text = eb.Officials.Find("Punong_Barangay").Name;
var sb = from sbmemb in eb.Officials
where sbmemb.Position == "Sangguniang Barangay Member"
select sbmemb;
LoadSB(sb.ToList(), sbTxt0, sbTxt1, sbTxt2, sbTxt3, sbTxt4, sbTxt5, sbTxt6);
secTxt.Text = eb.Officials.FirstOrDefault(o => o.Position == "Barangay Secretary").Name;
treasTxt.Text = eb.Officials.FirstOrDefault(o => o.Position == "Barangay Treasurer").Name;
}
}
void save(params Control[] control)
{
using (var eb = new EBarangayEntities())
{
for (int i = 0; i < officialsMarker.Length; i++)
{
if (officialsMarker[i].save)
{
int id = officialsMarker[i].Id;
var o = eb.Officials.FirstOrDefault(x => x.ID == id);
o.Name = control[i].Text;
}
}
eb.SaveChanges();
}
MessageBox.Show("Edit Successful.");
}
public void Initialize()
{
using (var ent = new EBarangayEntities())
{
totalPopulation = ent.Citizens.Count();
#region types
student = ent.Citizens.Where(x => x.Student).Count();
pwd = ent.Citizens.Where(x => x.PWD).Count();
indigent = ent.Citizens.Where(x => x.Indigent).Count();
senior = ent.Citizens.Where(x => x.SeniorCitizen).Count();
#endregion
#region areas
var areaGroup = ent.Citizens.GroupBy(x => x.AreaID);
foreach (var i in areaGroup)
{
var t = ent.Areas.FirstOrDefault(x => x.ID == i.Key);
var area = new Area {
Name = t?.Name ?? "Not Assigned", PopulationCount = i.Count()
};
areas.Add(area);
}
#endregion
#region genders
male = ent.Citizens.Where(x => x.Gender == "Male").Count();
female = totalPopulation - male;
#endregion
#region civilStats
var civilStatGroup = from g in ent.Citizens
group g by g.CivilStatus;
foreach (var g in civilStatGroup)
{
var status = new CivilStatus {
Name = g.Key, Count = g.Count()
};
cstatuses.Add(status);
}
#endregion
votersCount = ent.Citizens.Where(x => !string.IsNullOrEmpty(x.VoterID)).Count();
}
}
private void AssignBtn_Click(object sender, EventArgs e)
{
using (var entity = new EBarangayEntities())
{
var citizen = entity.Citizens.FirstOrDefault(x => x.IdNumber == idField.Text);
if (citizen == null)
{
MessageBox.Show("ID not found!");
return;
}
//if (!string.IsNullOrEmpty(citizen.RefRecords))
//{
// MessageBox.Show("A complaint is associated with this ID. Are you sure you want to continue?");
//}
AcceptCitizen(citizen);
}
}
protected override void SaveToDatabase()
{
using (var eb = new EBarangayEntities())
{
var citizen = eb.Citizens.FirstOrDefault(x => x.IdNumber == idField.Text);
if (citizen == null)
{
MessageBox.Show("Document not saved in citizen");
return;
}
var newDocument = new Document();
newDocument.Citizen = citizen;
newDocument.DocumentTitle = this.Text;
newDocument.DateIssued = DateTime.Now;
newDocument.ControlNumber = Guid.NewGuid().ToString();
eb.Documents.Add(newDocument);
eb.SaveChanges();
}
}
void markAsDone()
{
using (var eb = new EBarangayEntities())
{
var rec = eb.Complaints.FirstOrDefault(r => r.ID == currRec.ID);
if (rec == null)
{
MessageBox.Show("error in changing");
return;
}
if (rec.Status == ComplaintStatus.Settled.ToString())
{
return;
}
rec.Status = "Settled";
eb.SaveChanges();
OnComplaintChanges?.Invoke(this, new EventArgs());
}
}
void saveCitizen()
{
using (var eb = new EBarangayEntities())
{
var c = eb.Citizens.FirstOrDefault(x => x.ID == citizen.ID);
var a = eb.Areas.FirstOrDefault(x => x.Name == area.Text);
c.Area = a;
c.Picture = Class.ImageConverter.imageToByteArray(picBox.Image);
c.IdNumber = Id.Text;
c.FirstName = firstName.Text;
c.MiddleName = middleName.Text;
c.LastName = lastName.Text;
c.Extension = extensionName.Text;
c.Address = address.Text;
c.Birthday = birthdate.Value;
c.Gender = sex.Text;
c.ContactInfo = contact.Text;
c.CivilStatus = civilStatus.Text;
c.SpouseName = !string.IsNullOrEmpty(spouseName.Text) ? spouseName.Text : null;
c.FathersName = !string.IsNullOrEmpty(fathersName.Text) ? fathersName.Text : null;
c.MothersName = !string.IsNullOrEmpty(mothersName.Text) ? mothersName.Text : null;
c.Indigent = indigent.Checked;
c.Student = student.Checked;
c.PWD = pwd.Checked;
c.SeniorCitizen = senior.Checked;
c.SSS = !string.IsNullOrEmpty(sss.Text) ? sss.Text : null;
c.Philhealth = !string.IsNullOrEmpty(philhealth.Text) ? philhealth.Text : null;
c.PagIbig = !string.IsNullOrEmpty(pagibig.Text) ? pagibig.Text : null;
c.VoterID = !string.IsNullOrEmpty(votersId.Text) ? votersId.Text : null;
c.PrecinctNumber = !string.IsNullOrEmpty(precinctNumber.Text) ? precinctNumber.Text : null;
eb.SaveChanges();
Onsave?.Invoke(this, null);
}
}
private void LoginBtn_Click(object sender, EventArgs e)
{
#region connectiontest
try
{
using (var context = new EBarangayEntities())
{
context.Database.Connection.Open();
context.Database.Connection.Close();
}
}
catch (Exception error)
{
MessageBox.Show(error.Message);
return;
}
#endregion
if (!canLogin())
{
MessageBox.Show("Invalid Login");
return;
}
using (var t = new EB_LoginsEntities())
{
var u = from user in t.Users
where user.Username == UsernameTxt.Text && user.Password == PasswordTxt.Text
select user;
if (u.Count() == 0)
{
MessageBox.Show("User Not Found");
return;
}
UserManager.instance.currentUser = u.First();
}
UserSuccessfullyAuthenticated = true;
Close();
}
private void areaTable_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex != 2)
{
return;
}
if (MessageBox.Show("Are you sure you want to remove item?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
{
return;
}
var id = (int)(areaTable.Rows[e.RowIndex].Cells[0].Value);
using (var p = new EBarangayEntities())
{
var a = p.Areas.FirstOrDefault(x => x.ID == id);
p.Areas.Remove(a);
p.SaveChanges();
}
areaTable.Rows.RemoveAt(e.RowIndex);
}
