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