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