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