public FacultyModel AddFaculty(FacultyModel facultyModel) { var resultSP = DB.AddFaculty(facultyModel.facultyCode, facultyModel.facultyName, facultyModel.facultyHead).Select(f => new FacultyModel { facultyCode = f.facultyCode, facultyHead = f.facultyHead, facultyName = f.facultyName }); if (GlobalVariable.queryType == 0) { FACULTY faculty = new FACULTY { facultyCode = facultyModel.facultyCode, facultyHead = facultyModel.facultyHead, facultyName = facultyModel.facultyName }; DB.FACULTYS.Add(faculty); DB.SaveChanges(); return(GetOneFacultyByCode(faculty.facultyCode)); } else { return(resultSP.SingleOrDefault()); } }
public FacultyModel UpdateFaculty(FacultyModel facultyModel) { _faculties.ReplaceOne(faculty => faculty.facultyCode.Equals(facultyModel.facultyCode), facultyModel); FacultyModel tmpFacultyModel = GetOneFacultyByCode(facultyModel.facultyCode); return(tmpFacultyModel); }
public FacultyModel UpdateFaculty(FacultyModel facultyModel) { var resultSP = DB.UpdateFaculty(facultyModel.facultyCode, facultyModel.facultyName, facultyModel.facultyHead).Select(f => new FacultyModel { facultyCode = f.facultyCode, facultyHead = f.facultyHead, facultyName = f.facultyName }); if (GlobalVariable.queryType == 0) { FACULTY faculty = DB.FACULTYS.Where(f => f.facultyCode.Equals(facultyModel.facultyCode)).SingleOrDefault(); if (faculty == null) { return(null); } faculty.facultyCode = facultyModel.facultyCode; faculty.facultyHead = facultyModel.facultyHead; faculty.facultyName = facultyModel.facultyName; DB.SaveChanges(); return(GetOneFacultyByCode(faculty.facultyCode)); } else { return(resultSP.SingleOrDefault()); } }
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); }
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); }
static public SqlCommand 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 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 HttpResponseMessage GetOneFacultyByCode(string facultyCode) { try { FacultyModel facultyModel = facultyRepository.GetOneFacultyByCode(facultyCode); return(Request.CreateResponse(HttpStatusCode.OK, facultyModel)); } catch (Exception ex) { Errors errors = ErrorsHelper.GetErrors(ex); return(Request.CreateResponse(HttpStatusCode.InternalServerError, errors)); } }
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 HttpResponseMessage AddFaculty(FacultyModel facultyModel) { try { HttpResponseMessage hrm = new HttpResponseMessage(HttpStatusCode.Created) { Content = new StringContent(JsonConvert.SerializeObject(facultyRepository.AddFaculty(facultyModel))) }; return(hrm); } catch (Exception ex) { Errors errors = ErrorsHelper.GetErrors(ex); HttpResponseMessage hr = new HttpResponseMessage(HttpStatusCode.InternalServerError) { Content = new StringContent(errors.ToString()) }; return(hr); } }
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); }
public HttpResponseMessage AddFaculty(FacultyModel facultyModel) { try { if (facultyModel == null) { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Data is null.")); } if (!ModelState.IsValid) { Errors errors = ErrorsHelper.GetErrors(ModelState); return(Request.CreateResponse(HttpStatusCode.BadRequest, errors)); } FacultyModel addedFaculty = facultyRepository.AddFaculty(facultyModel); return(Request.CreateResponse(HttpStatusCode.Created, addedFaculty)); } catch (Exception ex) { Errors errors = ErrorsHelper.GetErrors(ex); return(Request.CreateResponse(HttpStatusCode.InternalServerError, errors)); } }
public HttpResponseMessage UpdateFaculty(string updateByCode, FacultyModel facultyModel) { try { facultyModel.facultyCode = updateByCode; FacultyModel updatedFaculty = facultyRepository.UpdateFaculty(facultyModel); HttpResponseMessage hrm = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(JsonConvert.SerializeObject(updatedFaculty)) }; return(hrm); } catch (Exception ex) { Errors errors = ErrorsHelper.GetErrors(ex); HttpResponseMessage hr = new HttpResponseMessage(HttpStatusCode.InternalServerError) { Content = new StringContent(errors.ToString()) }; return(hr); } }
public HttpResponseMessage UpdateFaculty(string facultyCode, FacultyModel facultyModel) { try { if (facultyModel == null) { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Data is null.")); } if (!ModelState.IsValid) { Errors errors = ErrorsHelper.GetErrors(ModelState); return(Request.CreateResponse(HttpStatusCode.BadRequest, errors)); } facultyModel.facultyCode = facultyCode; FacultyModel updatedFaculty = facultyRepository.UpdateFaculty(facultyModel); return(Request.CreateResponse(HttpStatusCode.OK, updatedFaculty)); } catch (Exception ex) { Errors errors = ErrorsHelper.GetErrors(ex); return(Request.CreateResponse(HttpStatusCode.InternalServerError, errors)); } }
static public OleDbCommand UpdateFaculty(FacultyModel facultyModel) { return(CreateOleDbCommand(facultyModel, queryFacultysUpdate)); }
static public OleDbCommand AddFaculty(FacultyModel facultyModel) { return(CreateOleDbCommand(facultyModel, queryFacultysPost)); }