private void caCanecl_ExecuteCode(object sender, EventArgs e) { SignInSignOutBOL objSignInSignOutBOL = new SignInSignOutBOL(); DataSet dsSignInSignOut = objSignInSignOutBOL.WFGetSignInSignOutDetails(SignInSignOutID); To = dsSignInSignOut.Tables[0].Rows[0]["ApproverEmailID"].ToString(); for (int k = 0; k < dsSignInSignOut.Tables[2].Rows.Count; k++) { if (dsSignInSignOut.Tables[2].Rows[k]["ConfigItemName"].ToString() == "From EmailID") { strFrom = dsSignInSignOut.Tables[2].Rows[k]["ConfigItemValue"].ToString(); } } From = strFrom; string strSubject = dsSignInSignOut.Tables[1].Rows[8]["EmailSubject"].ToString(); Subject = Regex.Replace(strSubject, "##User##", dsSignInSignOut.Tables[0].Rows[0]["EmployeeName"].ToString()); //Body = Regex.Replace(dsSignInSignOut.Tables[1].Rows[8]["EmailBody"].ToString(), "##User##", dsSignInSignOut.Tables[0].Rows[0]["EmployeeName"].ToString()); string strBody = "Hi ##EmployeeName##," + " \n\n" + " Your pending Orbit entry for ##SignInTime## was Cancelled and the following were the Approver's comment ##ApproverComments##"; strBody = Regex.Replace(strBody, "##ApproverName##", dsSignInSignOut.Tables[0].Rows[0]["ApproverName"].ToString()); strBody = Regex.Replace(strBody, "##SignInTime##", dsSignInSignOut.Tables[0].Rows[0]["SignInTime"].ToString()); strBody = Regex.Replace(strBody, "##EmployeeName##", dsSignInSignOut.Tables[0].Rows[0]["EmployeeName"].ToString()); strBody = Regex.Replace(strBody, "###SignInDate##", dsSignInSignOut.Tables[0].Rows[0]["date"].ToString()); Body = strBody; }
private void caRejected_ExecuteCode(object sender, EventArgs e) { SignInSignOutBOL objSignInSignOutBOL = new SignInSignOutBOL(); DataSet dsSignInSignOut = objSignInSignOutBOL.WFGetSignInSignOutDetails(SignInSignOutID); //To = dsSignInSignOut.Tables[0].Rows[0]["ApproverEmailID"].ToString(); To = dsSignInSignOut.Tables[0].Rows[0]["EmployeeEmail"].ToString(); for (int k = 0; k < dsSignInSignOut.Tables[2].Rows.Count; k++) { if (dsSignInSignOut.Tables[2].Rows[k]["ConfigItemName"].ToString() == "From EmailID") { strFrom = dsSignInSignOut.Tables[2].Rows[k]["ConfigItemValue"].ToString(); } } From = strFrom; //Subject = "Orbit Entry Rejected for ##SignInDate##"; string strBody = ""; for (int i = 0; i < dsSignInSignOut.Tables[1].Rows.Count; i++) { if (dsSignInSignOut.Tables[1].Rows[i]["EmailTemplateName"].ToString() == "Rejected Orbit Entry ") { strBody = dsSignInSignOut.Tables[1].Rows[i]["EmailBody"].ToString(); Subject = Subject = dsSignInSignOut.Tables[1].Rows[i]["EmailSubject"].ToString(); break; } } Subject = Regex.Replace(Subject, "##SignInDate##", dsSignInSignOut.Tables[0].Rows[0]["date"].ToString()); strBody = Regex.Replace(strBody, "##ApproverComments##", dsSignInSignOut.Tables[0].Rows[0]["ApproverComments"].ToString()); strBody = Regex.Replace(strBody, "##SignInDate##", dsSignInSignOut.Tables[0].Rows[0]["date"].ToString()); strBody = Regex.Replace(strBody, "##EmployeeName##", dsSignInSignOut.Tables[0].Rows[0]["EmployeeName"].ToString()); strBody = Regex.Replace(strBody, "##date##", dsSignInSignOut.Tables[0].Rows[0]["date"].ToString()); strBody = Regex.Replace(strBody, "##Environment##", Environment.NewLine); Body = strBody; }
private void caGetReportingToInfo_ExecuteCode(object sender, EventArgs e) { SignInSignOutBOL objSignInSignOutBOL = new SignInSignOutBOL(); DataSet dsSignInSignOut = objSignInSignOutBOL.WFGetSignInSignOutDetails(SignInSignOutID); for (int k = 0; k < dsSignInSignOut.Tables[2].Rows.Count; k++) { if (dsSignInSignOut.Tables[2].Rows[k]["ConfigItemName"].ToString() == "From EmailID") { strFrom = dsSignInSignOut.Tables[2].Rows[k]["ConfigItemValue"].ToString(); } if (dsSignInSignOut.Tables[2].Rows[k]["ConfigItemName"].ToString() == "Mail Server Name") { SMTPServer = dsSignInSignOut.Tables[2].Rows[k]["ConfigItemValue"].ToString(); } } //To = dsSignInSignOut.Tables[0].Rows[0]["ApproverEmailID"].ToString(); To = dsSignInSignOut.Tables[0].Rows[0]["ApproverEmailID"].ToString();// "*****@*****.**"; From = strFrom; string strBody = ""; if (dsSignInSignOut.Tables[0].Rows[0]["SignInComment"] != null) { string str = dsSignInSignOut.Tables[0].Rows[0]["SignInComment"].ToString(); char[] chrSplitter = { ':' }; string[] strArray = new string[2]; strArray = str.Split(chrSplitter); if (strArray[0].ToString() == "##Leave") { for (int i = 0; i < dsSignInSignOut.Tables[1].Rows.Count; i++) { if (dsSignInSignOut.Tables[1].Rows[i]["EmailTemplateName"].ToString() == "Pending Sign In Sign Out Entry Waiting Approval due to Leave") { strBody = dsSignInSignOut.Tables[1].Rows[i]["EmailBody"].ToString(); Subject = dsSignInSignOut.Tables[1].Rows[i]["EmailSubject"].ToString(); break; } } } else if (dsSignInSignOut.Tables[0].Rows[0]["TotalHoursWorked"] != null) { string str1 = dsSignInSignOut.Tables[0].Rows[0]["TotalHoursWorked"].ToString(); char[] chrSplitter1 = { ':' }; string[] strArray1 = new string[2]; strArray1 = str1.Split(chrSplitter1); int intHours = Convert.ToInt32(strArray1[0].ToString()); if (intHours >= 24) { for (int i = 0; i < dsSignInSignOut.Tables[1].Rows.Count; i++) { if (dsSignInSignOut.Tables[1].Rows[i]["EmailTemplateName"].ToString() == "Pending Sign In Sign Out Entry Waiting Approval due to 24 hrs") { strBody = dsSignInSignOut.Tables[1].Rows[i]["EmailBody"].ToString(); Subject = dsSignInSignOut.Tables[1].Rows[i]["EmailSubject"].ToString(); break; } } } else { for (int i = 0; i < dsSignInSignOut.Tables[1].Rows.Count; i++) { if (dsSignInSignOut.Tables[1].Rows[i]["EmailTemplateName"].ToString() == "Pending Sign In Sign Out Entry Waiting Approval due to 5 day cross") { strBody = dsSignInSignOut.Tables[1].Rows[i]["EmailBody"].ToString(); Subject = dsSignInSignOut.Tables[1].Rows[i]["EmailSubject"].ToString(); break; } } } } Subject = Regex.Replace(Subject, "##EmployeeName##", dsSignInSignOut.Tables[0].Rows[0]["EmployeeName"].ToString()); strBody = Regex.Replace(strBody, "##ApproverName##", dsSignInSignOut.Tables[0].Rows[0]["ApproverName"].ToString()); strBody = Regex.Replace(strBody, "##EmployeeName##", dsSignInSignOut.Tables[0].Rows[0]["EmployeeName"].ToString()); strBody = Regex.Replace(strBody, "##Date##", dsSignInSignOut.Tables[0].Rows[0]["Date"].ToString()); strBody = Regex.Replace(strBody, "##Environment##", Environment.NewLine); } Body = strBody; }