public FacultyModel UpdateFaculty(FacultyModel facultyModel) { DataTable dt = new DataTable(); using (MySqlCommand command = new MySqlCommand()) { dt = GetMultipleQuery(FacultyStringsMySql.UpdateFaculty(facultyModel)); } foreach (DataRow ms in dt.Rows) { facultyModel = FacultyModel.ToObject(ms); } return(facultyModel); }
public List <FacultyModel> GetAllFaculties() { DataTable dt = new DataTable(); using (OleDbCommand command = new OleDbCommand()) { dt = GetMultipleQuery(FacultyStringsInner.GetAllFaculties()); } List <FacultyModel> arrFaculty = new List <FacultyModel>(); foreach (DataRow ms in dt.Rows) { arrFaculty.Add(FacultyModel.ToObject(ms)); } return(arrFaculty); }
public FacultyModel GetOneFacultyByCode(string facultyCode) { DataTable dt = new DataTable(); if (facultyCode.Equals(string.Empty) || facultyCode.Equals("")) { throw new ArgumentOutOfRangeException(); } FacultyModel facultyModel = new FacultyModel(); using (OleDbCommand command = new OleDbCommand()) { dt = GetMultipleQuery(FacultyStringsInner.GetOneFacultyByCode(facultyCode)); } foreach (DataRow ms in dt.Rows) { facultyModel = FacultyModel.ToObject(ms); } return(facultyModel); }