public void UpdateCourseRegistrationInformtion(clsCourseRegistration CourseObj)
{
string connectionString = DataManager.OraConnString();
string updateQuery = @"UPDATE [tbl_Course_Name]
SET [CourseID] = '" + CourseObj.CourseId + "',[CourseName] = '" + CourseObj.CoursesName + "',[TracID] = '" + CourseObj.CourseTrac + "',[CourseFee]='" + CourseObj.Fee + "',[Doscount]='" + CourseObj.Discount + "' WHERE [ID] ='" + CourseObj.ID + "'";
DataManager.ExecuteNonQuery(connectionString, updateQuery);
}
public void DeleteCourseInformtion(clsCourseRegistration CourseObj)
{
string connectionString = DataManager.OraConnString();
string deleteQuery = @"UPDATE [tbl_Course_Name]
SET [DeleteBy]='" + CourseObj.LoginBy + "',[DeleteDate]=GETDATE() WHERE ID='" + CourseObj.ID + "' ";
DataManager.ExecuteNonQuery(connectionString, deleteQuery);
}
public void SaveCourseRegistrationInformtion(clsCourseRegistration CourseObj)
{
string connectionString = DataManager.OraConnString();
string insertQuery = @"INSERT INTO [tbl_Course_Name]
([CourseID] ,[CourseName] ,[TracID] ,[CourseFee] ,[Doscount],[EntryBy] ,[EntryDate])
VALUES('" + CourseObj.CourseId + "','" + CourseObj.CoursesName + "','" + CourseObj.CourseTrac + "','" + CourseObj.Fee + "','" + CourseObj.Discount + "','" + CourseObj.LoginBy + "',GETDATE())";
DataManager.ExecuteNonQuery(connectionString, insertQuery);
}
