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