public ThreeObjectsModel GetAllThreeObjectsByVehicleNumber(string vehicleNumber) { ThreeObjectsModel threeObjects = new ThreeObjectsModel(); VehicleModel vehicleModel = vehicleRepository.GetOneVehicleByNumber(vehicleNumber); PersonModel personModel; if (studentRepository.GetOneStudentById(vehicleModel.vehicleOwnerId) != null) { personModel = studentRepository.GetOneStudentById(vehicleModel.vehicleOwnerId); } else { personModel = teacherRepository.GetOneTeacherById(vehicleModel.vehicleOwnerId); } ApprovalModel approvalModel = approvalRepository.GetOneApprovalByPersonId(vehicleModel.vehicleOwnerId); threeObjects.personModel = personModel; threeObjects.vehicleModel = vehicleModel; threeObjects.approvalModel = approvalModel; return(threeObjects); }
public List <ThreeObjectsModel> GetAllThreeObjects() { List <ThreeObjectsModel> threeObjectsList = new List <ThreeObjectsModel>(); List <PersonModel> allPersonsId = personRepository.GetAllPersonsId(); for (int i = 0; i < allPersonsId.Count; i++) { ThreeObjectsModel threeObjects = new ThreeObjectsModel(); PersonModel personModel; if (studentRepository.GetOneStudentById(allPersonsId[i].personId) != null) { personModel = studentRepository.GetOneStudentById(allPersonsId[i].personId); } else { personModel = teacherRepository.GetOneTeacherById(allPersonsId[i].personId); } VehicleModel vehicleModel = vehicleRepository.GetOneVehicleByOwnerId(allPersonsId[i].personId); ApprovalModel approvalModel = approvalRepository.GetOneApprovalByPersonId(allPersonsId[i].personId); threeObjects.personModel = personModel; threeObjects.vehicleModel = vehicleModel; threeObjects.approvalModel = approvalModel; threeObjectsList.Add(threeObjects); } return(threeObjectsList); }
public ApprovalModel UpdateApproval(ApprovalModel approvalModel) { var resultSP = DB.UpdateApproval(approvalModel.approvalCode, approvalModel.approvalFrom, approvalModel.approvalUntil, approvalModel.approvalPersonId, approvalModel.approvalNumber).Select(a => new ApprovalModel { approvalCode = a.approvalCode, approvalFrom = a.approvalFrom, approvalUntil = a.approvalUntil, approvalPersonId = a.approvalPersonId, approvalNumber = a.approvalNumber }); if (GlobalVariable.queryType == 0) { APPROVAL approval = DB.APPROVALS.Where(a => a.approvalPersonId == approvalModel.approvalPersonId).SingleOrDefault(); if (approval == null) { return(null); } approval.approvalCode = approvalModel.approvalCode; approval.approvalFrom = approvalModel.approvalFrom; approval.approvalUntil = approvalModel.approvalUntil; approval.approvalPersonId = approvalModel.approvalPersonId; approval.approvalNumber = approvalModel.approvalNumber; DB.SaveChanges(); return(GetOneApprovalByNumber(approval.approvalNumber)); } else { return(resultSP.SingleOrDefault()); } }
public ApprovalModel AddApproval(ApprovalModel approvalModel) { var resultSP = DB.AddApproval(approvalModel.approvalCode, approvalModel.approvalFrom, approvalModel.approvalUntil, approvalModel.approvalPersonId).Select(a => new ApprovalModel { approvalCode = a.approvalCode, approvalFrom = a.approvalFrom, approvalUntil = a.approvalUntil, approvalPersonId = a.approvalPersonId, approvalNumber = a.approvalNumber }); if (GlobalVariable.queryType == 0) { APPROVAL approval = new APPROVAL { approvalCode = approvalModel.approvalCode, approvalFrom = approvalModel.approvalFrom, approvalUntil = approvalModel.approvalUntil, approvalPersonId = approvalModel.approvalPersonId }; DB.APPROVALS.Add(approval); DB.SaveChanges(); return(GetOneApprovalByNumber(approval.approvalNumber)); } else { return(resultSP.SingleOrDefault()); } }
public ApprovalModel UpdateApproval(ApprovalModel approvalModel) { _approvals.ReplaceOne(approval => approval.approvalNumber.Equals(approvalModel.approvalNumber), approvalModel); ApprovalModel tmpApprovalModel = GetOneApprovalByPersonId(approvalModel.approvalPersonId); return(tmpApprovalModel); }
static public SqlCommand UpdateApproval(ApprovalModel approvalModel) { if (GlobalVariable.queryType == 0) { return(CreateSqlCommand(approvalModel, queryApprovalsUpdate)); } else { return(CreateSqlCommand(approvalModel, procedureApprovalsUpdate)); } }
public ApprovalModel UpdateApproval(ApprovalModel approval) { int i = -1; using (OleDbCommand command = new OleDbCommand()) { i = base.ExecuteNonQuery(ApprovalStringsInner.UpdateApproval(approval)); } return(GetOneApprovalByCode(approval.approvalCode)); }
public ApprovalModel AddApproval(ApprovalModel approvalModel) { if (_approvals.Find <ApprovalModel>(Builders <ApprovalModel> .Filter.Eq(approval => approval.approvalPersonId, approvalModel.approvalPersonId)).FirstOrDefault() == null) { _approvals.InsertOne(approvalModel); } ApprovalModel tmpApprovalModel = GetOneApprovalByPersonId(approvalModel.approvalPersonId); return(tmpApprovalModel); }
public HttpResponseMessage GetOneApprovalByCode(string approvalCode) { try { ApprovalModel approvalModel = approvalRepository.GetOneApprovalByCode(approvalCode); return(Request.CreateResponse(HttpStatusCode.OK, approvalModel)); } catch (Exception ex) { Errors errors = ErrorsHelper.GetErrors(ex); return(Request.CreateResponse(HttpStatusCode.InternalServerError, errors)); } }
public static ApprovalModel ToObject(DataRow reader) { ApprovalModel approvalModel = new ApprovalModel(); approvalModel.approvalCode = reader[0].ToString(); approvalModel.approvalFrom = DateTime.Parse(reader[1].ToString()); approvalModel.approvalUntil = DateTime.Parse(reader[2].ToString()); approvalModel.approvalPersonId = reader[3].ToString(); approvalModel.approvalNumber = int.Parse(reader[4].ToString()); Debug.WriteLine("ApprovalModel:" + approvalModel.ToString()); return(approvalModel); }
static private SqlCommand CreateSqlCommand(ApprovalModel approval, string commandText) { SqlCommand command = new SqlCommand(commandText); command.Parameters.AddWithValue("@approvalCode", approval.approvalCode); command.Parameters.AddWithValue("@approvalFrom", approval.approvalFrom); command.Parameters.AddWithValue("@approvalUntil", approval.approvalUntil); command.Parameters.AddWithValue("@approvalPersonId", approval.approvalPersonId); if (approval.approvalNumber > 0) { command.Parameters.AddWithValue("@approvalNumber", approval.approvalNumber); } return(command); }
public ApprovalModel AddApproval(ApprovalModel approvalModel) { DataTable dt = new DataTable(); using (MySqlCommand command = new MySqlCommand()) { dt = GetMultipleQuery(ApprovalStringsMySql.AddApproval(approvalModel)); } foreach (DataRow ms in dt.Rows) { approvalModel = ApprovalModel.ToObject(ms); } return(approvalModel); }
public ApprovalModel GetOneApprovalByNumber(int approvalNumber) { DataTable dt = new DataTable(); ApprovalModel app = new ApprovalModel(); using (OleDbCommand command = new OleDbCommand()) { dt = GetMultipleQuery(ApprovalStringsInner.GetOneApprovalByNumber(approvalNumber)); } foreach (DataRow ms in dt.Rows) { app = ApprovalModel.ToObject(ms); } return(app); }
public List <ApprovalModel> GetAllApprovals() { DataTable dt = new DataTable(); List <ApprovalModel> apv = new List <ApprovalModel>(); using (OleDbCommand command = new OleDbCommand()) { dt = GetMultipleQuery(ApprovalStringsInner.GetAllApprovals()); } foreach (DataRow ms in dt.Rows) { apv.Add(ApprovalModel.ToObject(ms)); } return(apv); }
public List <ApprovalModel> GetAllApprovals() { DataTable dt = new DataTable(); using (MySqlCommand command = new MySqlCommand()) { dt = GetMultipleQuery(ApprovalStringsMySql.GetAllApprovals()); } List <ApprovalModel> arrApproval = new List <ApprovalModel>(); foreach (DataRow ms in dt.Rows) { arrApproval.Add(ApprovalModel.ToObject(ms)); } return(arrApproval); }
public ThreeObjectsModel UpdateThreeObjects(ThreeObjectsModel threeObjectsModel) { if (threeObjectsModel.personModel is StudentModel) { studentRepository.UpdateStudent(threeObjectsModel.personModel as StudentModel); } if (threeObjectsModel.personModel is TeacherModel) { teacherRepository.UpdateTeacher(threeObjectsModel.personModel as TeacherModel); } VehicleModel vehicle = vehicleRepository.UpdateVehicle(threeObjectsModel.vehicleModel); ApprovalModel approval = approvalRepository.UpdateApproval(threeObjectsModel.approvalModel); ThreeObjectsModel threeObjectsModel2 = GetAllThreeObjectsByPersonId(threeObjectsModel.personModel.personId); return(threeObjectsModel2); }
public HttpResponseMessage AddApproval(ApprovalModel approvalModel) { try { HttpResponseMessage hrm = new HttpResponseMessage(HttpStatusCode.Created) { Content = new StringContent(JsonConvert.SerializeObject(approvalRepository.AddApproval(approvalModel))) }; return(hrm); } catch (Exception ex) { Errors errors = ErrorsHelper.GetErrors(ex); HttpResponseMessage hr = new HttpResponseMessage(HttpStatusCode.InternalServerError) { Content = new StringContent(errors.ToString()) }; return(hr); } }
public ApprovalModel GetOneApprovalByPersonId(string personId) { DataTable dt = new DataTable(); if (personId.Equals(string.Empty) || personId.Equals("")) { throw new ArgumentOutOfRangeException(); } ApprovalModel approvalModel = new ApprovalModel(); using (MySqlCommand command = new MySqlCommand()) { dt = GetMultipleQuery(ApprovalStringsMySql.GetOneApprovalByPersonId(personId)); } foreach (DataRow ms in dt.Rows) { approvalModel = ApprovalModel.ToObject(ms); } return(approvalModel); }
public ApprovalModel GetOneApprovalByNumber(int approvalNumber) { DataTable dt = new DataTable(); if (approvalNumber < 1) { throw new ArgumentOutOfRangeException(); } ApprovalModel approvalModel = new ApprovalModel(); using (MySqlCommand command = new MySqlCommand()) { dt = GetMultipleQuery(ApprovalStringsMySql.GetOneApprovalByNumber(approvalNumber)); } foreach (DataRow ms in dt.Rows) { approvalModel = ApprovalModel.ToObject(ms); } return(approvalModel); }
public HttpResponseMessage AddApproval(ApprovalModel approvalModel) { try { if (approvalModel == null) { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Data is null.")); } if (!ModelState.IsValid) { Errors errors = ErrorsHelper.GetErrors(ModelState); return(Request.CreateResponse(HttpStatusCode.BadRequest, errors)); } ApprovalModel addedApproval = approvalRepository.AddApproval(approvalModel); return(Request.CreateResponse(HttpStatusCode.Created, addedApproval)); } catch (Exception ex) { Errors errors = ErrorsHelper.GetErrors(ex); return(Request.CreateResponse(HttpStatusCode.InternalServerError, errors)); } }
public HttpResponseMessage UpdateApproval(string updateByCode, ApprovalModel approvalModel) { try { approvalModel.approvalCode = updateByCode; ApprovalModel updatedApproval = approvalRepository.UpdateApproval(approvalModel); HttpResponseMessage hrm = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(JsonConvert.SerializeObject(updatedApproval)) }; 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 UpdateApproval(int approvalNumber, ApprovalModel approvalModel) { try { if (approvalModel == null) { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Data is null.")); } if (!ModelState.IsValid) { Errors errors = ErrorsHelper.GetErrors(ModelState); return(Request.CreateResponse(HttpStatusCode.BadRequest, errors)); } approvalModel.approvalNumber = approvalNumber; ApprovalModel updatedApproval = approvalRepository.UpdateApproval(approvalModel); return(Request.CreateResponse(HttpStatusCode.OK, updatedApproval)); } catch (Exception ex) { Errors errors = ErrorsHelper.GetErrors(ex); return(Request.CreateResponse(HttpStatusCode.InternalServerError, errors)); } }
public ThreeObjectsModel(PersonModel person2, VehicleModel vehicle2, ApprovalModel approval2) { personModel = person2; vehicleModel = vehicle2; approvalModel = approval2; }
static public OleDbCommand AddApproval(ApprovalModel approvalModel) { return(CreateOleDbCommand(approvalModel, queryApprovalsPost)); }
static public OleDbCommand UpdateApproval(ApprovalModel approvalModel) { return(CreateOleDbCommand(approvalModel, queryApprovalsUpdate)); }