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