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