public bool Update(CourseBase mClass) { bool mResult = false; SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["csSwim"].ConnectionString); string sql = "UPDATE Course SET Code = @Code, Name = @Name, Description = @Description, Fee = @Fee, Active = @Active " + "WHERE CourseId = @CourseId;"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.Add("@CourseId", SqlDbType.Int).Value = mClass.CourseId; cmd.Parameters.Add("@Code", SqlDbType.VarChar).Value = mClass.Code; cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = mClass.Name; cmd.Parameters.Add("@Description", SqlDbType.VarChar).Value = mClass.Description; cmd.Parameters.Add("@Fee", SqlDbType.Float).Value = mClass.Fee; cmd.Parameters.Add("@Active", SqlDbType.Bit).Value = mClass.Active; try { con.Open(); cmd.ExecuteNonQuery(); mResult = true; } catch (Exception ex) { Console.WriteLine(ex.ToString()); } finally { con.Close(); con.Dispose(); cmd.Dispose(); } return(mResult); }
public int Add(CourseBase mClass) { int CourseId = 0; SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["csSwim"].ConnectionString); string sql = "INSERT INTO Course (Code, Name, Description, Fee, Active)" + " VALUES (@Code, @Name, @Description, @Fee, @Active)" + " SELECT SCOPE_IDENTITY()"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.Add("@Code", SqlDbType.VarChar).Value = mClass.Code; cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = mClass.Name; cmd.Parameters.Add("@Description", SqlDbType.VarChar).Value = mClass.Description; cmd.Parameters.Add("@Fee", SqlDbType.Float).Value = mClass.Fee; cmd.Parameters.Add("@Active", SqlDbType.Bit).Value = mClass.Active; try { con.Open(); CourseId = Convert.ToInt32(cmd.ExecuteScalar()); } catch (Exception ex) { CourseId = -1; Console.WriteLine(ex.ToString()); } finally { con.Close(); con.Dispose(); cmd.Dispose(); } return(CourseId); }
private CourseBase Get(string WhereClause, params SqlParameter[] commandparameters) { CourseBase mClass = null; SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["csSwim"].ConnectionString); string sql = "SELECT db.CourseId, db.Code, db.Name, db.Description, db.Fee, db.Active, db.Created " + "FROM Course db " + WhereClause; SqlCommand cmd = new SqlCommand(sql, con); SqlDataReader rdr = null; foreach (var parameter in commandparameters) { cmd.Parameters.Add(parameter); } try { con.Open(); rdr = cmd.ExecuteReader(); if (rdr.Read()) { mClass = LoadRow(rdr); } } catch (Exception ex) { mClass = null; Console.WriteLine(ex.ToString()); } finally { con.Close(); con.Dispose(); cmd.Dispose(); } return(mClass); }
private void Populate(CourseBase mClass) { this.CourseId = mClass.CourseId; this.Code = mClass.Code; this.Name = mClass.Name; this.Description = mClass.Description; this.Fee = mClass.Fee; this.Active = mClass.Active; this.Created = mClass.Created; }