public List <GradeSystem> GetAllGradeSystem(string userID) { List <GradeSystem> retVal = new List <GradeSystem>(); MySqlConnection con = new MySqlConnection(DbCon.connectionString); string sqlInsert = "SELECT `gsid`, `gstype`, `gstypeid` FROM `gradesystem`"; MySqlDataReader dr = null; MySqlCommand cmd; con.Open(); cmd = new MySqlCommand(sqlInsert, con); //cmd.Parameters.AddWithValue("@gsvgsid", gsgsId); dr = cmd.ExecuteReader(); while (dr.Read()) //iterate through the records in the result dataset { GradeSystem Mod = new GradeSystem(); Mod.GsId = dr.GetInt32(0); Mod.GsType = dr.GetString(1); Mod.GsTypeId = dr.GetInt32(2); retVal.Add(Mod); } con.Close(); return(retVal); }
public bool ExitGradeSystem(GradeSystem gs, string userID) { bool result = false; //int rows = 0; MySqlConnection con = new MySqlConnection(DbCon.connectionString); MySqlDataReader dr = null; MySqlCommand cmd = null; string sqlUpdate = "SELECT `gsid`, `gstype`, `gstypeid` FROM `gradesystem` WHERE gstype = @gstype AND `gstypeid` = @gstypeid"; con.Open(); cmd = new MySqlCommand(sqlUpdate, con); cmd.Parameters.AddWithValue("@gstype", gs.GsType); cmd.Parameters.AddWithValue("@gstypeid", gs.GsTypeId); dr = cmd.ExecuteReader(); if (dr.HasRows) { result = true; } con.Close(); return(result); }
public GradeSystem GetGradeSystem(int Id, string userID) { GradeSystem Mod = new GradeSystem(); MySqlConnection con = new MySqlConnection(DbCon.connectionString); string sqlInsert = "SELECT gradesystem.gsid,gradesystem.gstype,gradesystem.gstypeid,gradesystemtype.type FROM gradesystem INNER JOIN gradesystemtype ON gradesystem.gstypeid = gradesystemtype.id WHERE gradesystem.gsid = @gsid "; MySqlDataReader dr = null; MySqlCommand cmd; con.Open(); cmd = new MySqlCommand(sqlInsert, con); cmd.Parameters.AddWithValue("@gsid", Id); dr = cmd.ExecuteReader(); while (dr.Read()) //iterate through the records in the result dataset { // GradeSystem Mod = new GradeSystem(); Mod.GsId = dr.GetInt32(0); Mod.GsType = dr.GetString(1); Mod.GsTypeId = dr.GetInt32(2); Mod.xGingsType = dr.GetString(3); } con.Close(); return(Mod); }
public bool AddGradeSystem(GradeSystem fp, string userID) { bool result = false; MySqlConnection con = new MySqlConnection(DbCon.connectionString); string sqlInsert = "INSERT INTO `gradesystem`(`gstype`, `gstypeid`) VALUES (@gstype,@gstypeid)"; con.Open(); MySqlCommand cmd = new MySqlCommand(sqlInsert, con); cmd.Parameters.AddWithValue("@gstype", fp.GsType); cmd.Parameters.AddWithValue("@gstypeid", fp.GsTypeId); if (cmd.ExecuteNonQuery() > 0) { result = true; } con.Close(); return(result); }
public bool UpdateGradeSystem(GradeSystem fp, string userID) { bool result = false; MySqlConnection con = new MySqlConnection(DbCon.connectionString); string sqlInsert = "UPDATE `gradesystem` SET `gstype`=@gstype,`gstypeid`=@gstypeid WHERE gsvid = @gsvid"; con.Open(); MySqlCommand cmd = new MySqlCommand(sqlInsert, con); cmd.Parameters.AddWithValue("@gstype", fp.GsType); cmd.Parameters.AddWithValue("@gstypeid", fp.GsTypeId); cmd.Parameters.AddWithValue("@gsid", fp.GsId); if (cmd.ExecuteNonQuery() > 0) { result = true; } con.Close(); return(result); }