private void SaveChanges()
{
StdAddressUpdateDb db = new StdAddressUpdateDb();
Student s = StudentList[StudentListIndex];
s.PstAddrLane1 = PrsntAddr1;
s.PstAddrLane2 = PrsntAddr2;
s.PstAddrPO = PrsntPO;
s.PstAddrDist = PrsntDist;
s.PstAddrPin = PrsntPin;
s.PmtAddrLane1 = PrmtAddr1;
s.PmtAddrLane2 = PrmtAddr2;
s.PmtAddrPO = PrmtPO;
s.PmtAddrPS = PrmtPS;
s.PmtAddrDist = PrmtDist;
s.PmtAddrPin = PrmtPin;
if (db.UpdateSplitAddress(s))
{
Msg = s.Name + "'s address updated successfully.";
if (StudentListIndex + 1 < StudentList.Count)
{
StudentListIndex++;
SameBothAddress = false;
}
}
else
{
Msg = "Sorry! failed to update";
}
}
private void StartUpInitializer()
{
StdAddressUpdateDb db = new StdAddressUpdateDb();
StartYear = EndYear = DateTime.Now.Year;
SclClass = new string[] { "V", "VI", "VII", "VIII", "IX", "X", "XI", "XII" };
SclSection = new string[] { "A", "B", "C", "D", "E" };
SclClassIndex = SclSectionIndex = -1;
StudentList = new ObservableCollection <Student>();
PrsntAddr1List = db.GetUniqueAddrLaneX(Models.SplitAddrX.AddrLane1);
PrsntAddr2List = db.GetUniqueAddrLaneX(Models.SplitAddrX.AddrLane2);
PrsntAddrPOList = db.GetUniqueAddrLaneX(Models.SplitAddrX.PO);
PrsntAddrPSList = db.GetUniqueAddrLaneX(Models.SplitAddrX.PS);
PrsntAddrDistList = db.GetUniqueAddrLaneX(Models.SplitAddrX.Dist);
PrsntAddrPinList = db.GetUniqueAddrLaneX(Models.SplitAddrX.PIN);
PrmtAddr1List = db.GetUniqueAddrLaneX(Models.SplitAddrX.AddrLane1);
PrmtAddr2List = db.GetUniqueAddrLaneX(Models.SplitAddrX.AddrLane2);
PrmtAddrPOList = db.GetUniqueAddrLaneX(Models.SplitAddrX.PO);
PrmtAddrPSList = db.GetUniqueAddrLaneX(Models.SplitAddrX.PS);
PrmtAddrDistList = db.GetUniqueAddrLaneX(Models.SplitAddrX.Dist);
PrmtAddrPinList = db.GetUniqueAddrLaneX(Models.SplitAddrX.PIN);
StudentListIndex = -1;
GetStudentCommand = new RelayCommand(GetStudent, CanGetStudent);
SaveChangesCommand = new RelayCommand(SaveChanges, CanSaveCanges);
}
private void GetStudent()
{
StdAddressUpdateDb db = new StdAddressUpdateDb();
StudentList = db.GetStudentAddressData(startYear: StartYear, endYear: EndYear, cls: SclClass[SclClassIndex], section: SclSection[SclSectionIndex]);
}
