public IList <UseCaseAttachments> GetUseCaseAttachments(int intUseCaseID)
{
List <UseCaseAttachments> _retVal = new List <UseCaseAttachments>();
SqlConnection objCon = new SqlConnection();
SqlCommand objCom;
UseCaseAttachments attachments;
try
{
ConnectionString(objCon);
objCom = new SqlCommand("Select lngRecordID, Attachment, strFileType, strFileName from GIOS.GIOS_UUseCaseAttachment where intUseCaseID = @intUseCaseID", objCon);
objCom.Parameters.Add(new SqlParameter("@intUseCaseID", intUseCaseID));
objCon.Open();
SqlDataReader reader = objCom.ExecuteReader();
while (reader.Read())
{
attachments = new UseCaseAttachments();
attachments.lngRecordID = Convert.ToInt32(reader["lngRecordID"]);
attachments.strFileType = reader["strFileType"].ToString();
attachments.strFileName = reader["strFileName"].ToString();
attachments.Attachment = (byte[])reader["Attachment"];
_retVal.Add(attachments);
}
reader.Close();
objCon.Close();
return(_retVal);
}
catch (Exception ex)
{
return(_retVal);
}
}
public UseCaseAttachments FindUseCaseAttachment(int lngRecordID)
{
//List<UseCaseAttachments> _retVal = new List<UseCaseAttachments>();
SqlConnection objCon = new SqlConnection();
SqlCommand objCom;
UseCaseAttachments attachment = new UseCaseAttachments();;
try
{
ConnectionString(objCon);
objCom = new SqlCommand("Select Attachment, strFileType, strFileName from GIOS.GIOS_UUseCaseAttachment where lngRecordID = @lngRecordID", objCon);
objCom.Parameters.Add(new SqlParameter("@lngRecordID", lngRecordID));
objCon.Open();
SqlDataReader reader = objCom.ExecuteReader();
while (reader.Read())
{
attachment.strFileType = reader["strFileType"].ToString();
attachment.strFileName = reader["strFileName"].ToString();
attachment.Attachment = (byte[])reader["Attachment"];
}
reader.Close();
objCon.Close();
return(attachment);
}
catch (Exception ex)
{
return(attachment);
}
}
public void UploadFile(UseCaseAttachments attachments)
{
SqlConnection objCon = new SqlConnection();
SqlCommand objCom;
try
{
ConnectionString(objCon);
objCom = new SqlCommand("GIOS.GIOS_AddUseCaseAttachment", objCon);
objCom.CommandType = System.Data.CommandType.StoredProcedure;
objCom.Parameters.Add(new SqlParameter("@intUseCaseID", attachments.intUseCaseID));
objCom.Parameters.Add(new SqlParameter("@Attachment", attachments.Attachment));
objCom.Parameters.Add(new SqlParameter("@strFileType", attachments.strFileType));
objCom.Parameters.Add(new SqlParameter("@strFileName", attachments.strFileName));
objCom.Parameters.Add(new SqlParameter("@strUserID", attachments.strCreatorID));
objCon.Open();
objCom.ExecuteScalar();
objCon.Close();
}
catch (Exception ex)
{
}
}
