static public List <Objects> LoadRented(int locationNumber) { RequestDB req = new RequestDB(); List <Objects> lstObj = req.getRentedObjects(locationNumber); return(lstObj); }
static public void AddObject(string name, string type, string description, int employeeNumber, string remark = "") { RequestDB req = new RequestDB(); int typeID = req.ReqGetIDFromType(type); req.ReqAddObject(name, typeID, description, employeeNumber, remark); }
static public List <Objects> Load() { RequestDB req = new RequestDB(); List <Objects> lstObj = req.getObjects(); return(lstObj); }
private void btnReturn_Click(object sender, EventArgs e) { int rentNumber; int objectID; DateTime returnDate = DateTime.Today; bool res = int.TryParse(txtRentNumber.Text, out rentNumber); RequestDB req = new RequestDB(); objectID = req.ReqGetObjectNumber(rentNumber); Employees.ReturnObject(objectID); MessageBox.Show("L'objet a correctement été retourné"); ActiveForm.Close(); }
static public void printPDF(string data) { RequestDB req = new RequestDB(); string state; if (data == "rented") { state = "unavailable"; } else { state = "available"; } req.ReqPDF(state); }
private void btnRent_Click(object sender, EventArgs e) { int locatorNumber; int employeeNumber; string name = txtName.Text; bool res = int.TryParse(txtClientID.Text, out locatorNumber); bool res2 = int.TryParse(txtClientID.Text, out employeeNumber); DateTime returnDate = Convert.ToDateTime(selectedDate); RequestDB req = new RequestDB(); int objectNumber = req.ReqGetIDFromName(name); string state = req.ReqCheckState(objectNumber); if (state == "disponible") { Employees.RentObject(objectNumber, locatorNumber, employeeNumber, returnDate); ActiveForm.Close(); } else { MessageBox.Show("L'objet est déjà loué !"); ActiveForm.Close(); } }
static public void ReturnObject(int objectNumber) { RequestDB req = new RequestDB(); req.ReqReturnObject(objectNumber); }
static public void RentObject(int objID, int locator_id, int adder_id, DateTime expectedReturn) { RequestDB req = new RequestDB(); req.ReqRentObject(objID, locator_id, adder_id, expectedReturn); }