public int Update(List <NOTEDC> objNOTEs)
{
int updatedCount = 0;
DBConnection objConnection = new DBConnection();
NOTEDA objNOTEDA = new NOTEDA();
try
{
objConnection.Open(true);
updatedCount = objNOTEDA.Update(objConnection, objNOTEs);
IsDirty = objNOTEDA.IsDirty;
if (IsDirty)
{
objConnection.Rollback();
}
else
{
objConnection.Commit();
}
}
catch (Exception ex)
{
objConnection.Rollback();
throw ex;
}
finally
{
objConnection.Close();
}
return(updatedCount);
}
public List <NOTEDC> LoadAll()
{
DBConnection objConnection = new DBConnection();
NOTEDA objNOTEDA = new NOTEDA();
List <NOTEDC> objNOTEDC = null;
try
{
objConnection.Open(false);
objNOTEDC = objNOTEDA.LoadAll(objConnection);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objNOTEDC);
}
public List <NOTEDC> LoadByPrimaryKey(int SCREEN_ID, int SCREEN_RECORD_ID)
{
DBConnection objConnection = new DBConnection();
NOTEDA objNOTEDA = new NOTEDA();
List <NOTEDC> objNOTEDC = null;
try
{
objConnection.Open(false);
objNOTEDC = objNOTEDA.LoadByPrimaryKey(objConnection, SCREEN_ID, SCREEN_RECORD_ID);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objNOTEDC);
}
public int Delete(List <NOTEDC> objNOTEs)
{
int deletedCount = 0;
DBConnection objConnection = new DBConnection();
NOTEDA objNOTEDA = new NOTEDA();
try
{
objConnection.Open(true);
deletedCount = objNOTEDA.Delete(objConnection, objNOTEs);
objConnection.Commit();
}
catch (Exception ex)
{
objConnection.Rollback();
throw ex;
}
finally
{
objConnection.Close();
}
return(deletedCount);
}
