public void MailsByMailGun(timesheet lstobjtime, string Emailbody) { try { if (lstobjtime.SubmittedFlag == "2" && lstobjtime.EmailAppOrRejStatus == "1" && lstobjtime.ManagerID1 == lstobjtime.ManagerId) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Approved By Level-1 Manager')", true); divEmailid.InnerHtml = Emailbody; } else if (lstobjtime.SubmittedFlag == "2" && lstobjtime.EmailAppOrRejStatus == "0" && lstobjtime.ManagerID1 == lstobjtime.ManagerId) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Rejected By Level-1 Manager')", true); } if (lstobjtime.SubmittedFlag == "2" && lstobjtime.EmailAppOrRejStatus == "1" && lstobjtime.ManagerID2 == lstobjtime.ManagerId) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Approved By Level-2 Manager')", true); } if (lstobjtime.SubmittedFlag == "2" && lstobjtime.EmailAppOrRejStatus == "0" && lstobjtime.ManagerID2 == lstobjtime.ManagerId) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Rejected By Level-2 Manager')", true); } divEmailid.InnerHtml = Emailbody; } catch (Exception ex) { throw ex; } }
public timesheet TimeSheetManagerAction(timesheet sheetObj) { timesheet objtimesheet = new timesheet(); int Trans_Output = 0; UserSessionInfo sessId = Session["UserSessionInfo"] as UserSessionInfo; if ((sheetObj.UserID != 0)) { Userid = sheetObj.UserID.ToString(); } else { Userid = sessId.UserId.ToString(); } try { Conn = new SqlConnection(str); if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } SqlCommand objCommand = new SqlCommand("[ManagerActionsfromEmail]", Conn); objCommand.CommandType = CommandType.StoredProcedure; objCommand.Parameters.AddWithValue("@UserID", sheetObj.UserID); objCommand.Parameters.AddWithValue("@TimesheetID", sheetObj.TimesheetID); objCommand.Parameters.AddWithValue("@Projectid", sheetObj.ProjectID); if (sheetObj.SubmittedType == "3") { objCommand.Parameters.AddWithValue("@ManagerId", sessId.UserId); } else { objCommand.Parameters.AddWithValue("@ManagerId", sheetObj.ManagerId); } objCommand.Parameters.AddWithValue("@ClientprojID", sheetObj.ClientProjectId); objCommand.Parameters.AddWithValue("@Comments", sheetObj.Comments); objCommand.Parameters.AddWithValue("@SubmittedType", sheetObj.EmailAppOrRejStatus); //objCommand.Parameters.AddWithValue("@Trans_Output", SqlDbType.Int); objCommand.Parameters.Add("@Trans_Output", SqlDbType.Int); objCommand.Parameters["@Trans_Output"].Direction = ParameterDirection.Output; objCommand.ExecuteNonQuery(); Trans_Output = int.Parse(objCommand.Parameters["@Trans_Output"].Value.ToString()); var checkL1approvestatus = (from ts in db.TIMESHEETs where ts.TimesheetID == sheetObj.TimesheetID select ts.L1_ApproverStatus).FirstOrDefault(); var checkL2approvestatus = (from ts in db.TIMESHEETs where ts.TimesheetID == sheetObj.TimesheetID select ts.L2_ApproverStatus).FirstOrDefault(); if (checkL1approvestatus == 5 && checkL2approvestatus == 5) { Trans_Output = 5; lstobjtime = new timesheet() { Message = "Timesheet is already revoked by Admin", }; } if (Trans_Output == 0) { lstobjtime = new timesheet() { Transoutput = Trans_Output, Position = "L1", ManagerName1 = ManagerLNames.ToString(), Message = "Timesheet is already rejected by" + " " + ManagerLNames, SubmittedState = "Once", EmailAppOrRejStatus = sheetObj.EmailAppOrRejStatus, UserID = sheetObj.UserID, ManagerId = sheetObj.ManagerId, Comments = sheetObj.Comments, }; } if (Trans_Output == 900) { lstobjtime = new timesheet() { Transoutput = Trans_Output, Position = "", Message = "Managerid is incorrect", SubmittedState = "Once", EmailAppOrRejStatus = sheetObj.EmailAppOrRejStatus, UserID = sheetObj.UserID, ManagerId = sheetObj.ManagerId, Comments = sheetObj.Comments, }; } if (Trans_Output == 1) { lstobjtime = new timesheet() { Transoutput = Trans_Output, Position = "L1", Message = "Approved by" + " " + ManagerLNames, EmailAppOrRejStatus = sheetObj.EmailAppOrRejStatus, UserID = sheetObj.UserID, ManagerId = sheetObj.ManagerId, Comments = sheetObj.Comments, }; } if (Trans_Output == 2) { lstobjtime = new timesheet() { Transoutput = Trans_Output, Position = "L1", Message = "Rejected by" + " " + ManagerLNames, EmailAppOrRejStatus = sheetObj.EmailAppOrRejStatus, UserID = sheetObj.UserID, ManagerId = sheetObj.ManagerId, Comments = sheetObj.Comments, }; } if (Trans_Output == 3) { lstobjtime = new timesheet() { Transoutput = Trans_Output, Position = "L2", Message = "Approved by" + " " + ManagerLNames, EmailAppOrRejStatus = sheetObj.EmailAppOrRejStatus, UserID = sheetObj.UserID, ManagerId = sheetObj.ManagerId, Comments = sheetObj.Comments, }; } if (Trans_Output == 4) { lstobjtime = new timesheet() { Transoutput = Trans_Output, Position = "L2", Message = "Rejected by" + " " + ManagerLNames, EmailAppOrRejStatus = sheetObj.EmailAppOrRejStatus, UserID = sheetObj.UserID, ManagerId = sheetObj.ManagerId, Comments = sheetObj.Comments, }; } if (Trans_Output == 104) { lstobjtime = new timesheet() { Transoutput = Trans_Output, Position = "L1", Message = "Timesheet is already approved by" + " " + ManagerLNames, EmailAppOrRejStatus = sheetObj.EmailAppOrRejStatus, UserID = sheetObj.UserID, ManagerId = sheetObj.ManagerId, Comments = sheetObj.Comments, }; } if (Trans_Output == 106) { lstobjtime = new timesheet() { Transoutput = Trans_Output, Position = "L1", Message = "Timesheet is already rejected by" + " " + ManagerLNames, EmailAppOrRejStatus = sheetObj.EmailAppOrRejStatus, UserID = sheetObj.UserID, ManagerId = sheetObj.ManagerId, Comments = sheetObj.Comments, }; } if (Trans_Output == 105) { lstobjtime = new timesheet() { Transoutput = Trans_Output, Position = "L2", Message = "Timesheet is already approved by" + " " + ManagerLNames, EmailAppOrRejStatus = sheetObj.EmailAppOrRejStatus, UserID = sheetObj.UserID, ManagerId = sheetObj.ManagerId, Comments = sheetObj.Comments, }; } if (Trans_Output == 107) { lstobjtime = new timesheet() { Transoutput = Trans_Output, Position = "L2", Message = "Timesheet is already rejected by" + " " + ManagerLNames, EmailAppOrRejStatus = sheetObj.EmailAppOrRejStatus, UserID = sheetObj.UserID, ManagerId = sheetObj.ManagerId, Comments = sheetObj.Comments, }; } } catch (Exception ex) { throw ex; } finally { if (Conn != null) { if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } } } return(lstobjtime); }
public void suceessEmail(string strVal) { try { //string text = string.Empty; //if (strVal == null) //{ // strVal = txt_comments.Value; // text = strVal.Trim().ToString(); //} if (submittedflag == "2") { sheetObj.timesheets = new timesheet() { TimesheetID = Convert.ToInt32(Timesheetid), TimeSheetMonth = TimesheetMonth, ManagerId = Managerid, UserID = Convert.ToInt32(Userid), SubmittedFlag = submittedflag, EmailAppOrRejStatus = ActionType, ProjectID = Convert.ToInt32(MailProjectid), ManagerName1 = ManagerLNames.ToString(), ClientProjectId = Convert.ToInt32(clientid), Comments = Comments }; lstobjtime = TimeSheetManagerAction(sheetObj.timesheets); List <string> UploadedImagesList = obj.GetImages(sheetObj.timesheets.TimesheetID); Apply_Managercomments.Visible = false; emailstatus.Visible = true; divEmailid.Visible = true; if ((lstobjtime.Transoutput == 1) || (lstobjtime.Transoutput == 2) || (lstobjtime.Transoutput == 3) || (lstobjtime.Transoutput == 4)) { sheetObj.timesheets.Transoutput = lstobjtime.Transoutput; Emailbody = objtimesheet.SendMailsForApprovals(sheetObj, sheetObj.timesheets.TimesheetID, sheetObj.timesheets.UserID, UploadedImagesList); if (Emailbody.Contains("display:block")) { Emailbody = Emailbody.Replace("display:block", "display:none"); } lblEmailstatus.Text = lstobjtime.Message; if ((lstobjtime.Transoutput == 1) || (lstobjtime.Transoutput == 3)) { lblEmailstatus.Attributes.Add("style", "color: #00bd00");// } else if ((lstobjtime.Transoutput == 2) || (lstobjtime.Transoutput == 4)) { lblEmailstatus.Attributes.Add("style", "color: #f44336");// } } else { sheetObj.timesheets.Transoutput = lstobjtime.Transoutput; Emailbody = objtimesheet.SendMailsForApprovals(sheetObj, sheetObj.timesheets.TimesheetID, sheetObj.timesheets.UserID, UploadedImagesList); lblEmailstatus.Text = lstobjtime.Message; lblEmailstatus.Attributes.Add("style", "color: #f44336");// } divEmailid.InnerHtml = Emailbody; } } catch (Exception ex) { throw ex; } }