public List <NameEmail> GetNameEmailByParaValue(string parameter, string value) { List <NameEmail> nameEmail = new List <NameEmail>(); using (SqlDataAdapter sda = new SqlDataAdapter("[dbo].[User_GetNameEmail]", cn)) { sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.AddWithValue("@column", parameter); sda.SelectCommand.Parameters.AddWithValue("@value", value); try { DataTable dt = new DataTable(); sda.Fill(dt); foreach (DataRow dr in dt.Rows) { NameEmail nameemail = new NameEmail { email = dr["Email"].ToString(), name = dr["Name"].ToString() }; nameEmail.Add(nameemail); } } catch (Exception ex) { MessageBox.Show(ex.Message, "SPM Connect - Get User Name and Email " + parameter, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { cn.Close(); } } return(nameEmail); }
private void PassItForChecking() { NameEmail creator = releaseModule.GetNameEmailByParaValue(UserFields.id, rlog.CreatedById.ToString())[0]; string subject; string body; NameEmail receiver = releaseModule.GetNameEmailByParaValue(UserFields.id, rlog.SubmittedTo.ToString())[0]; subject = "Requires Checking - " + rlog.Job.ToString() + "(" + rlog.SubAssy + ") - (" + rlog.RelNo + ")"; body = creator.name + " has drawings that needs to be checked. <br>" + "Job Number : " + rlog.Job.ToString() + "<br>" + "Sub Assy : " + rlog.SubAssy + "<br>" + "Sub Assy Description: " + rlog.SubAssyDes + "<br>" + "FolderPath : " + rlog.Path + "<br>"; releaseModule.TriggerEmail(receiver.email, subject, receiver.name, body, "", creator.email, "", "Addin"); }
private void NotifyUserForChange(ApprovalType approvalType) { NameEmail creator = releaseModule.GetNameEmailByParaValue(UserFields.id, rlog.CreatedById.ToString())[0]; string subject; string body; if (!rlog.IsActive) { subject = "Drawing Package Marked Inactive - " + rlog.Job.ToString() + "(" + rlog.SubAssy + ") - (" + rlog.RelNo.ToString() + ")"; body = releaseModule.ConnectUser.Name + " has removed the drawing package from release for build. <br>" + "Job Number : " + rlog.Job.ToString() + "<br>" + "Sub Assy : " + rlog.SubAssy + "<br>" + "Release No : " + rlog.RelNo.ToString(); NameEmail checkor = releaseModule.GetNameEmailByParaValue(UserFields.Name, rlog.CheckedBy)[0]; if (approvalType == ApprovalType.release) { NameEmail approvor = releaseModule.GetNameEmailByParaValue(UserFields.Name, rlog.ApprovedBy)[0]; releaseModule.TriggerEmail(creator.email, subject, creator.name, body, "", checkor.email, approvor.email, "Normal"); } else { releaseModule.TriggerEmail(creator.email, subject, creator.name, body, "", checkor.email, "", "Normal"); } return; } if (approvalType == ApprovalType.checking) { subject = "Drawings Check Rejected - " + rlog.Job.ToString() + "(" + rlog.SubAssy + ") - (" + rlog.RelNo.ToString() + ")"; body = releaseModule.ConnectUser.Name + " has declined the checking of the drawing package. <br>" + "Job Number : " + rlog.Job.ToString() + "<br>" + "Sub Assy : " + rlog.SubAssy + "<br>" + "Release No : " + rlog.RelNo.ToString() + "<br>" + "Please check attached screen shot."; releaseModule.TriggerEmail(creator.email, subject, creator.name, body, ApplicationSettings.ScreenshotLocation, "", "", "Normal"); } else if (approvalType == ApprovalType.controls) { subject = "Drawings Approval Rejected - " + rlog.Job.ToString() + "(" + rlog.SubAssy + ") - (" + rlog.RelNo.ToString() + ")"; body = releaseModule.ConnectUser.Name + " has declined the controls approval of the drawing package. <br>" + "Job Number : " + rlog.Job.ToString() + "<br>" + "Sub Assy : " + rlog.SubAssy + "<br>" + "Release No : " + rlog.RelNo.ToString() + "<br>" + "Please check attached screen shot."; releaseModule.TriggerEmail(creator.email, subject, creator.name, body, ApplicationSettings.ScreenshotLocation, "", "", "Normal"); } else if (approvalType == ApprovalType.release) { subject = "Drawing Release Rejected - " + rlog.Job.ToString() + "(" + rlog.SubAssy + ") - (" + rlog.RelNo.ToString() + ")"; body = releaseModule.ConnectUser.Name + " has declined releasing the drawing package for release for build. <br>" + "Job Number : " + rlog.Job.ToString() + "<br>" + "Sub Assy : " + rlog.SubAssy + "<br>" + "Release No : " + rlog.RelNo.ToString() + "<br>" + "Please check attached screen shot."; NameEmail checkor = releaseModule.GetNameEmailByParaValue(UserFields.Name, rlog.CheckedBy)[0]; NameEmail approvor = releaseModule.GetNameEmailByParaValue(UserFields.Name, rlog.ApprovedBy)[0]; releaseModule.TriggerEmail(creator.email, subject, creator.name, body, ApplicationSettings.ScreenshotLocation, checkor.email, approvor.email, "Normal"); } else if (approvalType == ApprovalType.approval) { subject = "Drawing Approval Rejected - " + rlog.Job.ToString() + "(" + rlog.SubAssy + ") - (" + rlog.RelNo.ToString() + ")"; body = releaseModule.ConnectUser.Name + " has declined approving the drawing package. <br>" + "Job Number : " + rlog.Job.ToString() + "<br>" + "Sub Assy : " + rlog.SubAssy + "<br>" + "Release No : " + rlog.RelNo.ToString() + "<br>" + "Please check attached screen shot."; NameEmail checkor = releaseModule.GetNameEmailByParaValue(UserFields.Name, rlog.CheckedBy)[0]; releaseModule.TriggerEmail(creator.email, subject, creator.name, body, ApplicationSettings.ScreenshotLocation, checkor.email, "", "Normal"); } ApplicationSettings.ScreenshotLocation = ""; }
public EmailModel() { To = new NameEmail(); Bcc = new NameEmail(); Cc = new NameEmail(); }