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();
}
