private void ViewAndEditBtnHS_Click(object sender, RoutedEventArgs e)
{
HighSchoolBasicInfoClass hsbi = myHSDataGrid.SelectedItem as HighSchoolBasicInfoClass;
AdminStudentInformationWindowHS asiw = new AdminStudentInformationWindowHS(hsbi.Id);
asiw.ShowDialog();
}
public HighSchoolBasicInformationUC()
{
InitializeComponent();
// DataAccess variable to retrieve and autofill previously saved information
DataAccess db = new DataAccess();
hbi = db.GetHSBI(LoginPage.highschoolCheck.Id);
textFields.DataContext = hbi;
}
private void Load()
{
DataAccess db = new DataAccess();
hsbi = db.GetHSBI(Id);
hsec = db.GetHSEC(Id);
hshi = db.GetHSHI(Id);
hsp = db.GetHSP(Id);
hsci = db.GetHSCI(Id);
BasicInfoField.DataContext = hsbi;
EmergencyContactField.DataContext = hsec;
HealthInformationField.DataContext = hshi;
StudentPolicyField.DataContext = hsp;
ConfidentialInfoField.DataContext = hsci;
if (hshi.healthSignature != null)
{
using (MemoryStream ms = new MemoryStream(hshi.healthSignature))
{
HISignatureCanvas.Strokes = new System.Windows.Ink.StrokeCollection(ms);
ms.Close();
}
}
if (hsp.parentSignature != null)
{
using (MemoryStream ms = new MemoryStream(hsp.parentSignature))
{
parentSigPolicyCanvas.Strokes = new System.Windows.Ink.StrokeCollection(ms);
ms.Close();
}
}
if (hsp.studentSignature != null)
{
using (MemoryStream ms = new MemoryStream(hsp.studentSignature))
{
policySignatureCanvas.Strokes = new System.Windows.Ink.StrokeCollection(ms);
ms.Close();
}
}
if (hsci.parentSignature != null)
{
using (MemoryStream ms = new MemoryStream(hsci.parentSignature))
{
parentSigCanvas.Strokes = new System.Windows.Ink.StrokeCollection(ms);
ms.Close();
}
}
}
public void UpdateValues(HighSchoolBasicInfoClass hbi)
{
_lastName = hbi.lastName;
_firstName = hbi.firstName;
_middleInitial = hbi.middleInitial;
_program = hbi.program;
_streetAddress = hbi.streetAddress;
_city = hbi.city;
_state = hbi.state;
_zip = hbi.zipCode;
_primaryPhoneNum = hbi.primaryPhoneNum;
_cellPhoneNum = hbi.cellPhoneNum;
_hispanicOrLatino = hbi.hispanicOrLatino;
_race = hbi.race;
_gender = hbi.gender;
_dateOfBirth = hbi.dateOfBirth;
_currentEdLevel = hbi.currentEdLevel;
_sendingHS = hbi.sendingHS;
}
public void SaveHSBI(HighSchoolBasicInfoClass hsbi, HighSchoolBasicInfoTextValidation hsbiCheck)
{
string query = $"Update HighSchoolBasicInfo Set ";
List <string> listToSave = new List <string>(new string[] { "lastName = @LastName", "firstName = @FirstName", "middleInitial = @MiddleInitial", "preferredName = @PreferredName", "program = @Program", "streetAddress = @StreetAddress", "city = @City", "state = @State", "zipCode = @ZipCode", "primaryPhoneNum = @PrimaryPhoneNum", "cellPhoneNum = @CellPhoneNum", "hispanicOrLatino = @HispanicOrLatino", "race = @Race", "gender = @Gender", "dateOfBirth = @DateOfBirth", "currentEdLevel = @CurrentEdLevel", "sendingHS = @SendingHS" });
List <string> toRemove = hsbiCheck.IsValid;
foreach (var v in toRemove)
{
for (int i = 0; i < listToSave.Count; i++)
{
if (listToSave[i].Contains(v))
{
listToSave.RemoveAt(i);
i--;
}
}
}
foreach (var s in listToSave)
{
if (listToSave.IndexOf(s) != listToSave.Count - 1)
{
query += s + ",";
}
else
{
query += s;
}
}
query += " Where Id = @id";
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(Helper.CnnVal("EnrollmentDB")))
{
connection.Execute(query,
new { LastName = hsbi.lastName, FirstName = hsbi.firstName, MiddleInitial = hsbi.middleInitial, PreferredName = hsbi.preferredName, Program = hsbi.program, StreetAddress = hsbi.streetAddress, City = hsbi.city, State = hsbi.state, ZipCode = hsbi.zipCode, PrimaryPhoneNum = hsbi.primaryPhoneNum, CellPhoneNum = hsbi.cellPhoneNum, HispanicOrLatino = hsbi.hispanicOrLatino, Race = hsbi.race, Gender = hsbi.gender, DateOfBirth = hsbi.dateOfBirth, CurrentEdLevel = hsbi.currentEdLevel, SendingHS = hsbi.sendingHS, id = hsbi.Id });
}
}
