private int Update(DBConnection Connection, PROJECT_ATTACHMENTDC objPROJECT_ATTACHMENT)
{
int updateCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_PROJECT_ATTACHMENTSUpdate");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_PROJECT_ID", DbType.Int32, objPROJECT_ATTACHMENT.PROJECT_ID);
dbCommandWrapper.AddInParameter("p_ATTACHMENT_ID", DbType.Int32, objPROJECT_ATTACHMENT.ATTACHMENT_ID);
if (Connection.Transaction != null)
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
if (updateCount == 0)
{
objPROJECT_ATTACHMENT.IsDirty = IsDirty = true;
}
return(updateCount);
}
public PROJECT_ATTACHMENTDC LoadByPrimaryKey(DBConnection Connection, int PROJECT_ID, int ATTACHMENT_ID)
{
PROJECT_ATTACHMENTDC objPROJECT_ATTACHMENT = new PROJECT_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);
IDataReader reader = null;
if (Connection.Transaction != null)
{
reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand);
}
objPROJECT_ATTACHMENT = FillObject(reader);
return(objPROJECT_ATTACHMENT);
}
private PROJECT_ATTACHMENTDC FillObject(DataRow row)
{
PROJECT_ATTACHMENTDC objPROJECT_ATTACHMENT = null;
objPROJECT_ATTACHMENT = new PROJECT_ATTACHMENTDC();
objPROJECT_ATTACHMENT.PROJECT_ID = (int)row["PROJECT_ID"];
objPROJECT_ATTACHMENT.ATTACHMENT_ID = (int)row["ATTACHMENT_ID"];
return(objPROJECT_ATTACHMENT);
}
private PROJECT_ATTACHMENTDC FillObject(IDataReader reader)
{
PROJECT_ATTACHMENTDC objPROJECT_ATTACHMENT = null;
if (reader != null && reader.Read())
{
objPROJECT_ATTACHMENT = new PROJECT_ATTACHMENTDC();
objPROJECT_ATTACHMENT.PROJECT_ID = (int)reader["PROJECT_ID"];
objPROJECT_ATTACHMENT.ATTACHMENT_ID = (int)reader["ATTACHMENT_ID"];
reader.Close();
reader.Dispose();
}
return(objPROJECT_ATTACHMENT);
}
public PROJECT_ATTACHMENTDC LoadByPrimaryKey(int PROJECT_ID, int ATTACHMENT_ID)
{
DBConnection objConnection = new DBConnection();
PROJECT_ATTACHMENTDA objPROJECT_ATTACHMENTDA = new PROJECT_ATTACHMENTDA();
PROJECT_ATTACHMENTDC objPROJECT_ATTACHMENTDC = null;
try
{
objConnection.Open(false);
objPROJECT_ATTACHMENTDC = objPROJECT_ATTACHMENTDA.LoadByPrimaryKey(objConnection, PROJECT_ID, ATTACHMENT_ID);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objPROJECT_ATTACHMENTDC);
}
