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