public int Update(List <ATTACHMENTDC> objATTACHMENTs)
{
int updatedCount = 0;
DBConnection objConnection = new DBConnection();
ATTACHMENTDA objATTACHMENTDA = new ATTACHMENTDA();
try
{
objConnection.Open(true);
updatedCount = objATTACHMENTDA.Update(objConnection, objATTACHMENTs);
IsDirty = objATTACHMENTDA.IsDirty;
if (IsDirty)
{
objConnection.Rollback();
}
else
{
objConnection.Commit();
}
}
catch (Exception ex)
{
objConnection.Rollback();
throw ex;
}
finally
{
objConnection.Close();
}
return(updatedCount);
}
public ATTACHMENTDC LoadSingleByJobId(int JOB_ID, int ATTACHMENT_ID)
{
DBConnection objConnection = new DBConnection();
ATTACHMENTDA objATTACHMENTDA = new ATTACHMENTDA();
ATTACHMENTDC objATTACHMENTDC = null;
try
{
objConnection.Open(false);
objATTACHMENTDC = objATTACHMENTDA.LoadSingleByJobId(objConnection, JOB_ID, ATTACHMENT_ID);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objATTACHMENTDC);
}
public List <ATTACHMENTDC> LoadAllDailyAttachments(string projectIDs = "All", string attachmentTypeIDs = "All")
{
DBConnection objConnection = new DBConnection();
ATTACHMENTDA objATTACHMENTDA = new ATTACHMENTDA();
List <ATTACHMENTDC> objATTACHMENTDC = null;
try
{
objConnection.Open(false);
objATTACHMENTDC = objATTACHMENTDA.LoadAllDailyAttachments(objConnection, projectIDs, attachmentTypeIDs);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objATTACHMENTDC);
}
public List <DOCUMENTCATEGORYDC> LoaddocumentCategories(int CATEGORY_ID)
{
DBConnection objConnection = new DBConnection();
ATTACHMENTDA objATTACHMENTDA = new ATTACHMENTDA();
List <DOCUMENTCATEGORYDC> objDOCUMENTCATEGORYDC = null;
try
{
objConnection.Open(false);
objDOCUMENTCATEGORYDC = objATTACHMENTDA.LoaddocumentCategories(objConnection, CATEGORY_ID);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objDOCUMENTCATEGORYDC);
}
public List <ATTACHMENTDC> LoadByProjectId(int PROJECT_ID)
{
DBConnection objConnection = new DBConnection();
ATTACHMENTDA objATTACHMENTDA = new ATTACHMENTDA();
List <ATTACHMENTDC> objATTACHMENTDC = null;
try
{
objConnection.Open(false);
objATTACHMENTDC = objATTACHMENTDA.LoadByProjectId(objConnection, PROJECT_ID);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objATTACHMENTDC);
}
public ATTACHMENTDC LoadByPrimaryKey(int ATTACHMENT_ID)
{
DBConnection objConnection = new DBConnection();
ATTACHMENTDA objATTACHMENTDA = new ATTACHMENTDA();
ATTACHMENTDC objATTACHMENTDC = null;
try
{
objConnection.Open(false);
objATTACHMENTDC = objATTACHMENTDA.LoadByPrimaryKey(objConnection, ATTACHMENT_ID);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objATTACHMENTDC);
}
public List <ATTACHMENTDC> LoadAll()
{
DBConnection objConnection = new DBConnection();
ATTACHMENTDA objATTACHMENTDA = new ATTACHMENTDA();
List <ATTACHMENTDC> objATTACHMENTDC = null;
try
{
objConnection.Open(false);
objATTACHMENTDC = objATTACHMENTDA.LoadAll(objConnection);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objATTACHMENTDC);
}
public int Delete(List <ATTACHMENTDC> objATTACHMENTs)
{
int deletedCount = 0;
DBConnection objConnection = new DBConnection();
ATTACHMENTDA objATTACHMENTDA = new ATTACHMENTDA();
try
{
objConnection.Open(true);
deletedCount = objATTACHMENTDA.Delete(objConnection, objATTACHMENTs);
objConnection.Commit();
}
catch (Exception ex)
{
objConnection.Rollback();
throw ex;
}
finally
{
objConnection.Close();
}
return(deletedCount);
}
public List <ATTACHMENTDC> Insert(List <ATTACHMENTDC> objATTACHMENTs)
{
List <ATTACHMENTDC> attachmentsList = new List <ATTACHMENTDC>();
DBConnection objConnection = new DBConnection();
ATTACHMENTDA objATTACHMENTDA = new ATTACHMENTDA();
try
{
var attachments = SetNecessaryFields(objATTACHMENTs);
objConnection.Open(true);
attachmentsList = objATTACHMENTDA.Insert(objConnection, attachments);
objConnection.Commit();
}
catch (Exception ex)
{
objConnection.Rollback();
throw ex;
}
finally
{
objConnection.Close();
}
return(attachmentsList);
}
public ATTACHMENTDC Insert(ATTACHMENTDC objATTACHMENT)
{
ATTACHMENTDC addedAttachmentdc;
DBConnection objConnection = new DBConnection();
ATTACHMENTDA objATTACHMENTDA = new ATTACHMENTDA();
try
{
objConnection.Open(true);
objATTACHMENT.FILE_SIZE = TransformFileSize(objATTACHMENT.FILE_SIZE);
addedAttachmentdc = objATTACHMENTDA.Insert(objConnection, objATTACHMENT);
objConnection.Commit();
}
catch (Exception ex)
{
objConnection.Rollback();
throw ex;
}
finally
{
objConnection.Close();
}
return(addedAttachmentdc);
}
