public ATTACHMENTDC LoadSingleByProjectId(DBConnection Connection, int PROJECT_ID, int ATTACHMENT_ID) { ATTACHMENTDC objATTACHMENT = new ATTACHMENTDC(); StringBuilder sql = new StringBuilder(); sql.Append("proc_PROJECT_ATTACHMENTSLoadByPrimaryKey"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_PROJECT_ID", DbType.Int32, PROJECT_ID); dbCommandWrapper.AddInParameter("p_ATTACHMENT_ID", DbType.Int32, ATTACHMENT_ID); DataSet ds = new DataSet(); if (Connection.Transaction != null) { ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction); } else { ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand); } foreach (DataRow drRow in ds.Tables[0].Rows) { objATTACHMENT = FillProjectAttachmentObject(drRow); } return(objATTACHMENT); }
private ATTACHMENTDC FillProjectAttachmentObject(DataRow row) { ATTACHMENTDC objATTACHMENT = null; objATTACHMENT = new ATTACHMENTDC(); objATTACHMENT.ATTACHMENT_ID = (int)row["ATTACHMENT_ID"]; objATTACHMENT.PERMIT_NUMBER = row["PERMIT_NUMBER"] == DBNull.Value ? "" : (string)row["PERMIT_NUMBER"]; objATTACHMENT.FILE_NAME = (String)row["FILE_NAME"]; objATTACHMENT.FILE_TITLE = (String)row["FILE_TITLE"]; objATTACHMENT.FILE_KEYWORD = row["FILE_KEYWORD"] == DBNull.Value ? null : (String)row["FILE_KEYWORD"]; objATTACHMENT.HYLAN_PROJECT_ID = row["HYLAN_PROJECT_ID"] == DBNull.Value ? null : (String)row["HYLAN_PROJECT_ID"]; if (row["JOB_FILE_NUMBER"] != DBNull.Value) { objATTACHMENT.JOB_FILE_NUMBER = Convert.ToString(row["JOB_FILE_NUMBER"]); } objATTACHMENT.PROJECT_ID = row["PROJECT_ID"] == DBNull.Value ? 0 : (int)row["PROJECT_ID"]; objATTACHMENT.FILE_TYPE = row["FILE_TYPE"] == DBNull.Value ? null : (String)row["FILE_TYPE"]; objATTACHMENT.FILE_SIZE = row["FILE_SIZE"] == DBNull.Value ? null : (String)row["FILE_SIZE"]; objATTACHMENT.Documentcategorydc.CATEGORY_CODE = (string)row["CATEGORY_CODE"]; objATTACHMENT.Documentcategorydc.CATEGORY_NAME = (string)row["CATEGORY_NAME"]; objATTACHMENT.Documentcategorydc.CATEGORY_TYPE = (int)row["CATEGORY_TYPE"]; objATTACHMENT.CREATED_ON = row["CREATED_ON"] == DBNull.Value ? (DateTime?)null : (DateTime)row["CREATED_ON"]; objATTACHMENT.CREATED_BY = (int)row["CREATED_BY"]; objATTACHMENT.MODIFIED_ON = row["MODIFIED_ON"] == DBNull.Value ? (DateTime?)null : (DateTime)row["MODIFIED_ON"]; objATTACHMENT.MODIFIED_ON1 = objATTACHMENT.MODIFIED_ON != null?Convert.ToDateTime(objATTACHMENT.MODIFIED_ON).ToString(EPay.Common.Constants.LongDateFormat) : null; objATTACHMENT.MODIFIED_BY = (int)row["MODIFIED_BY"]; objATTACHMENT.USER = (String)row["USER"]; objATTACHMENT.ENTITY_TYPE = "Project"; objATTACHMENT.LOCK_COUNTER = row["LOCK_COUNTER"] == DBNull.Value ? null : (int?)row["LOCK_COUNTER"]; return(objATTACHMENT); }
public ATTACHMENTDC GetLastInsertedAttachment(string entityType, int parentId, int recordId) { ATTACHMENTBL objAttachment = new ATTACHMENTBL(); ATTACHMENTDC objResult = new ATTACHMENTDC(); if (entityType != "" && recordId > 0) { if (entityType == "JOB") { objResult = objAttachment.LoadSingleByJobId(parentId, recordId); } else if (entityType == "PROJECT") { objResult = objAttachment.LoadSingleByProjectId(parentId, recordId); } else if (entityType == "PERMIT") { objResult = objAttachment.LoadSingleByPermitId(parentId, recordId); } else if (entityType == "Daily") { objResult = objAttachment.LoadSingleByDailyId(parentId, recordId); } } return(objResult); }
public ATTACHMENTDC LoadByPrimaryKey(DBConnection Connection, int ATTACHMENT_ID) { ATTACHMENTDC objATTACHMENT = new ATTACHMENTDC(); StringBuilder sql = new StringBuilder(); sql.Append("proc_ATTACHMENTSLoadByPrimaryKey"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_ATTACHMENT_ID", DbType.Int32, ATTACHMENT_ID); IDataReader reader = null; if (Connection.Transaction != null) { reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand, Connection.Transaction); } else { reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand); } objATTACHMENT = FillObject(reader); return(objATTACHMENT); }
private ATTACHMENTDC FillObject(IDataReader reader) { ATTACHMENTDC objATTACHMENT = null; if (reader != null && reader.Read()) { DataTable schemaTable = reader.GetSchemaTable(); objATTACHMENT = new ATTACHMENTDC(); objATTACHMENT.ATTACHMENT_ID = (int)reader["ATTACHMENT_ID"]; objATTACHMENT.FILE_NAME = (String)reader["FILE_NAME"]; objATTACHMENT.FILE_TITLE = (String)reader["FILE_TITLE"]; objATTACHMENT.FILE_KEYWORD = reader["FILE_KEYWORD"] == DBNull.Value ? null : (String)reader["FILE_KEYWORD"]; objATTACHMENT.HYLAN_PROJECT_ID = reader["HYLAN_PROJECT_ID"] == DBNull.Value ? null : (String)reader["HYLAN_PROJECT_ID"]; objATTACHMENT.JOB_FILE_NUMBER = Convert.ToString(reader["JOB_FILE_NUMBER"]); objATTACHMENT.FILE_TYPE = reader["FILE_TYPE"] == DBNull.Value ? null : (String)reader["FILE_TYPE"]; objATTACHMENT.FILE_SIZE = reader["FILE_SIZE"] == DBNull.Value ? null : (String)reader["FILE_SIZE"]; objATTACHMENT.DOCUMENT_CATEGORY = (string)reader["DOCUMENT_CATEGORY"]; objATTACHMENT.Documentcategorydc.CATEGORY_TYPE = (int)reader["CATEGORY_TYPE"]; objATTACHMENT.Documentcategorydc.CATEGORY_NAME = (string)reader["CATEGORY_NAME"]; objATTACHMENT.Documentcategorydc.CATEGORY_CODE = (string)reader["CATEGORY_CODE"]; objATTACHMENT.CREATED_ON = (DateTime)reader["CREATED_ON"]; objATTACHMENT.CREATED_BY = (int)reader["CREATED_BY"]; objATTACHMENT.MODIFIED_ON = (DateTime)reader["MODIFIED_ON"]; objATTACHMENT.MODIFIED_ON1 = objATTACHMENT.MODIFIED_ON != null?Convert.ToDateTime(objATTACHMENT.MODIFIED_ON).ToString(EPay.Common.Constants.LongDateFormat) : null; objATTACHMENT.MODIFIED_BY = (int)reader["MODIFIED_BY"]; objATTACHMENT.LOCK_COUNTER = reader["LOCK_COUNTER"] == DBNull.Value ? null : (int?)reader["LOCK_COUNTER"]; reader.Close(); reader.Dispose(); } return(objATTACHMENT); }
private int Delete(DBConnection Connection, ATTACHMENTDC objATTACHMENT) { int deleteCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_ATTACHMENTSDelete"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_ATTACHMENT_ID", DbType.Int32, objATTACHMENT.ATTACHMENT_ID); dbCommandWrapper.AddInParameter("p_IS_DELETED", DbType.Int32, objATTACHMENT.IS_DELETED); dbCommandWrapper.AddInParameter("p_MODIFIED_ON", DbType.DateTime, objATTACHMENT.MODIFIED_ON); dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objATTACHMENT.MODIFIED_BY); dbCommandWrapper.AddInParameter("p_LOCK_COUNTER", DbType.Int32, objATTACHMENT.LOCK_COUNTER); if (Connection.Transaction != null) { deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction); } else { deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand); } return(deleteCount); }
public static JOB_ATTACHMENTDC ToDataModel(ATTACHMENTDC attachmentDC) { return(new JOB_ATTACHMENTDC { ATTACHMENT_ID = attachmentDC.ATTACHMENT_ID, JOB_ID = attachmentDC.PARENT_ID }); }
public static DAILY_ATTACHMENTDC ToDataModel(ATTACHMENTDC attachmentDC) { return(new DAILY_ATTACHMENTDC { ATTACHMENT_ID = attachmentDC.ATTACHMENT_ID, DAILY_ID = attachmentDC.PARENT_ID }); }
public static PROJECT_ATTACHMENTDC ToDataModel(ATTACHMENTDC attachmentDC) { return(new PROJECT_ATTACHMENTDC { ATTACHMENT_ID = attachmentDC.ATTACHMENT_ID, PROJECT_ID = attachmentDC.PARENT_ID }); }
private ATTACHMENTDC FillDailyAttachmentObject(DataRow row) { ATTACHMENTDC objATTACHMENT = null; objATTACHMENT = new ATTACHMENTDC(); objATTACHMENT.ATTACHMENT_ID = (int)row["ATTACHMENT_ID"]; objATTACHMENT.DAILY_ID = (int)row["DAILY_ID"]; // objATTACHMENT.PERMIT_NUMBER = row["PERMIT_NUMBER"] == DBNull.Value ? "" : (string)row["PERMIT_NUMBER"]; ; objATTACHMENT.FILE_NAME = (String)row["FILE_NAME"]; objATTACHMENT.FILE_TITLE = (String)row["FILE_TITLE"]; objATTACHMENT.FILE_KEYWORD = row["FILE_KEYWORD"] == DBNull.Value ? null : (String)row["FILE_KEYWORD"]; objATTACHMENT.HYLAN_PROJECT_ID = row["HYLAN_PROJECT_ID"] == DBNull.Value ? null : (String)row["HYLAN_PROJECT_ID"]; if (row["JOB_FILE_NUMBER"] != DBNull.Value) { objATTACHMENT.JOB_FILE_NUMBER = Convert.ToString(row["JOB_FILE_NUMBER"]); } objATTACHMENT.PARENT_ID = row["DAILY_ID"] == DBNull.Value ? 0 : (int)row["DAILY_ID"]; objATTACHMENT.JOB_ID = row["JOB_ID"] == DBNull.Value ? 0 : (int)row["JOB_ID"]; objATTACHMENT.PROJECT_ID = row["PROJECT_ID"] == DBNull.Value ? 0 : (int)row["PROJECT_ID"]; objATTACHMENT.FILE_TYPE = row["FILE_TYPE"] == DBNull.Value ? null : (String)row["FILE_TYPE"]; objATTACHMENT.FILE_SIZE = row["FILE_SIZE"] == DBNull.Value ? null : (String)row["FILE_SIZE"]; objATTACHMENT.Documentcategorydc.CATEGORY_CODE = (string)row["CATEGORY_CODE"]; objATTACHMENT.Documentcategorydc.CATEGORY_NAME = (string)row["CATEGORY_NAME"]; objATTACHMENT.Documentcategorydc.CATEGORY_TYPE = (int)row["CATEGORY_TYPE"]; objATTACHMENT.CREATED_ON = row["CREATED_ON"] == DBNull.Value ? (DateTime?)null : (DateTime)row["CREATED_ON"]; objATTACHMENT.CREATED_BY = (int)row["CREATED_BY"]; objATTACHMENT.MODIFIED_ON = row["MODIFIED_ON"] == DBNull.Value ? (DateTime?)null : (DateTime)row["MODIFIED_ON"]; objATTACHMENT.MODIFIED_ON1 = objATTACHMENT.MODIFIED_ON != null?Convert.ToDateTime(objATTACHMENT.MODIFIED_ON).ToString(EPay.Common.Constants.LongDateFormat) : null; objATTACHMENT.MODIFIED_BY = (int)row["MODIFIED_BY"]; objATTACHMENT.USER = (String)row["USER"]; objATTACHMENT.ENTITY_TYPE = "Daily"; objATTACHMENT.LOCK_COUNTER = row["LOCK_COUNTER"] == DBNull.Value ? null : (int?)row["LOCK_COUNTER"]; //if (row.Table.Columns.Contains("DOT_TRACKING_NUMBER")) //{ // objATTACHMENT.DOT_TRACKING_NUMBER = Convert.ToString(row["DOT_TRACKING_NUMBER"]); //} //if (row.Table.Columns.Contains("PERMIT_NUMBER_TEXT")) //{ // objATTACHMENT.PERMIT_NUMBER_TEXT = Convert.ToString(row["PERMIT_NUMBER_TEXT"]); //} return(objATTACHMENT); }
private int Update(DBConnection Connection, ATTACHMENTDC objATTACHMENT) { int updateCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_ATTACHMENTSUpdate"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_ATTACHMENT_ID", DbType.Int32, objATTACHMENT.ATTACHMENT_ID); dbCommandWrapper.AddInParameter("p_FILE_TITLE", DbType.String, objATTACHMENT.FILE_TITLE); dbCommandWrapper.AddInParameter("p_FILE_KEYWORD", DbType.String, objATTACHMENT.FILE_KEYWORD); dbCommandWrapper.AddInParameter("p_DOCUMENT_CATEGORY", DbType.String, objATTACHMENT.Documentcategorydc.CATEGORY_CODE); dbCommandWrapper.AddInParameter("p_MODIFIED_ON", DbType.DateTime, objATTACHMENT.MODIFIED_ON); dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objATTACHMENT.MODIFIED_BY); dbCommandWrapper.AddInParameter("p_LOCK_COUNTER", DbType.Int32, objATTACHMENT.LOCK_COUNTER); try { if (Connection.Transaction != null) { updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction); } else { updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand); } if (updateCount == 0) { objATTACHMENT.IsDirty = IsDirty = true; throw new Exception(Constants.ConcurrencyMessageSingleRow); } } catch (Exception exp) { objATTACHMENT.SetError(exp); throw exp; } return(updateCount); }
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 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 ATTACHMENTDC Insert(DBConnection Connection, ATTACHMENTDC objATTACHMENT) { int insertCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_ATTACHMENTSInsert"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddOutParameter("p_ATTACHMENT_ID", DbType.Int32, objATTACHMENT.ATTACHMENT_ID); dbCommandWrapper.AddInParameter("p_FILE_NAME", DbType.String, objATTACHMENT.UPDATED_FILE_NAME); dbCommandWrapper.AddInParameter("p_FILE_TITLE", DbType.String, objATTACHMENT.FILE_TITLE); dbCommandWrapper.AddInParameter("p_FILE_KEYWORD", DbType.String, objATTACHMENT.FILE_KEYWORD); dbCommandWrapper.AddInParameter("p_FILE_TYPE", DbType.String, objATTACHMENT.FILE_TYPE); dbCommandWrapper.AddInParameter("p_FILE_SIZE", DbType.String, objATTACHMENT.FILE_SIZE); dbCommandWrapper.AddInParameter("p_DOCUMENT_CATEGORY", DbType.String, objATTACHMENT.Documentcategorydc.CATEGORY_CODE); dbCommandWrapper.AddInParameter("p_CREATED_ON", DbType.DateTime, objATTACHMENT.CREATED_ON); dbCommandWrapper.AddInParameter("p_CREATED_BY", DbType.Int32, objATTACHMENT.CREATED_BY); dbCommandWrapper.AddInParameter("p_MODIFIED_ON", DbType.DateTime, objATTACHMENT.MODIFIED_ON); dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objATTACHMENT.MODIFIED_BY); dbCommandWrapper.AddInParameter("p_Is_DELETED", DbType.Boolean, objATTACHMENT.IS_DELETED); dbCommandWrapper.AddInParameter("p_SCREEN_ID", DbType.Int32, objATTACHMENT.SCREEN_ID); dbCommandWrapper.AddInParameter("p_SCREEN_RECORD_ID", DbType.Int32, objATTACHMENT.SCREEN_RECORD_ID); if (Connection.Transaction != null) { insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction); } else { insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand); } objATTACHMENT.ATTACHMENT_ID = (int)dbCommandWrapper.DBCommand.Parameters["@p_ATTACHMENT_ID"].Value; return(objATTACHMENT); }
public static ATTACHMENTDC ToDataModel(CustomMultipartFormDataStreamProvider streamProvider, int index) { JavaScriptSerializer serializer = new JavaScriptSerializer(); var attachmentDC = new ATTACHMENTDC(); attachmentDC.CREATED_BY = Convert.ToInt32(streamProvider.FormData["attachmentDCModels[" + index + "][CREATED_BY]"]); attachmentDC.CREATED_ON = DateTime.Now; //attachmentDC.MODIFIED_ON = DateTime.Now; attachmentDC.MODIFIED_BY = Convert.ToInt32(streamProvider.FormData["attachmentDCModels[" + index + "][MODIFIED_BY]"]); attachmentDC.DOCUMENT_CATEGORY = streamProvider.FormData["attachmentDCModels[" + index + "][DOCUMENT_CATEGORY]"]; attachmentDC.Documentcategorydc = //serializer.Deserialize<DOCUMENTCATEGORYDC>(streamProvider.FormData["attachmentDCModels[" + index + "][Documentcategorydc]"]) ?? new DOCUMENTCATEGORYDC { CATEGORY_CODE = null, CATEGORY_NAME = null }; attachmentDC.FILE_NAME = streamProvider.FormData["attachmentDCModels[" + index + "][FILE_NAME]"]; attachmentDC.FILE_TYPE = streamProvider.FormData["attachmentDCModels[" + index + "][FILE_TYPE]"]; attachmentDC.FILE_SIZE = streamProvider.FormData["attachmentDCModels[" + index + "][FILE_SIZE]"]; attachmentDC.FILE_TITLE = streamProvider.FormData["attachmentDCModels[" + index + "][FILE_TITLE]"]; attachmentDC.FILE_KEYWORD = streamProvider.FormData["attachmentDCModels[" + index + "][FILE_KEYWORD]"]; attachmentDC.PARENT_ID = Convert.ToInt32(streamProvider.FormData["attachmentDCModels[" + index + "][PARENT_ID]"]); attachmentDC.ENTITY_TYPE = streamProvider.FormData["attachmentDCModels[" + index + "][ENTITY_TYPE]"]; attachmentDC.SCREEN_ID = Convert.ToInt32(streamProvider.FormData["attachmentDCModels[" + index + "][SCREEN_ID]"]); attachmentDC.SCREEN_RECORD_ID = Convert.ToInt32(streamProvider.FormData["attachmentDCModels[" + index + "][SCREEN_RECORD_ID]"]); attachmentDC.PROJECT_ID = streamProvider.FormData["attachmentDCModels[" + index + "][PROJECT_ID]"] == null || streamProvider.FormData["attachmentDCModels[" + index + "][PROJECT_ID]"] == "null" ? 0 : Convert.ToInt32(streamProvider.FormData["attachmentDCModels[" + index + "][PROJECT_ID]"]); attachmentDC.JOB_ID = streamProvider.FormData["attachmentDCModels[" + index + "][JOB_ID]"] == null || streamProvider.FormData["attachmentDCModels[" + index + "][JOB_ID]"] == "null" ? 0 : Convert.ToInt32(streamProvider.FormData["attachmentDCModels[" + index + "][JOB_ID]"]); attachmentDC.DAILY_ID = Convert.ToInt32(streamProvider.FormData["attachmentDCModels[" + index + "][DAILY_ID]"]); attachmentDC.IS_DELETED = false; return(attachmentDC); }
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); }