public IEnumerable <demoModel> DataList() { List <demoModel> datalist = new List <demoModel>(); try { con.Open(); MySqlCommand cmd = new MySqlCommand("select * from test", con); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { demoModel demo = new demoModel(); demo.id = reader.GetInt16("ID"); demo.name = reader.GetString("Name"); demo.contact = reader.GetString("contact"); datalist.Add(demo); } con.Close(); return(datalist.AsEnumerable()); } catch (Exception e) { } return(datalist.AsEnumerable()); }
public IActionResult StringifyDemo() { demoModel Obj = new demoModel(); Obj.MyString = "TEST"; Obj.MyDate = DateTime.Now; Obj.MyNumber = 1234123; Obj.MyNull = null; return(Ok(new Stringify().fromObject(Obj))); }
public int Update(int id, [FromForm] demoModel data) { try { con.Open(); MySqlCommand cmd = new MySqlCommand("Update test set Name='" + data.name + "',contact='" + data.contact + "' where ID='" + id + "' ", con); cmd.ExecuteNonQuery(); con.Close(); return(1); } catch (Exception e) { return(0); } }
public int Insert([FromForm] demoModel data) { try { con.Open(); MySqlCommand cmd = new MySqlCommand("INSERT INTO test(Name,contact) VALUES('" + data.name + "','" + data.contact + "')", con); int i = cmd.ExecuteNonQuery(); con.Close(); string id = cmd.LastInsertedId.ToString(); return(Int32.Parse(id)); } catch (Exception e) { return(0); } }