void GetOccupation()
{
try
{
string sql = "exec sms.getstaticdata 0,'EmployementType'," + Schoolid;
DataTable dt = DAL.Select(sql);
lstFathersOccupation = new ObservableCollection <StaticDataModel>();
lstMothersOccupation = new ObservableCollection <StaticDataModel>();
foreach (DataRow dr in dt.Rows)
{
StaticDataModel obj = new StaticDataModel();
obj.StaticID = int.Parse(dr[0].ToString());
obj.StaticName = dr[1].ToString();
lstFathersOccupation.Add(obj);
lstMothersOccupation.Add(obj);
}
SelectedOccupationFather = new StaticDataModel();
SelectedOccupationMother = new StaticDataModel();
SelectedOccupationFather = lstFathersOccupation.FirstOrDefault();
SelectedOccupationMother = lstMothersOccupation.FirstOrDefault();
}
catch (Exception ex)
{
DAL.logger.Log(ex.Message + Environment.NewLine + ex.StackTrace, MessageType.Error);
}
}
public new DataTable GetClassRoom()
{
DataTable dt = Common.GetClassRoom();
lstClassRoom = new ObservableCollection <StaticDataModel>();
foreach (DataRow dr in dt.Rows)
{
StaticDataModel obj = new StaticDataModel();
obj.StaticID = int.Parse(dr[0].ToString());
obj.StaticName = dr[1].ToString();
lstClassRoom.Add(obj);
}
SelectedClassRoom = lstClassRoom.First();
return(dt);
}
public void GetExpenseMaster()
{
lstExpenses = new ObservableCollection <StaticDataModel>();
DataTable dt = Common.GetExpenseMaster();
foreach (DataRow dr in dt.Rows)
{
StaticDataModel obj = new StaticDataModel();
obj.StaticID = Convert.ToInt32(dr[0]);
obj.StaticName = dr[1].ToString();
lstExpenses.Add(obj);
}
SelectedExpense = lstExpenses.FirstOrDefault();
}
void GetAcademicYear()
{
DataTable dt = Common.GetAcademicYear();
lstAcademicYear = new ObservableCollection <StaticDataModel>();
foreach (DataRow dr in dt.Rows)
{
StaticDataModel obj = new StaticDataModel();
obj.StaticID = int.Parse(dr[0].ToString());
obj.StaticName = dr[1].ToString();
lstAcademicYear.Add(obj);
}
this.SelectedAcademicYear = lstAcademicYear.FirstOrDefault();
}
public override DataTable GetStaticData(string StaticType)
{
lstFeesType = new ObservableCollection <StaticDataModel>();
DataTable dt = base.GetStaticData(StaticType);
foreach (DataRow dr in dt.Rows)
{
StaticDataModel obj = new StaticDataModel();
obj.StaticID = Convert.ToInt32(dr[0]);
obj.StaticName = dr[1].ToString();
lstFeesType.Add(obj);
}
lstFeesType.RemoveAt(0);
SelectedFees = new StaticDataModel();
SelectedFees = lstFeesType.FirstOrDefault();
SelectedFees.StaticID = 0;
//selectedindex = 0;
return(dt);
}
public void GetDocumentTypes()
{
try
{
lstDocumentType = new ObservableCollection <StaticDataModel>();
DataTable dt = Common.GetDocumentType();
foreach (DataRow dr in dt.Rows)
{
StaticDataModel obj = new StaticDataModel();
obj.StaticID = Convert.ToInt32(dr[0]);
obj.StaticName = dr[1].ToString();
lstDocumentType.Add(obj);
}
lstDocumentType.RemoveAt(0);
}
catch (Exception ex)
{
DAL.logger.Log(ex.Message + Environment.NewLine + ex.StackTrace, MessageType.Error);
}
}
public new DataTable GetClassRoom()
{
DataTable dt = null;
try
{
dt = Common.GetClassRoom();
lstClassRoom = new ObservableCollection <StaticDataModel>();
foreach (DataRow dr in dt.Rows)
{
StaticDataModel obj = new StaticDataModel();
obj.StaticID = int.Parse(dr[0].ToString());
obj.StaticName = dr[1].ToString();
lstClassRoom.Add(obj);
}
SelectedClass = lstClassRoom.FirstOrDefault();
}
catch (Exception ex)
{
DAL.logger.Log(ex.Message + Environment.NewLine + ex.StackTrace, MessageType.Error);
}
return(dt);
}
public void GetReligion()
{
try
{
string sql = "exec sms.getstaticdata 0,'Religion'," + Schoolid;
DataTable dt = DAL.Select(sql);
lstReligion = new ObservableCollection <StaticDataModel>();
foreach (DataRow dr in dt.Rows)
{
StaticDataModel obj = new StaticDataModel();
obj.StaticID = int.Parse(dr[0].ToString());
obj.StaticName = dr[1].ToString();
lstReligion.Add(obj);
}
// lstReligion.RemoveAt(0);
SelectedReligion = new StaticDataModel();
SelectedReligion = lstReligion.First();
}
catch (Exception ex)
{
DAL.logger.Log(ex.Message + Environment.NewLine + ex.StackTrace, MessageType.Error);
}
//SelectedReligion.StaticID = 7;
}
