public FacultyModel UpdateFaculty(FacultyModel facultyModel) { _faculties.ReplaceOne(faculty => faculty.facultyCode.Equals(facultyModel.facultyCode), facultyModel); FacultyModel tmpFacultyModel = GetOneFacultyByCode(facultyModel.facultyCode); return(tmpFacultyModel); }
static private OleDbCommand CreateOleDbCommand(FacultyModel faculty, string commandText) { OleDbCommand command = new OleDbCommand(commandText); command.Parameters.AddWithValue("@facultyCode", faculty.facultyCode); command.Parameters.AddWithValue("@facultyName", faculty.facultyName); command.Parameters.AddWithValue("@facultyHead", faculty.facultyHead); return(command); }
static public MySqlCommand UpdateFaculty(FacultyModel facultyModel) { if (GlobalVariable.queryType == 0) { return(CreateSqlCommand(facultyModel, queryFacultysUpdate)); } else { return(CreateSqlCommand(facultyModel, procedureFacultysUpdate)); } }
public FacultyModel UpdateFaculty(FacultyModel facultyModel) { int i = -1; using (OleDbCommand command = new OleDbCommand()) { i = ExecuteNonQuery(FacultyStringsInner.UpdateFaculty(facultyModel)); } return(GetOneFacultyByCode(facultyModel.facultyCode)); }
public static FacultyModel ToObject(DataRow reader) { FacultyModel facultyModel = new FacultyModel(); facultyModel.facultyCode = reader[0].ToString(); facultyModel.facultyName = reader[1].ToString(); facultyModel.facultyHead = reader[2].ToString(); Debug.WriteLine("FacultyModel:" + facultyModel.ToString()); return(facultyModel); }
public FacultyModel AddFaculty(FacultyModel facultyModel) { if (_faculties.Find <FacultyModel>(Builders <FacultyModel> .Filter.Eq(faculty => faculty.facultyCode, facultyModel.facultyCode)).FirstOrDefault() == null) { _faculties.InsertOne(facultyModel); } FacultyModel tmpFacultyModel = GetOneFacultyByCode(facultyModel.facultyCode); return(tmpFacultyModel); }
public FacultyModel UpdateFaculty(FacultyModel facultyModel) { DataTable dt = new DataTable(); using (SqlCommand command = new SqlCommand()) { dt = GetMultipleQuery(FacultyStringsSql.UpdateFaculty(facultyModel)); } foreach (DataRow ms in dt.Rows) { facultyModel = FacultyModel.ToObject(ms); } return(facultyModel); }
public List <FacultyModel> GetAllFaculties() { DataTable dt = new DataTable(); using (SqlCommand command = new SqlCommand()) { dt = GetMultipleQuery(FacultyStringsSql.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 (SqlCommand command = new SqlCommand()) { dt = GetMultipleQuery(FacultyStringsSql.GetOneFacultyByCode(facultyCode)); } foreach (DataRow ms in dt.Rows) { facultyModel = FacultyModel.ToObject(ms); } return(facultyModel); }
static public OleDbCommand UpdateFaculty(FacultyModel facultyModel) { return(CreateOleDbCommand(facultyModel, queryFacultysUpdate)); }
static public OleDbCommand AddFaculty(FacultyModel facultyModel) { return(CreateOleDbCommand(facultyModel, queryFacultysPost)); }