public void UpdateClassInformtion(ClassEnty aClassEntryObj) { string connectionString = DataManager.OraConnString(); string updateQuery = @"UPDATE [class_info] SET [class_name] = '" + aClassEntryObj.ClassName + "',[CollegeId] = '" + aClassEntryObj.CollegeName + "',[SemisterID] = '" + aClassEntryObj.SemisterName + "' WHERE [class_id] ='" + aClassEntryObj.ClassId + "'"; DataManager.ExecuteNonQuery(connectionString, updateQuery); }
public void DeleteClassInformtion(ClassEnty aClassEntryObj) { string connectionString = DataManager.OraConnString(); string deleteQuery = @"DELETE FROM [class_info] WHERE id='" + aClassEntryObj.ClassId + "' "; DataManager.ExecuteNonQuery(connectionString, deleteQuery); }
public void SaveClassInformtion(ClassEnty aClassEntryObj) { string connectionString = DataManager.OraConnString(); string insertQuery = @"INSERT INTO [class_info] (id,[class_id] ,[class_name],CollegeId,SemisterId) VALUES('" + aClassEntryObj.ClassId + "','" + aClassEntryObj.ClassId + "','" + aClassEntryObj.ClassName + "','" + aClassEntryObj.CollegeName + "','" + aClassEntryObj.SemisterName + "')"; DataManager.ExecuteNonQuery(connectionString, insertQuery); }