public void updatecomment()
{
string userName;
MembershipUser User = Membership.GetUser();
solutionstatusid = Convert.ToInt16(Request.QueryString[0]);
flag = Convert.ToInt16(Request.QueryString[1]);
int userid;
if (flag == 3)
{
string seeionsid = Session["SolutionId"].ToString();
string[] str = seeionsid.Split(new char[] { ',' });
foreach (string s in str)
{
if (s == "")
{
break;
}
int solid = Convert.ToInt16(s);
ObjSolution = ObjSolution.Get_By_id(solid);
ObjSolution.Title = ObjSolution.Title;
ObjSolution.Topicid = ObjSolution.Topicid;
ObjSolution.Content = ObjSolution.Content;
ObjSolution.Comments = txtcomments.Text;
ObjSolution.SolutionStatus = solutionstatusid;
ObjSolution.Update();
userName = User.UserName.ToString();
Objorganization = Objorganization.Get_Organization();
objUser = objUser.Get_UserLogin_By_UserName(userName, Objorganization.Orgid);
ObjSolutionCreator.Solutionid = solid;
ObjSolutionCreator.LastUpdateBy = objUser.Userid;
ObjSolutionCreator.Update();
}
}
else
{
int solutionid = Convert.ToInt16(Request.QueryString[1]);
ObjSolution = ObjSolution.Get_By_id(solutionid);
ObjSolution.Title = ObjSolution.Title;
ObjSolution.Topicid = ObjSolution.Topicid;
ObjSolution.Content = ObjSolution.Content;
ObjSolution.Comments = txtcomments.Text;
ObjSolution.SolutionStatus = solutionstatusid;
ObjSolution.Update();
userName = User.UserName.ToString();
Objorganization = Objorganization.Get_Organization();
objUser = objUser.Get_UserLogin_By_UserName(userName, Objorganization.Orgid);
ObjSolutionCreator.Solutionid = solutionid;
ObjSolutionCreator.LastUpdateBy = objUser.Userid;
ObjSolutionCreator.Update();
}
}
protected void UpdateSolution()
{
int Solutionid = Convert.ToInt16(Request.QueryString[0]);
ObjSolution = ObjSolution.Get_By_id(Solutionid);
ObjSolutionKeyword = ObjSolutionKeyword.Get_By_id(Solutionid);
txtTitle.Text = ObjSolution.Title.ToString();
Editor.Text = ObjSolution.Content.ToString();
drpTopic.SelectedValue = ObjSolution.Topicid.ToString();
ObjSolutionKeyword = ObjSolutionKeyword.Get_By_id(Solutionid);
txtKeywords.Text = ObjSolutionKeyword.Keywords.ToString();
}
public void SentMailToPManager(int solutionid)
{
string strYourSinscerely = Resources.MessageResource.strYourSinscerely.ToString();
string strContactNumber = Resources.MessageResource.strContactNumber.ToString();
Solution_mst objSolution = new Solution_mst();
SolutionCreator objSolutionCreator = new SolutionCreator();
objSolution = objSolution.Get_By_id(solutionid);
objSolutionCreator = objSolutionCreator.Get_By_id(solutionid);
UserLogin_mst objUserCreator = new UserLogin_mst();
objUserCreator = objUserCreator.Get_By_id(objSolutionCreator.Createdby);
int FlagUser;
string varRole = Resources.MessageResource.strPManagerRole.ToString();
int roleid;
roleid = objRole.Get_By_RoleName(varRole);
colUser = objUser.Get_All_By_Role(roleid);
foreach (UserLogin_mst objusr in colUser)
{
objC_info = objC_info.Get_By_id(objusr.Userid);
obj.From = Resources.MessageResource.strAdminEmail.ToString();
obj.To = objC_info.Emailid;
obj.Subject = "New Solution Added. Solution Id : " + solutionid;
obj.Body = "Dear Sir/Madam,<br/>A New Solution has been Added.Please find the New Solution details .<br/><br/><b>Solution Details : </b> <br/><br/><b>Solution Id :</b>" + objSolution.Solutionid + "<br/><b>Title :</b>" + objSolution.Title + " <br/><b>Added By :</b>" + objUserCreator.Username + "<br/><b>Created Date   :</b>" + objSolutionCreator.CreateDatetime + "<br/><b>Content :</b>" + objSolution.Content + "<br/><br/>This is an auto generated mail. Please do not reply.</b><br/><br/><b>Yours sincerely,</b><br/> <b>" + strYourSinscerely + "</b>";
obj.SmtpServer = Resources.MessageResource.strSMTPServer.ToString();
obj.SentMail();
}
}
public void Repeter_ItemDataBound(Object Sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item)
{
int topicid;
//topicid = Convert.ToInt16(DataBinder.Eval(e.Item.DataItem, "topicid"));
Label topicidL = (Label)e.Item.FindControl("lbltopicid");
topicid = Convert.ToInt16(topicidL.Text);
ObjCategory = ObjCategory.Get_By_id(topicid);
topicidL.Text = ObjCategory.CategoryName;
topicidL.Visible = true;
}
else if (e.Item.ItemType == ListItemType.AlternatingItem)
{
int topicid;
//topicid = Convert.ToInt16(DataBinder.Eval(e.Item.DataItem, "topicid"));
Label topicidL = (Label)e.Item.FindControl("lbltopicid");
topicid = Convert.ToInt16(topicidL.Text);
ObjCategory = ObjCategory.Get_By_id(topicid);
topicidL.Text = ObjCategory.CategoryName;
topicidL.Visible = true;
}
if ((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem))
{
CheckBox ck = (CheckBox)e.Item.FindControl("CheckBox1");
Label lbl = (Label)e.Item.FindControl("lblapprove");
Label solutionid = (Label)e.Item.FindControl("lblsolutionid");
Image imgapprove = (Image)e.Item.FindControl("imgapprove");
Image imgreject = (Image)e.Item.FindControl("Imgunapproved");
int slid = Convert.ToInt16(solutionid.Text);
int solid = Convert.ToInt16(solutionid.Text);
ObjSolution = ObjSolution.Get_By_id(solid);
approvestatus = Convert.ToInt16(ObjSolution.SolutionStatus);
if (approvestatus == 1)
{
lbl.Text = "Approved";
imgapprove.Visible = true;
imgreject.Visible = false;
}
else if (approvestatus == 2)
{
lbl.Text = "Rejected";
imgapprove.Visible = false;
imgreject.Visible = true;
}
else
{
lbl.Text = "Unapproved";
imgapprove.Visible = false;
imgreject.Visible = false;
}
}
}
protected void updateWorkaround()
{
int problemid = Convert.ToInt32(Request.QueryString[1]);
int flag = Convert.ToInt32(Request.QueryString[0]);
colproblems = ObjproblemToSolution.Get_All_Problemid(problemid);
foreach (ProblemToSolution obj in colproblems)
{
if (obj.Solutiontype == "WorkAround")
{
ObjSolution = ObjSolution.Get_By_id(obj.Solutionid);
if (ObjSolution.Solution == "WorkAround")
{
ObjSolutionKeyword = ObjSolutionKeyword.Get_By_id(obj.Solutionid);
txtTitle.Text = ObjSolution.Title.ToString();
txtKeywords.Text = ObjSolutionKeyword.Keywords.ToString();
drpTopic.SelectedValue = Convert.ToString(ObjSolution.Topicid);
Editor.Text = ObjSolution.Content.ToString();
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{//Add Exception handilng try catch change by vishal 21-05-2012
try
{
string strStatusClose = Resources.MessageResource.strStatusClose.ToString().Trim();
string statusString = "";
int problemid = Convert.ToInt32(Request.QueryString[0]);
ObjProbelm = ObjProbelm.Get_By_id(problemid);
objrootcause = objrootcause.Get_By_id(problemid);
objimpact = objimpact.Get_By_id(problemid);
objstatus = objstatus.Get_By_id(ObjProbelm.Statusid);
statusString = objstatus.Statusname.ToString();
if (statusString.ToLower() == strStatusClose.ToLower())
{
string ii = objimpact.Description.ToString();
string stripped4 = Regex.Replace(ii, @"<(.|\n)*?>", string.Empty);
lblserviceeffected.Text = objimpact.Description.ToString();
string rr = objrootcause.Description.ToString();
string stripped1 = Regex.Replace(rr, @"<(.|\n)*?>", string.Empty);
lblcause.Text = stripped1.ToString();
objproblemsysmptom = objproblemsysmptom.Get_By_id(problemid);
string ss = objproblemsysmptom.Description.ToString();
string stripped3 = Regex.Replace(ss, @"<(.|\n)*?>", string.Empty);
lblsymptom.Text = stripped3.ToString();
lbltcktno.Text = ObjProbelm.ProblemId.ToString();
lblcreatedate.Text = ObjProbelm.CreateDatetime.ToString();
if (ObjProbelm.AssginedTime != null)
{
lblstarttime.Text = ObjProbelm.AssginedTime.ToString();
}
lblendtime.Text = ObjProbelm.Closedatetime.ToString();
Objcategory = Objcategory.Get_By_id(ObjProbelm.Categoryid);
lblcomponenteffected.Text = Objcategory.CategoryName.ToString();
lbldescription.Text = ObjProbelm.title.ToString();
objproblemtosolution = objproblemtosolution.Get_By_id(ObjProbelm.ProblemId);
Objsolution = Objsolution.Get_By_id(objproblemtosolution.Solutionid);
string bb = Objsolution.Solution.ToString();
string stripped = Regex.Replace(bb, @"<(.|\n)*?>", string.Empty);
lblresolution.Text = stripped.ToString();
//bind data to data bound controls and do other stuff
objUser = objUser.Get_By_id(ObjProbelm.Requesterid);
lblcustomer.Text = objUser.Username.ToString();
objUser = objUser.Get_By_id(ObjProbelm.Technicianid);
lblengineer.Text = objUser.Username.ToString();
lblrcaresult.Text = "Completed";
}
Response.Clear(); //this clears the Response of any headers or previous output
Response.Buffer = true; //make sure that the entire output is rendered simultaneously
///
///Set content type to MS Excel sheet
///Use "application/msword" for MS Word doc files
///"application/pdf" for PDF files
///
Response.ContentType = "application/vnd.ms-excel";
StringWriter stringWriter = new StringWriter(); //System.IO namespace should be used
HtmlTextWriter htmlTextWriter = new HtmlTextWriter(stringWriter);
///
///Render the entire Page control in the HtmlTextWriter object
///We can render individual controls also, like a DataGrid to be
///exported in custom format (excel, word etc)
///
this.RenderControl(htmlTextWriter);
Response.Write(stringWriter.ToString());
Response.End();
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
public void SentMailToPManager(int solutionid)
{
string strYourSinscerely = Resources.MessageResource.strYourSinscerely.ToString();
string strContactNumber = Resources.MessageResource.strContactNumber.ToString();
Solution_mst objSolution = new Solution_mst();
SolutionCreator objSolutionCreator = new SolutionCreator();
objSolution = objSolution.Get_By_id(solutionid);
objSolutionCreator = objSolutionCreator.Get_By_id(solutionid);
UserLogin_mst objUserCreator = new UserLogin_mst();
objUserCreator = objUserCreator.Get_By_id(objSolutionCreator.Createdby);
int FlagUser;
string varRole = Resources.MessageResource.strPManagerRole.ToString();
int roleid;
roleid = objRole.Get_By_RoleName(varRole);
colUser = objUser.Get_All_By_Role(roleid);
foreach (UserLogin_mst objusr in colUser)
{
objC_info = objC_info.Get_By_id(objusr.Userid);
obj.From = Resources.MessageResource.strAdminEmail.ToString();
obj.To = objC_info.Emailid;
obj.Subject = "New Solution Added. Solution Id : " + solutionid;
obj.Body = "Dear Sir/Madam,<br/>A New Solution has been Added.Please find the New Solution details .<br/><br/><b>Solution Details : </b> <br/><br/><b>Solution Id :</b>" + objSolution.Solutionid + "<br/><b>Title :</b>" + objSolution.Title + " <br/><b>Added By :</b>" + objUserCreator.Username + "<br/><b>Created Date   :</b>" + objSolutionCreator.CreateDatetime + "<br/><b>Content :</b>" + objSolution.Content + "<br/><br/>This is an auto generated mail. Please do not reply.</b><br/><br/><b>Yours sincerely,</b><br/> <b>" + strYourSinscerely + "</b>";
obj.SmtpServer = Resources.MessageResource.strSMTPServer.ToString();
obj.SentMail();
}
}
public void Repeter_ItemDataBound(Object Sender, RepeaterItemEventArgs e)
{/////Add Exception handilng try catch change by vishal 21-05-2012
try
{
if (e.Item.ItemType == ListItemType.Item)
{
int topicid;
//topicid = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "topicid"));
Label topicidL = (Label)e.Item.FindControl("lbltopicid");
topicid = Convert.ToInt32(topicidL.Text);
ObjCategory = ObjCategory.Get_By_id(topicid);
topicidL.Text = ObjCategory.CategoryName;
topicidL.Visible = true;
}
else if (e.Item.ItemType == ListItemType.AlternatingItem)
{
int topicid;
//topicid = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "topicid"));
Label topicidL = (Label)e.Item.FindControl("lbltopicid");
topicid = Convert.ToInt32(topicidL.Text);
ObjCategory = ObjCategory.Get_By_id(topicid);
topicidL.Text = ObjCategory.CategoryName;
topicidL.Visible = true;
}
if ((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem))
{
CheckBox ck = (CheckBox)e.Item.FindControl("CheckBox1");
Label lbl = (Label)e.Item.FindControl("lblapprove");
Label solutionid = (Label)e.Item.FindControl("lblsolutionid");
Image imgapprove = (Image)e.Item.FindControl("imgapprove");
Image imgreject = (Image)e.Item.FindControl("Imgunapproved");
int slid = Convert.ToInt32(solutionid.Text);
int solid = Convert.ToInt32(solutionid.Text);
ObjSolution = ObjSolution.Get_By_id(solid);
approvestatus = Convert.ToInt32(ObjSolution.SolutionStatus);
if (approvestatus == 1)
{
lbl.Text = "Approved";
imgapprove.Visible = true;
imgreject.Visible = false;
}
else if (approvestatus == 2)
{
lbl.Text = "Rejected";
imgapprove.Visible = false;
imgreject.Visible = true;
}
else
{
lbl.Text = "Unapproved";
imgapprove.Visible = false;
imgreject.Visible = false;
}
}
}
catch (Exception ex)
{
string myScript;
myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
Page.RegisterClientScriptBlock("MyScript", myScript);
return;
}
}
