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