public List <Venus> GetAllVenus(string userID)
{
List <Venus> listMod = new List <Venus>();
MySqlConnection con = new MySqlConnection(DbCon.connectionString);
string sqlInsert = "SELECT `id`, `venuname`,description FROM `venus` WHERE `active` = 1";
MySqlDataReader dr = null;
MySqlCommand cmd;
con.Open();
cmd = new MySqlCommand(sqlInsert, con);
dr = cmd.ExecuteReader();
while (dr.Read()) //iterate through the records in the result dataset
{
Venus Mod = new Venus();
Mod.ID = dr.GetInt32(0);
Mod.VenuName = dr.GetString(1);
Mod.Description = dr.GetString(2);
listMod.Add(Mod);
}
con.Close();
return(listMod);
}
public bool UpdateVenus(Venus vr, string userID)
{
bool result = false;
MySqlConnection con = new MySqlConnection(DbCon.connectionString);
string sqlInsert = "UPDATE `venus` SET `venuname`=@venuname,description =@description WHERE id = @id";
con.Open();
MySqlCommand cmd = new MySqlCommand(sqlInsert, con);
cmd.Parameters.AddWithValue("@id", vr.ID);
cmd.Parameters.AddWithValue("@description", vr.Description);
cmd.Parameters.AddWithValue("@venuname", vr.VenuName);
if (cmd.ExecuteNonQuery() > 0)
{
result = true;
}
con.Close();
return(result);
}
public bool AddVenus(Venus vr, string userID)
{
bool result = false;
MySqlConnection con = new MySqlConnection(DbCon.connectionString);
string sqlInsert = "INSERT INTO `venus`(`venuname`,description) VALUES (@venuname,@description)";
con.Open();
MySqlCommand cmd = new MySqlCommand(sqlInsert, con);
cmd.Parameters.AddWithValue("@venuid", vr.VenuName);
cmd.Parameters.AddWithValue("@description", vr.Description);
if (cmd.ExecuteNonQuery() > 0)
{
result = true;
}
con.Close();
return(result);
}
