public static void DeleteStdWaiver(clsStdWaiver std)
{
String connectionString = DataManager.OraConnString();
SqlConnection sqlCon = new SqlConnection(connectionString);
string query = "delete from std_waiver where waive_sl= '" + std.WaiveSl + "' ";
DataManager.ExecuteNonQuery(connectionString, query);
}
public static void CreateStdWaiver(clsStdWaiver std)
{
String connectionString = DataManager.OraConnString();
SqlConnection sqlCon = new SqlConnection(connectionString);
string query = "insert into std_waiver(student_id,class_id,waive_year,waive_pct,exc_from,exc_to,waive_sl,remarks) values ('" + std.StudentId + "', '" + std.ClassId + "','" + std.WaiveYear + "', " +
"convert(numeric(5,2),'" + std.WaivePct + "'), convert(datetime,'" + std.ExcFrom + "',103), convert(datetime,'" + std.ExcTo + "',103), convert(numeric(18,0),'" + std.WaiveSl + "'),'" + std.Remarks + "') ";
DataManager.ExecuteNonQuery(connectionString, query);
}
public static void UpdateStdWaiver(clsStdWaiver std)
{
String connectionString = DataManager.OraConnString();
SqlConnection sqlCon = new SqlConnection(connectionString);
string query = "update std_waiver set student_id='" + std.StudentId + "',class_id='" + std.ClassId + "',remarks='" + std.Remarks + "',waive_year='" + std.WaiveYear + "', " +
" waive_pct='" + std.WaivePct + "',exc_from= convert(datetime,nullif('" + std.ExcFrom + "',''),103),exc_to= convert(datetime,nullif('" + std.ExcTo + "',''),103) " +
" where waive_sl= '" + std.WaiveSl + "'";
DataManager.ExecuteNonQuery(connectionString, query);
}
