private List <FacultyCost> search() { List <FacultyCost> list = new List <FacultyCost>(); connection = new MySqlConnection(connString); try { connection.Open(); command = new MySqlCommand(sql, connection); dataReader = command.ExecuteReader(); while (dataReader.Read()) { FacultyCost fclct = new FacultyCost(); fclct.FacultyId = dataReader.GetInt32(0); fclct.Cost = dataReader.GetInt32(1); list.Add(fclct); } dataReader.Close(); command.Dispose(); connection.Close(); } catch (Exception ex) { return(null); } return(list); }
// POST api/facultycost public FacultyCost Post(FacultyCost facCost) { if (fctCostService.Insert(facCost)) { return(facCost); } return(null); }
// PUT api/facultycost/5 public FacultyCost Put(int id, FacultyCost newFacultyCost) { if (fctCostService.SearchId(id).Count > 0) { if (fctCostService.Edit(newFacultyCost)) { return(newFacultyCost); } } return(null); }
// DELETE api/facultycost/5 public FacultyCost Delete(int id) { FacultyCost oldFacultyCost = new FacultyCost(); var data = fctCostService.SearchId(id); if (data.Count > 0) { oldFacultyCost.SetFacultyCost(data.ElementAt(0)); if (fctCostService.DeleteId(id)) { return(oldFacultyCost); } } return(null); }
public bool Edit(FacultyCost fcltct) { sql = "UPDATE faculties_cost SET Faculties_facultyID='" + fcltct.FacultyId + "', facCost='" + fcltct.Cost + "' WHERE Faculties_facultyID='" + fcltct.FacultyId + "'"; return(EditTable()); }
public bool Insert(FacultyCost fclct) { sql = "INSERT INTO faculties_cost (Faculties_facultyID, facCost) VALUES ('" + fclct.FacultyId + "' , '" + fclct.Cost + "' )"; return(EditTable()); }