private List <Deadspot> search() { List <Deadspot> list = new List <Deadspot>(); connection = new MySqlConnection(connString); try { connection.Open(); command = new MySqlCommand(sql, connection); dataReader = command.ExecuteReader(); while (dataReader.Read()) { Deadspot dspt = new Deadspot(); dspt.ProductID = dataReader.GetInt32(0); dspt.BusinessPlanId = dataReader.GetInt32(1); dspt.Spot = dataReader.GetString(2); list.Add(dspt); } dataReader.Close(); command.Dispose(); connection.Close(); } catch (Exception ex) { return(null); } return(list); }
// POST api/deadspot public Deadspot Post(Deadspot deadspot) { if (deadService.Insert(deadspot)) { return(deadspot); } return(null); }
// PUT api/deadspot/5 public Deadspot Put(int id, Deadspot newDeadspot) { newDeadspot.ProductID = id; if (deadService.SearchId(id).Count > 0) { if (deadService.Edit(newDeadspot)) { return(newDeadspot); } } return(null); }
// DELETE api/deadspot/5 public Deadspot Delete(int id) { Deadspot oldDeadspot = new Deadspot(); var data = deadService.SearchId(id); if (data.Count > 0) { oldDeadspot.SetDeadspot(data.ElementAt(0)); if (deadService.DeleteId(id)) { return(oldDeadspot); } } return(null); }
public bool Edit(Deadspot dspt) { sql = "UPDATE deadspots SET Products_productID='" + dspt.ProductID + "',business_plans_bpID='" + dspt.BusinessPlanId + "',deadSpot='" + dspt.Spot + "' WHERE Products_productID='" + dspt.ProductID + "' AND business_plans_bpID='" + dspt.BusinessPlanId + "'"; return(EditTable()); }
public bool Insert(Deadspot dspt) { sql = "INSERT INTO deadspots (Products_productID,business_plans_bpID,deadSpot) VALUES ('" + dspt.ProductID + "' , '" + dspt.BusinessPlanId + "' , '" + dspt.Spot + "')"; return(EditTable()); }