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