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; }