private void GetJobDetailsForHOUserType()
{
JobDetailsBE obJobDetailsBE = new JobDetailsBE();
obJobDetailsBE.Action = "GetJobDetailsById";
if (Request.QueryString["JobId"] != null)
{
obJobDetailsBE.Id = Convert.ToInt32(Request.QueryString["JobId"]);
}
List <JobDetailsBE> lstDetails = jobDetailsBAL.GetJobDetailsBAL(obJobDetailsBE);
if (lstDetails != null && lstDetails.Count > 0)
{
divInternalUse.Visible = false;
txtJobNumber.Text = lstDetails[0].JobNumber;
txtSubmitDate.Text = lstDetails[0].SubmitDate.Value.ToString("MM/dd/yyyy"); // to display only date part
txtSubmitBy.Text = lstDetails[0].SubmittedByName;
txtBranch.Text = lstDetails[0].BranchName;
txtDescription.Text = lstDetails[0].Description;
ddlJobStatus.Items.FindByValue(lstDetails[0].JobStatusId.ToString()).Selected = true;
ddlJobType.Items.FindByValue(lstDetails[0].JobTypeId.ToString()).Selected = true;
ddlTeam.Items.FindByValue(lstDetails[0].AllocatedToTeam.ToString()).Selected = true;
ddlJobType.Enabled = false;
//ddlQAUser.Style.Add("display", "none");
divQaUser.Style.Add("display", "none");
//ddlUser.Style.Add("display", "none");
divUser.Style.Add("display", "none");
}
}
public string EditJobStatusAndAllocationDetailsDAL(JobDetailsBE jobDetailsBE)
{
string squery = string.Empty;
try
{
SqlParameter[] param =
{
new SqlParameter("@Action", jobDetailsBE.Action),
new SqlParameter("@JobId", jobDetailsBE.Id),
new SqlParameter("@JobStatusId", jobDetailsBE.JobStatusId),
new SqlParameter("@QAUserId", jobDetailsBE.QAUserId),
new SqlParameter("@AllocatedToTeam", jobDetailsBE.AllocatedToTeam),
new SqlParameter("@AllocatedToUser", jobDetailsBE.AllocatedToUser),
new SqlParameter("@AllocationDate", jobDetailsBE.AllocationDate != null? jobDetailsBE.AllocationDate : DateTime.Now),
new SqlParameter("@UserId", jobDetailsBE.CreatedBy),
};
DataSet ds = SqlHelper.ExecuteDataset(DBConnection.Connection.ToString(), CommandType.StoredProcedure, "spJobDetails", param);
squery = ds.Tables[0].Rows[0][0].ToString();
return(squery);
}
catch (Exception ex)
{
return("0");
}
}
private void GetJobDetailsForQA_Member_QAHeadUserType()
{
JobDetailsBE obJobDetailsBE = new JobDetailsBE();
obJobDetailsBE.Action = "GetJobDetailsById";
if (Request.QueryString["JobId"] != null)
{
obJobDetailsBE.Id = Convert.ToInt32(Request.QueryString["JobId"]);
}
List <JobDetailsBE> lstDetails = jobDetailsBAL.GetJobDetailsBAL(obJobDetailsBE);
if (lstDetails != null && lstDetails.Count > 0)
{
if (Session["IsServiceCompanyUser"] != null)
{
if (Session["IsServiceCompanyUser"].ToString() == "True" || lstDetails[0].IsInternalUse == true)
{
divInternalUse.Visible = true;
}
else
{
divInternalUse.Visible = false;
}
}
else
{
divInternalUse.Visible = false;
}
txtJobNumber.Text = lstDetails[0].JobNumber;
txtSubmitDate.Text = lstDetails[0].SubmitDate.Value.ToString("MM/dd/yyyy"); // to display only date part
txtSubmitBy.Text = lstDetails[0].SubmittedByName;
txtBranch.Text = lstDetails[0].BranchName;
txtDescription.Text = lstDetails[0].Description;
ddlJobStatus.Items.FindByValue(lstDetails[0].JobStatusId.ToString()).Selected = true;
ddlJobType.Items.FindByValue(lstDetails[0].JobTypeId.ToString()).Selected = true;
ddlTeam.Items.FindByValue(lstDetails[0].AllocatedToTeam.ToString()).Selected = true;
ddlUser.Items.FindByValue(lstDetails[0].AllocatedToUser.ToString()).Selected = true;
ddlQAUser.Items.FindByValue(lstDetails[0].QAUserId.ToString()).Selected = true;
ddlJobType.Enabled = false;
if (
Convert.ToString(Session["UserTypeCode"]).Trim().Equals(UserType.Enum.QA.ToString()) ||
Convert.ToString(Session["UserTypeCode"]).Equals(UserType.Enum.MEMBER.ToString())
)
{
ddlUser.Enabled = false;
ddlUser.CssClass = "aspNetDisabled form-control";
ddlQAUser.Enabled = false;
ddlQAUser.CssClass = "aspNetDisabled form-control";
}
}
}
public string InsertIntoJobDetailsBAL(JobDetailsBE obj)
{
string squery = string.Empty;
try
{
squery = compassDAL.InsertIntoJobDetailsDAL(obj);
}
catch (Exception ex)
{
}
return(squery);
}
public string AddJobCommentsBAL(JobDetailsBE objJobDetailsDAL)
{
JobDetailsDAL jobDetailsDAL = new JobDetailsDAL();
string squery = string.Empty;
try
{
squery = jobDetailsDAL.AddJobCommentsDAL(objJobDetailsDAL);
}
catch (Exception ex)
{
}
return(squery);
}
public string EditJobStatusAndAllocationDetailsBAL(JobDetailsBE objJobDetailsDAL)
{
JobDetailsDAL jobDetailsDAL = new JobDetailsDAL();
string squery = string.Empty;
try
{
squery = jobDetailsDAL.EditJobStatusAndAllocationDetailsDAL(objJobDetailsDAL);
}
catch (Exception ex)
{
}
return(squery);
}
public List <JobDetailsBE> GetJobDetailsDAL(JobDetailsBE objJobDetailsBE)
{
List <JobDetailsBE> JobDetailsBEList = new List <JobDetailsBE>();
try
{
DataTable dt = new DataTable();
int index = 0;
SqlParameter[] param = new SqlParameter[1];
param[index++] = new SqlParameter("@Id", objJobDetailsBE.Id);
DataSet ds = SqlHelper.ExecuteDataset(DBConnection.Connection.ToString(), CommandType.StoredProcedure, "spJobDetails", param);
dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
JobDetailsBE oNewJobDetailsBE = new JobDetailsBE();
oNewJobDetailsBE.Id = Convert.ToInt32(dr["Id"].ToString());
if (dr.Table.Columns.Contains("ClientId"))
{
oNewJobDetailsBE.ClientId = Convert.ToInt32(dr["ClientId"].ToString());
}
oNewJobDetailsBE.JobNumber = Convert.ToString(dr["JobNumber"]);
oNewJobDetailsBE.SubmitDate = Convert.ToDateTime(dr["SubmitDate"]);
oNewJobDetailsBE.SubmitBy = Convert.ToInt32(dr["SubmitBy"].ToString());
oNewJobDetailsBE.SubmittedByBranch = Convert.ToInt32(dr["SubmitByBranch"].ToString());
oNewJobDetailsBE.CreatedDate = Convert.ToDateTime(dr["CreatedDate"]);
oNewJobDetailsBE.CreatedBy = Convert.ToInt32(dr["CreatedBy"].ToString());
oNewJobDetailsBE.JobTypeId = Convert.ToInt32(dr["JobTypeId"].ToString());
oNewJobDetailsBE.JobStatusId = Convert.ToInt32(dr["JobStatusId"].ToString());
oNewJobDetailsBE.AllocatedToTeam = Convert.ToInt32(dr["AllocatedToTeam"].ToString());
oNewJobDetailsBE.AllocatedToUser = Convert.ToInt32(dr["AllocatedToUser"].ToString());
oNewJobDetailsBE.AllocationDate = Convert.ToDateTime(dr["AllocationDate"]);
oNewJobDetailsBE.QAUserId = Convert.ToInt32(dr["AllocatedToUser"].ToString());
oNewJobDetailsBE.LastCommentedDate = Convert.ToDateTime(dr["LastCommentedDate"]);
oNewJobDetailsBE.LastUpdatedDate = Convert.ToDateTime(dr["LastUpdatedDate"]);
oNewJobDetailsBE.PriorityID = Convert.ToInt32(dr["PriorityID"].ToString());
oNewJobDetailsBE.IsSystemDefined = Convert.ToBoolean(dr["IsSystemDefined"].ToString());
JobDetailsBEList.Add(oNewJobDetailsBE);
}
}
catch (Exception ex)
{
}
return(JobDetailsBEList);
}
public string InsertIntoJobDetailsDAL(JobDetailsBE obj)
{
string squery = string.Empty;
try
{
SqlParameter tvpParam = new SqlParameter("@Attachments", obj.Attachments);
tvpParam.SqlDbType = SqlDbType.Structured;
tvpParam.Direction = ParameterDirection.Input;
tvpParam.TypeName = "dbo.UT_JobAttachment";
SqlParameter[] param =
{ new SqlParameter("@ClientId", obj.ClientId),
new SqlParameter("@JobNumber", obj.JobNumber),
new SqlParameter("@SubmitDate", obj.SubmitDate),
new SqlParameter("@SubmitBy", obj.SubmitBy),
new SqlParameter("@SubmittedByBranch", obj.SubmittedByBranch),
new SqlParameter("@CretaedDate", obj.CreatedDate),
new SqlParameter("@CreatedBy", obj.CreatedBy),
new SqlParameter("@JobTypeId", obj.JobTypeId),
//new SqlParameter("@JobStatusId",obj.JobStatusId),
new SqlParameter("@AllocatedToTeam", obj.AllocatedToTeam),
new SqlParameter("@AllocatedToUser", obj.AllocatedToUser),
new SqlParameter("@AllocationDate", obj.AllocationDate),
new SqlParameter("@QAUserId", obj.QAUserId),
new SqlParameter("@LastCommentedDate", obj.LastCommentedDate),
new SqlParameter("@LastUpdatedDate", obj.LastUpdatedDate),
new SqlParameter("@PriorityID", obj.PriorityID),
new SqlParameter("@IsSystemDefined", obj.IsSystemDefined),
new SqlParameter("@CommentDescription", obj.CommentDescription),
tvpParam };
if (obj.Attachments.Count == 0)
{
param = param.RemoveFromArray(tvpParam);
}
DataSet ds = SqlHelper.ExecuteDataset(DBConnection.Connection.ToString(), CommandType.StoredProcedure, "spCreateJob", param);
squery = ds.Tables[0].Rows[0][0].ToString();
return(squery);
}
catch (Exception ex)
{
// GeneralFuntions.WriteErrorToLog("Handler_SR_Presales", "InsertIntoSysRequests", DateTime.Now, 5, squery, ex.Message + "\n-------\n" + ex.StackTrace);
return("0");
}
}
public List <JobDetailsBE> GetJobDetailsDAL(JobDetailsBE objJobDetailsBE)
{
List <JobDetailsBE> JobDetailsBEList = new List <JobDetailsBE>();
try
{
DataTable dt = new DataTable();
int index = 0;
SqlParameter[] param = new SqlParameter[2];
param[index++] = new SqlParameter("@Action", objJobDetailsBE.Action);
param[index++] = new SqlParameter("@JobId", objJobDetailsBE.Id);
DataSet ds = SqlHelper.ExecuteDataset(DBConnection.Connection.ToString(), CommandType.StoredProcedure, "spJobDetails", param);
dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
JobDetailsBE oNewJobDetailsBE = new JobDetailsBE();
oNewJobDetailsBE.Id = Convert.ToInt32(dr["Id"].ToString());
oNewJobDetailsBE.ClientId = dr["ClientId"] != DBNull.Value ? Convert.ToInt32(dr["ClientId"]) : 0;
oNewJobDetailsBE.JobNumber = Convert.ToString(dr["JobNumber"]);
oNewJobDetailsBE.SubmitDate = Convert.ToDateTime(dr["SubmitDate"]);
oNewJobDetailsBE.SubmittedByName = dr["SubmittedByName"] != DBNull.Value ? dr["SubmittedByName"].ToString() : null;
oNewJobDetailsBE.BranchName = dr["BranchName"] != DBNull.Value ? dr["BranchName"].ToString() : null;
oNewJobDetailsBE.JobTypeId = Convert.ToInt32(dr["JobTypeId"].ToString());
oNewJobDetailsBE.JobStatusId = Convert.ToInt32(dr["JobStatusId"].ToString());
oNewJobDetailsBE.AllocatedToTeam = dr["AllocatedToTeam"] != DBNull.Value ? Convert.ToInt32(dr["AllocatedToTeam"].ToString()) : 0;
oNewJobDetailsBE.AllocatedToUser = dr["AllocatedToUser"] != DBNull.Value ? Convert.ToInt32(dr["AllocatedToUser"].ToString()) : 0;
oNewJobDetailsBE.AllocationDate = dr["AllocationDate"] != DBNull.Value ? Convert.ToDateTime(dr["AllocationDate"].ToString()) : (DateTime?)null;
oNewJobDetailsBE.QAUserId = dr["QAUserId"] != DBNull.Value ? Convert.ToInt32(dr["QAUserId"].ToString()) : 0;
oNewJobDetailsBE.LastCommentedDate = dr["LastCommentedDate"] != DBNull.Value ? Convert.ToDateTime(dr["LastCommentedDate"].ToString()) : (DateTime?)null;
oNewJobDetailsBE.LastUpdatedDate = dr["LastUpdatedDate"] != DBNull.Value ? Convert.ToDateTime(dr["LastUpdatedDate"].ToString()) : (DateTime?)null;
oNewJobDetailsBE.PriorityID = dr["PriorityID"] != DBNull.Value ? Convert.ToInt32(dr["PriorityID"].ToString()) : 0;
oNewJobDetailsBE.IsSystemDefined = dr["IsSystemDefined"] != DBNull.Value ? Convert.ToBoolean(dr["IsSystemDefined"].ToString()) : false;
oNewJobDetailsBE.Description = dr["Description"] != DBNull.Value ? dr["Description"].ToString() : null;
oNewJobDetailsBE.IsInternalUse = dr["IsInternal"] != DBNull.Value ? Convert.ToBoolean(dr["IsInternal"].ToString()) : false;
JobDetailsBEList.Add(oNewJobDetailsBE);
}
}
catch (Exception ex)
{
}
return(JobDetailsBEList);
}
public List <JobDetailsBE> GetJobDetailsBAL(JobDetailsBE objJobDetailsBE)
{
List <JobDetailsBE> JobDetailsBEList = new List <JobDetailsBE>();
try
{
JobDetailsDAL objJobDetailsDAL = new JobDetailsDAL();
JobDetailsBEList = objJobDetailsDAL.GetJobDetailsDAL(objJobDetailsBE);
objJobDetailsDAL = null;
}
catch (Exception ex)
{
}
finally { }
return(JobDetailsBEList);
}
private void GetJobDetailsForPMAndDMUserType()
{
JobDetailsBE obJobDetailsBE = new JobDetailsBE();
obJobDetailsBE.Action = "GetJobDetailsById";
if (Request.QueryString["JobId"] != null)
{
obJobDetailsBE.Id = Convert.ToInt32(Request.QueryString["JobId"]);
}
List <JobDetailsBE> lstDetails = jobDetailsBAL.GetJobDetailsBAL(obJobDetailsBE);
if (lstDetails != null && lstDetails.Count > 0)
{
if (Session["IsServiceCompanyUser"] != null)
{
if (Session["IsServiceCompanyUser"].ToString() == "True" || lstDetails[0].IsInternalUse == true)
{
divInternalUse.Visible = true;
}
else
{
divInternalUse.Visible = false;
}
}
else
{
divInternalUse.Visible = false;
}
txtJobNumber.Text = lstDetails[0].JobNumber;
txtSubmitDate.Text = lstDetails[0].SubmitDate.Value.ToString("MM/dd/yyyy"); // to display only date part
txtSubmitBy.Text = lstDetails[0].SubmittedByName;
txtBranch.Text = lstDetails[0].BranchName;
txtDescription.Text = lstDetails[0].Description;
ddlJobStatus.Items.FindByValue(lstDetails[0].JobStatusId.ToString()).Selected = true;
ddlJobType.Items.FindByValue(lstDetails[0].JobTypeId.ToString()).Selected = true;
ddlTeam.Items.FindByValue(lstDetails[0].AllocatedToTeam.ToString()).Selected = true;
ddlUser.Items.FindByValue(lstDetails[0].AllocatedToUser.ToString()).Selected = true;
ddlQAUser.Items.FindByValue(lstDetails[0].QAUserId.ToString()).Selected = true;
}
}
public string AddJobCommentsDAL(JobDetailsBE jobDetailsBE)
{
string squery = string.Empty;
try
{
SqlParameter tvpParam = new SqlParameter("@Attachments", jobDetailsBE.Attachments);
tvpParam.SqlDbType = SqlDbType.Structured;
tvpParam.Direction = ParameterDirection.Input;
tvpParam.TypeName = "dbo.UT_JobAttachment";
SqlParameter[] param =
{
new SqlParameter("@Action", jobDetailsBE.Action),
new SqlParameter("@JobId", jobDetailsBE.Id),
new SqlParameter("@ClientId", jobDetailsBE.ClientId),
new SqlParameter("@CreatedBy", jobDetailsBE.Comments.CreatedBy),
new SqlParameter("@Description", jobDetailsBE.Comments.Description),
new SqlParameter("@JobStatusId", jobDetailsBE.JobStatusId),
new SqlParameter("@QAUserId", jobDetailsBE.QAUserId),
new SqlParameter("@AllocatedToTeam", jobDetailsBE.AllocatedToTeam),
new SqlParameter("@AllocatedToUser", jobDetailsBE.AllocatedToUser),
new SqlParameter("@AllocationDate", jobDetailsBE.AllocationDate != null? jobDetailsBE.AllocationDate : DateTime.Now),
new SqlParameter("@IsInternalUse", jobDetailsBE.Comments.IsInternalUse),
new SqlParameter("@UserId", jobDetailsBE.UserId),
tvpParam
};
if (jobDetailsBE.Attachments.Count == 0)
{
param = param.RemoveFromArray(tvpParam);
}
DataSet ds = SqlHelper.ExecuteDataset(DBConnection.Connection.ToString(), CommandType.StoredProcedure, "spJobDetails", param);
squery = ds.Tables[0].Rows[0][0].ToString();
return(squery);
}
catch (Exception ex)
{
return("0");
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
JobDetailsBE jobDetailsBE = new JobDetailsBE();
jobDetailsBE.Action = "EditJobStatusAndAllocationDetails";
jobDetailsBE.Id = Convert.ToInt32(Request.QueryString["JobId"]);
jobDetailsBE.UserId = Convert.ToInt32(Session["UserId"]);
if (
Convert.ToString(Session["UserTypeCode"]).Equals(UserType.Enum.PM.ToString()) ||
Convert.ToString(Session["UserTypeCode"]).Equals(UserType.Enum.DM.ToString())
)
{
if (ddlJobStatus.SelectedValue != null || ddlJobStatus.SelectedIndex != 0 || ddlJobStatus.SelectedIndex != -1)
{
jobDetailsBE.JobStatusId = Convert.ToInt32(ddlJobStatus.SelectedValue);
}
if (ddlQAUser.SelectedValue != null || ddlQAUser.SelectedIndex != 0 || ddlQAUser.SelectedIndex != -1)
{
jobDetailsBE.QAUserId = Convert.ToInt32(ddlQAUser.SelectedValue);
}
if (ddlTeam.SelectedValue != null || ddlTeam.SelectedIndex != 0 || ddlTeam.SelectedIndex != -1)
{
jobDetailsBE.AllocatedToTeam = Convert.ToInt32(ddlTeam.SelectedValue);
jobDetailsBE.AllocationDate = DateTime.Now;
}
if (ddlUser.SelectedValue != null || ddlUser.SelectedIndex != 0 || ddlUser.SelectedIndex != -1)
{
jobDetailsBE.AllocatedToUser = Convert.ToInt32(ddlUser.SelectedValue);
}
}
if (
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 (ddlJobStatus.SelectedValue != null || ddlJobStatus.SelectedIndex != 0 || ddlJobStatus.SelectedIndex != -1)
{
jobDetailsBE.JobStatusId = Convert.ToInt32(ddlJobStatus.SelectedValue);
}
}
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);
}
if (ddlTeam.SelectedValue != null || ddlTeam.SelectedIndex != 0 || ddlTeam.SelectedIndex != -1)
{
jobDetailsBE.AllocatedToTeam = Convert.ToInt32(ddlTeam.SelectedValue);
jobDetailsBE.AllocationDate = DateTime.Now;
}
}
}
jobDetailsBE.CreatedBy = Convert.ToInt32(Session["UserId"]);
string result = jobDetailsBAL.EditJobStatusAndAllocationDetailsBAL(jobDetailsBE);
if (result == "1")
{
grdHistory.DataSource = jobDetailsBAL.GetJobHistoryDAL(Convert.ToInt32(Request.QueryString["JobId"]));
grdHistory.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "", "<script>alert('Job Status And Allocation Details Edited Succesfully');</script>", false);
}
}
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;
}
}
