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