public List <AttachmentsBE> GetJobAttachmentsDAL(AttachmentsBE attachmentBE)
{
List <AttachmentsBE> AttachmentsBEList = new List <AttachmentsBE>();
try
{
DataTable dt = new DataTable();
int index = 0;
SqlParameter[] param = new SqlParameter[2];
param[index++] = new SqlParameter("@Action", attachmentBE.Action);
param[index++] = new SqlParameter("@JobId", attachmentBE.JobDetails.Id);
DataSet ds = SqlHelper.ExecuteDataset(DBConnection.Connection.ToString(), CommandType.StoredProcedure, "spJobAttachments", param);
dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
AttachmentsBE oNewAttachmentsBE = new AttachmentsBE();
oNewAttachmentsBE.JobDetails = new JobDetailsBE();
oNewAttachmentsBE.JobAttachmentId = Convert.ToInt32(dr["Id"].ToString());
oNewAttachmentsBE.JobDetails.Id = dr["JobId"] != DBNull.Value ? Convert.ToInt32(dr["JobId"]) : 0;
oNewAttachmentsBE.Name = Convert.ToString(dr["AttachmentName"]);
oNewAttachmentsBE.Path = Convert.ToString(dr["Path"]);
AttachmentsBEList.Add(oNewAttachmentsBE);
}
}
catch (Exception ex)
{
}
return(AttachmentsBEList);
}
private void GetJobAttachments()
{
AttachmentsBE attachmentsBE = new AttachmentsBE();
AttachmentsBAL attachmentBAL = new AttachmentsBAL();
attachmentsBE.JobDetails = new JobDetailsBE();
attachmentsBE.Action = "GetJobAttachmentsByJobId";
if (Request.QueryString["JobId"] != null)
{
attachmentsBE.JobDetails.Id = Convert.ToInt32(Request.QueryString["JobId"]);
}
List <AttachmentsBE> lstAttachments = attachmentBAL.GetJobAttachmentsBAL(attachmentsBE);
if (lstAttachments.Count > 0)
{
hdnAttachementCount.Value = Convert.ToString(lstAttachments.Count());
//attachment.InnerHtml = "Attachment " + lstAttachments.Count().ToString();
foreach (var item in lstAttachments)
{
HyperLink hplnk = new HyperLink();
hplnk.Text = item.Name;
hplnk.ID = Convert.ToString(item.JobAttachmentId);
hplnk.CssClass = "btn btn-link";
hplnk.NavigateUrl = "~/ModuleUI/DownloadAttachment.aspx?FilePath=" + item.Path + "&FileName=" + item.Name;
pnlAttachment.Controls.Add(hplnk);
}
}
}
public List <AttachmentsBE> GetJobAttachmentsBAL(AttachmentsBE attachmentBE)
{
List <AttachmentsBE> AttachmentBEList = new List <AttachmentsBE>();
try
{
AttachmentDAL attachmentDAL = new AttachmentDAL();
AttachmentBEList = attachmentDAL.GetJobAttachmentsDAL(attachmentBE);
attachmentDAL = null;
}
catch (Exception ex)
{
}
finally { }
return(AttachmentBEList);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
JobDetailsBE jobDetailsBE = new JobDetailsBE();
jobDetailsBE.Comments = new CommentsBE();
jobDetailsBE.Action = "AddJobComments";
jobDetailsBE.ClientId = Convert.ToInt32(Session["ClientId"]);
jobDetailsBE.Id = Convert.ToInt32(Request.QueryString["JobId"]);
jobDetailsBE.Comments.CreatedBy = Convert.ToInt32(Session["UserId"]);
jobDetailsBE.UserId = Convert.ToInt32(Session["UserId"]);
jobDetailsBE.Comments.Description = txtComments.Text.Trim();
AttachmentsColllection lstAttachments = new AttachmentsColllection();
if (FileUploadAttachments.HasFiles)
{
foreach (HttpPostedFile uploadedFile in FileUploadAttachments.PostedFiles)
{
AttachmentsBE attachments = new AttachmentsBE();
Guid random1 = Guid.NewGuid();
uploadedFile.SaveAs(System.IO.Path.Combine(Server.MapPath("~/Attachment/"), random1.ToString() + Path.GetExtension(uploadedFile.FileName)));
attachments.Name = uploadedFile.FileName;
attachments.Path = "/Attachment/" + random1.ToString() + Path.GetExtension(uploadedFile.FileName);
attachments.CommentId = null;
attachments.CreatedBy = Convert.ToInt32(Session["UserId"]);
lstAttachments.Add(attachments);
}
}
jobDetailsBE.Attachments = lstAttachments;
if (
Convert.ToString(Session["UserTypeCode"]).Equals(UserType.Enum.PM.ToString()) ||
Convert.ToString(Session["UserTypeCode"]).Equals(UserType.Enum.DM.ToString()) ||
Convert.ToString(Session["UserTypeCode"]).Equals(UserType.Enum.QA.ToString()) ||
Convert.ToString(Session["UserTypeCode"]).Equals(UserType.Enum.MEMBER.ToString()) ||
Convert.ToString(Session["UserTypeCode"]).Equals(UserType.Enum.QAHEAD)
)
{
if (divInternalUse.Visible)
{
jobDetailsBE.Comments.IsInternalUse = chkInternalUse.Checked ? true : false;
}
}
//if (Session["ClientId"] != null)
//{
// if (Convert.ToInt32(Session["ClientId"]) == 1)
// {
// if (ddlJobStatus.SelectedValue != null || ddlJobStatus.SelectedIndex != 0 || ddlJobStatus.SelectedIndex != -1)
// {
// jobDetailsBE.JobStatusId = Convert.ToInt32(ddlJobStatus.SelectedValue);
// }
// jobDetailsBE.AllocationDate = DateTime.Now;
// }
//}
string result = jobDetailsBAL.AddJobCommentsBAL(jobDetailsBE);
if (result == "1")
{
Response.Redirect("~/ModuleUI/JobList.aspx");
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
JobDetailsBE jobDetails = new JobDetailsBE();
jobDetails.ClientId = Convert.ToInt32(Session["ClientId"]);
jobDetails.PriorityID = ddlPriority.SelectedValue != null?Convert.ToInt32(ddlPriority.SelectedValue) : 0;
jobDetails.LastUpdatedDate = DateTime.Now;
jobDetails.LastCommentedDate = DateTime.Now;
jobDetails.QAUserId = null;
jobDetails.AllocationDate = DateTime.Now;
jobDetails.AllocatedToUser = null;
jobDetails.AllocatedToTeam = null;//?
jobDetails.JobTypeId = ddlJobType.SelectedValue != null?Convert.ToInt32(ddlJobType.SelectedValue) : 0;
jobDetails.CreatedBy = Convert.ToInt32(Session["UserId"]);
jobDetails.CreatedDate = DateTime.Now;
jobDetails.SubmittedByBranch = ddlBranch.SelectedValue != null?Convert.ToInt32(ddlBranch.SelectedValue) : 0;
jobDetails.SubmitBy = ddlUsers.SelectedValue != null?Convert.ToInt32(ddlUsers.SelectedValue) : 0;
jobDetails.SubmitDate = DateTime.Now;
Random random = new Random();
int rnt = random.Next(1000, 10000000);
jobDetails.JobNumber = "JBN" + rnt.ToString();
jobDetails.IsSystemDefined = false;
jobDetails.CommentDescription = txtComment.Text;
AttachmentsColllection lstAttachments = new AttachmentsColllection();
if (fileJobAttachment.HasFiles)
{
foreach (HttpPostedFile uploadedFile in fileJobAttachment.PostedFiles)
{
AttachmentsBE attachments = new AttachmentsBE();
Guid random1 = Guid.NewGuid();
uploadedFile.SaveAs(System.IO.Path.Combine(Server.MapPath("~/Attachment/"), random1.ToString() + Path.GetExtension(uploadedFile.FileName)));
attachments.Name = uploadedFile.FileName;
attachments.Path = "/Attachment/" + random1.ToString() + Path.GetExtension(uploadedFile.FileName);
attachments.CommentId = null;
attachments.CreatedBy = Convert.ToInt32(Session["UserId"]);
lstAttachments.Add(attachments);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", "alert('Please choose an attachment');", true);
return;
}
jobDetails.Attachments = lstAttachments;
string result = compassBAL.InsertIntoJobDetailsBAL(jobDetails);
if (result == "1")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", "alert('Submitted Succesfully'); window.location='/ModuleUI/JobList.aspx'", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", "alert('Job not submitted / Incomplete Information');", true);
return;
}
}
