/// <summary>
/// AddIssueAttachment
/// </summary>
/// <param name="issueAttachment">IssueAttachment</param>
/// <returns>bool</returns>
public static bool AddIssueAttachment(IssueAttachment issueAttachment)
{
try
{
return IssueDAL.AddIssueAttachment(issueAttachment);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// btnUpload_Click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnUpload_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(FileUpload1.FileName) && !String.IsNullOrEmpty(Request.QueryString["IssueID"]))
{
// Check if file is allowed
if (isValidFile(FileUpload1.FileName))
{
// instantiate an IssueAttachment object.
var issueAttachment = new IssueAttachment();
issueAttachment.FileName = FileUpload1.FileName;
issueAttachment.Description = txtDescription.Text;
issueAttachment.EntryDate = DateTime.Now;
issueAttachment.IssueID = Int32.Parse(Request.QueryString["IssueID"]);
issueAttachment.MimeType = FileUpload1.PostedFile.ContentType;
// Read the file and convert it to Byte Array
Stream fs = FileUpload1.PostedFile.InputStream;
BinaryReader br = new BinaryReader(fs);
Byte[] bytes = br.ReadBytes((Int32)fs.Length);
issueAttachment.FileData = bytes;
// Get the userID for the logged in user.
var name = HttpContext.Current.User.Identity.Name;
var user = UserBLL.GetUserGivenLogonName(name);
issueAttachment.UserID = user.UserId;
// upload file
IssueBLL.AddIssueAttachment(issueAttachment);
}
else
{
// not valid file type. display error message.
lblErrorMessage.Text = "ERROR: Not a valid file type.";
}
}
}
catch (Exception ex)
{
lblErrorMessage.Text = "ERROR: " + ex.Message.ToString();
}
// set the tab selection hidden field to issue attachments - tab id 2.
Response.Redirect("~/IssueDetails.aspx?tab=2&IssueID=" + Request.QueryString["IssueID"]);
}
/// <summary>
/// AddIssueAttachment
/// </summary>
/// <param name="issueAttachment">IssueAttachment</param>
/// <returns>bool</returns>
public static bool AddIssueAttachment(IssueAttachment issueAttachment)
{
var returnValue = false;
try
{
using (var db = new ProjectManagerEntities())
{
db.Connection.Open();
var ia = new IssueAttachmentDAL();
ia.Filename = issueAttachment.FileName;
ia.EntryDate = issueAttachment.EntryDate;
ia.Description = issueAttachment.Description;
ia.IssueID = issueAttachment.IssueID;
ia.UserID = issueAttachment.UserID;
ia.MimeType = issueAttachment.MimeType;
ia.FileData = issueAttachment.FileData;
// save issue Attachment.
db.IssueAttachmentDALs.AddObject(ia);
db.SaveChanges();
}
returnValue = true;
}
catch (Exception)
{
throw;
}
return returnValue;
}
/// <summary>
/// GetIssueAttachmentsList
/// </summary>
/// <param name="issueID"></param>
/// <returns></returns>
public static List<IssueAttachment> GetIssueAttachmentsList(int issueID)
{
List<IssueAttachment> issueAttachments = new List<IssueAttachment>();
try
{
using (var db = new ProjectManagerEntities())
{
// get the list of file attachments for a specific Issue.
var query = from i in db.IssueAttachmentDALs
where i.IssueID == issueID
select i;
foreach (var item in query)
{
// build the issue attachment object.
var fileAttachment = new IssueAttachment()
{
IssueAttachmentID = item.IssueAttachmentID,
FileName = item.Filename,
EntryDate = item.EntryDate,
Description = item.Description,
UserID = item.UserID,
IssueID = item.IssueID,
MimeType = item.MimeType
};
issueAttachments.Add(fileAttachment);
}
}
}
catch (Exception)
{
throw;
}
return issueAttachments;
}
/// <summary>
/// GetIssueAttachment
/// </summary>
/// <param name="issueAttachmentID">int</param>
/// <returns></returns>
public static IssueAttachment GetIssueAttachment(int issueAttachmentID)
{
var issueAttachments = new IssueAttachment();
try
{
using (var db = new ProjectManagerEntities())
{
// get the file attachment.
var query = (from i in db.IssueAttachmentDALs
where i.IssueAttachmentID == issueAttachmentID
select i).First();
if (query != null)
{
issueAttachments.IssueID = query.IssueAttachmentID;
issueAttachments.FileName = query.Filename;
issueAttachments.EntryDate = query.EntryDate;
issueAttachments.Description = query.Description;
issueAttachments.IssueID = query.IssueID;
issueAttachments.UserID = query.UserID;
issueAttachments.MimeType = query.MimeType;
issueAttachments.FileData = query.FileData;
}
}
}
catch (Exception)
{
throw;
}
return issueAttachments;
}
