public IEnumerable<UserStatus> GetUserStatuses()
{
using (FormContext ctx = new FormContext())
{
var StatusList = ctx.UserStatuses.ToList();
return StatusList;
}
}
public void FillEmailAddressLabels()
{
List<String> listEmails = new List<String>();
if (cbNotifyStandard.Checked)
{
using (FormContext ctx = new FormContext())
{
if (ctx.InventoryNotificationEmailAddresses.Any(x => x.Status == 1))
{
ICollection<InventoryNotificationEmails> emailAddresses = ctx.InventoryNotificationEmailAddresses.Where(x => x.Status == 1).ToList();
if (emailAddresses.Count() > 0)
{
foreach (InventoryNotificationEmails email in emailAddresses)
{
listEmails.Add(email.Address);
}
}
}
}
}
if (cbNotifyOther.Checked)
{
var notifyOtherList = ddlNotifyOther.CheckedItems;
if (notifyOtherList.Any())
{
foreach (var item in notifyOtherList)
{
if (item.Text != null)
{
listEmails.Add(item.Text);
}
}
}
}
string emailList = "";
foreach (string email in listEmails)
{
emailList += email + ", ";
}
if (emailList.Length >= 2)
{
if (emailList.Substring(emailList.Length - 2, 2) == ", ")
{
emailList = emailList.Substring(0, emailList.Length - 2);
}
}
lblEmailsSentTo.Text = emailList;
}
public Boolean SendInventoryNotification(List<string> emailList, string bodyHtml, SystemUsers sentUser)
{
try
{
MailMessage completeMessage = new MailMessage();
completeMessage.From = new MailAddress("*****@*****.**");
completeMessage.Subject = "Inventory Approval Notification";
completeMessage.Body = bodyHtml;
completeMessage.IsBodyHtml = true;
//SmtpClient client = new SmtpClient("TingleNT30.wctingle.com");
//client.UseDefaultCredentials = true;
SmtpClient client = new SmtpClient("smtp.gmail.com", 587);
client.Credentials = new NetworkCredential("*****@*****.**", "ZXCasdQWE123!");
client.EnableSsl = true;
using (FormContext ctx = new FormContext())
{
foreach (string email in emailList)
{
InventoryApprovalNotifications newRN = new InventoryApprovalNotifications
{
BodyHtml = bodyHtml,
SentBy = ctx.SystemUsers.FirstOrDefault(x => x.SystemUserID == sentUser.SystemUserID),
Status = 0,
Timestamp = DateTime.Now,
ToEmailAddress = email
};
ctx.InventoryApprovalNotifications.Add(newRN);
ctx.SaveChanges();
try
{
completeMessage.To.Clear();
completeMessage.To.Add(email);
client.Send(completeMessage);
newRN.Status = 1;
ctx.SaveChanges();
}
catch (Exception exc)
{ }
}
}
return true;
}
catch (Exception ex)
{
return false;
}
}
void Application_Start(object sender, EventArgs e)
{
// Code that runs on application startup
BundleConfig.RegisterBundles(BundleTable.Bundles);
AuthConfig.RegisterOpenAuth();
RouteConfig.RegisterRoutes(RouteTable.Routes);
Database.SetInitializer(new MigrateDatabaseToLatestVersion<FormContext, Configuration>());
using (FormContext temp = new FormContext())
{
temp.Database.Initialize(true);
}
}
public bool HasBeenAssigned(SystemUsers user, Int32 formId, string formName)
{
try
{
using (FormContext context = new FormContext())
{
return context.UserAssignments.Any(x => x.User.SystemUserID == user.SystemUserID && x.RelatedFormId == formId && x.Form.FormName == formName);
}
}
catch (Exception ex)
{
return false;
}
}
public bool HasAccess(SystemUsers user, string formName)
{
try
{
using (FormContext ctx = new FormContext())
{
return ctx.FormPermissions.Any(x => x.Enabled == true && x.FormName == formName && x.UserRole.UserRoleId == user.UserRole.UserRoleId);
}
}
catch (Exception ex)
{
return false;
}
}
public bool AddExpeditedOrderForm(string oowOrderNumber, string customer, string accountNumber, ExpediteCode expediteCode, string purchaseOrderNumber, string materialSku, string quantityOrdered,
Nullable<DateTime> installDate, string sM, string contactName, string phoneNumber, string shipToName, string shipToAddress, string shipToCity, string shipToState, string shipToZip,
string additionalInfo, Status status, string submittedByUser, string ccFormToEmail, string company, out Int32 formId)
{
try
{
using (FormContext _db = new FormContext())
{
var expCode = _db.ExpediteCodes.SingleOrDefault(ec => ec.ExpediteCodeID == expediteCode.ExpediteCodeID);
var submissionStatus = _db.Statuses.SingleOrDefault(s => s.StatusId == status.StatusId);
var newForm = new ExpeditedOrderForm();
newForm.Timestamp = DateTime.Now;
newForm.OowOrderNumber = oowOrderNumber;
newForm.Customer = customer;
newForm.AccountNumber = accountNumber;
newForm.ExpediteCode = expCode;
newForm.PurchaseOrderNumber = purchaseOrderNumber;
newForm.InstallDate = installDate;
newForm.SM = sM;
newForm.ContactName = contactName;
newForm.PhoneNumber = phoneNumber;
newForm.ShipToName = shipToName;
newForm.ShipToAddress = shipToAddress;
newForm.ShipToCity = shipToCity;
newForm.ShipToState = shipToState;
newForm.ShipToZip = shipToZip;
newForm.AdditionalInfo = additionalInfo;
newForm.Status = submissionStatus;
newForm.SubmittedByUser = submittedByUser;
newForm.CCFormToEmail = ccFormToEmail;
newForm.Company = company;
_db.ExpeditedOrderForms.Add(newForm);
_db.SaveChanges();
formId = newForm.RecordId;
}
return true;
}
catch (Exception ex)
{
formId = 0;
return false;
//throw ex;
}
}
public void fvEmailInsert_InsertItem()
{
try
{
TextBox txtNameInsert = (TextBox)fvEmailInsert.FindControl("txtNameInsert");
TextBox txtAddressInsert = (TextBox)fvEmailInsert.FindControl("txtAddressInsert");
RadioButtonList rblCompanyInsert = (RadioButtonList)fvEmailInsert.FindControl("rblCompanyInsert");
RadioButtonList rblStatusInsert = (RadioButtonList)fvEmailInsert.FindControl("rblStatusInsert");
Int16 status = Convert.ToInt16(rblStatusInsert.SelectedValue);
int id = Convert.ToInt32(ddlFormName.SelectedValue);
using (FormContext ctx = new FormContext())
{
var tForm = ctx.TForms.Where(f => f.FormID == id).FirstOrDefault();
EmailAddress newEmail = new EmailAddress();
newEmail.Name = txtNameInsert.Text;
newEmail.Address = txtAddressInsert.Text;
newEmail.Company = rblCompanyInsert.SelectedValue;
newEmail.Status = status;
newEmail.TForm = tForm;
newEmail.Timestamp = DateTime.Now;
ctx.EmailAddresses.Add(newEmail);
if (ModelState.IsValid)
{
ctx.SaveChanges();
gvEmailList.DataBind();
}
lblEmailMessage.Text = "";
}
}
catch (Exception ex)
{
lblEmailMessage.Text = "Unable to insert new Email Address. Please contact your system administrator.";
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid)
{
Int32 formId;
int statusId;
DateTime tryDueDate;
Nullable<DateTime> dueDate = null;
string emailListString = lblEmailsSentTo.Text.Replace(" ", "");
List<string> emailList = emailListString.Split(',').ToList<string>();
System.Security.Principal.IPrincipal user = System.Web.HttpContext.Current.User;
UserLogic uLogic = new UserLogic();
SystemUsers currentUser = uLogic.GetCurrentUser(user);
statusId = Convert.ToInt32(ddlStatus.SelectedValue);
if (txtDueByDate.Value != "")
{
DateTime.TryParse(txtDueByDate.Value, out tryDueDate);
if (tryDueDate.Year > 0001)
{
dueDate = tryDueDate;
}
}
else
{
dueDate = null;
}
using (FormContext ctx = new FormContext())
{
var status = ctx.Statuses.Where(s => s.StatusId.Equals(statusId)).FirstOrDefault();
Int32 requestedUserId = Convert.ToInt32(ddlRequestedBy.SelectedValue);
var requestedUser = ctx.SystemUsers.FirstOrDefault(x => x.SystemUserID == requestedUserId);
var modifiedUser = ctx.SystemUsers.FirstOrDefault(x => x.SystemUserID == currentUser.SystemUserID);
Models.LowInventoryForm newForm = new Models.LowInventoryForm
{
Timestamp = DateTime.Now,
Company = ddlCompany.SelectedValue,
OrderNumber = txtOrderNumber.Text,
Plant = ctx.Plants.FirstOrDefault(x => x.PlantText == ddlPlants.SelectedText),
Line = txtLine.Text,
Quantity = txtQuantity.Text,
SKU = txtSKU.Text,
Status = ctx.Statuses.FirstOrDefault(s => s.StatusText == ddlStatus.SelectedItem.Text),
RequestedUser = requestedUser,
LastModifiedUser = modifiedUser,
SubmittedUser = ctx.SystemUsers.FirstOrDefault(x => x.SystemUserID == currentUser.SystemUserID),
DueDate = dueDate,
Priority = ctx.Priorities.FirstOrDefault(x => x.PriorityText == ddlPriority.SelectedText),
LastModifiedTimestamp = DateTime.Now
};
if (ddlAssignedTo.SelectedIndex != -1)
{
Int32 assignedUserId = Convert.ToInt32(ddlAssignedTo.SelectedValue);
newForm.AssignedUser = ctx.SystemUsers.FirstOrDefault(x => x.SystemUserID == assignedUserId);
}
ctx.LowInventoryForms.Add(newForm);
ctx.SaveChanges();
if (newForm.AssignedUser != null)
{
Int32 assignedUserId = Convert.ToInt32(ddlAssignedTo.SelectedValue);
UserAssignmentAssociation uA = new UserAssignmentAssociation
{
Form = ctx.TForms.FirstOrDefault(x => x.FormName == "Low Inventory"),
RelatedFormId = newForm.RecordId,
User = ctx.SystemUsers.FirstOrDefault(x => x.SystemUserID == assignedUserId)
};
ctx.UserAssignments.Add(uA);
}
if (newForm.RequestedUser != null)
{
UserRequestAssociation uR = new UserRequestAssociation
{
Form = ctx.TForms.FirstOrDefault(x => x.FormName == "Low Inventory"),
RelatedFormId = newForm.RecordId,
User = requestedUser
};
ctx.UserRequests.Add(uR);
}
ctx.SaveChanges();
formId = newForm.RecordId;
Comments systemComment = new Comments
{
Form = ctx.TForms.FirstOrDefault(x => x.FormName == "Low Inventory"),
Note = "Request Created By: " + currentUser.DisplayName,
RelatedFormId = formId,
SystemComment = true,
Timestamp = DateTime.Now
};
ctx.Comments.Add(systemComment);
Comments systemComment2 = new Comments
{
Form = ctx.TForms.FirstOrDefault(x => x.FormName == "Low Inventory"),
Note = "Requested By: " + requestedUser.DisplayName,
RelatedFormId = formId,
SystemComment = true,
Timestamp = DateTime.Now
};
ctx.Comments.Add(systemComment2);
if (ddlAssignedTo.SelectedIndex != -1)
{
Comments systemComment3 = new Comments
{
Form = ctx.TForms.FirstOrDefault(x => x.FormName == "Low Inventory"),
Note = "Request Assigned To: " + requestedUser.DisplayName,
RelatedFormId = formId,
SystemComment = true,
Timestamp = DateTime.Now
};
ctx.Comments.Add(systemComment3);
}
if (txtComments.Text != "")
{
Comments firstComment = new Comments
{
Form = ctx.TForms.FirstOrDefault(x => x.FormName == "Low Inventory"),
Note = txtComments.Text,
RelatedFormId = formId,
SystemComment = false,
Timestamp = DateTime.Now,
User = ctx.SystemUsers.FirstOrDefault(x => x.SystemUserID == currentUser.SystemUserID),
};
ctx.Comments.Add(firstComment);
ctx.SaveChanges();
}
if (lblEmailsSentTo.Text != "")
{
Comments notifyComment = new Comments
{
Form = ctx.TForms.FirstOrDefault(x => x.FormName == "Low Inventory"),
Note = "Request Notifications Sent To: " + lblEmailsSentTo.Text,
RelatedFormId = formId,
SystemComment = true,
Timestamp = DateTime.Now
};
ctx.Comments.Add(notifyComment);
ctx.SaveChanges();
TForm submittedForm = ctx.TForms.FirstOrDefault(tf => tf.FormName == "Low Inventory");
SendEmail msg = new SendEmail();
StringBuilder bodyHtml = new StringBuilder();
bodyHtml.AppendLine("<div style=\"width:50%; text-align:center;\"><img src=\"http://www.wctingle.com/img/Logo.jpg\" /><br /><br />")
.Append("A new Low Inventory Request has been submitted.<br /><br />")
.AppendLine("<table style=\"border: 4px solid #d0604c;background-color:#FFF;width:100%;margin-lefT:auto; margin-right:auto;\">")
.AppendLine(" <tr>")
.AppendLine(" <td colspan=\"4\" style=\"text-align: center;vertical-align: middle;font-weight: bold;font-size: 20px;border: 4px solid #d0604c; color:#FFF; background-color:#bc4445;\">Low Inventory Request</td>")
.AppendLine(" </tr>")
.AppendLine(" <tr>")
.AppendLine(" <td style=\"text-align:right;font-size:16px;font-weight:bold;width:25%;color:#bc4445;\">Company:</td>")
.Append(" <td style=\"text-align:left;font-size:16px;font-weight:bold;width:25%;color:#000;\">").Append(ddlCompany.SelectedText).AppendLine("</td>")
.AppendLine(" <td style=\"text-align:right;font-size:16px;font-weight:bold;width:25%; color:#bc4445\"></td>")
.AppendLine(" <td style=\"text-align:left;font-size:16px;font-weight:bold;width:25%;color:#000\"></td>")
.AppendLine(" </tr>")
.AppendLine(" <tr>")
.AppendLine(" <td style=\"text-align:right;font-size:16px;font-weight:bold;width:25%;color:#bc4445;\">Order #:</td>")
.Append(" <td style=\"text-align:left;font-size:16px;font-weight:bold;width:25%;color:#000;\">").Append(txtOrderNumber.Text).AppendLine("</td>")
.AppendLine(" <td style=\"text-align:right;font-size:16px;font-weight:bold;width:25%;color:#bc4445;\">Plant:</td>")
.Append(" <td style=\"text-align:left;font-size:16px;font-weight:bold;width:25%;color:#000;\">").Append(ddlPlants.SelectedText).AppendLine("</td>")
.AppendLine(" </tr>")
.AppendLine(" <tr>")
.AppendLine(" <td style=\"text-align:right;font-size:16px;font-weight:bold;width:25%;color:#bc4445;\">Line:</td>")
.Append(" <td style=\"text-align:left;font-size:16px;font-weight:bold;width:25%;color:#000;\">").Append(txtLine.Text).AppendLine("</td>")
.AppendLine(" <td style=\"text-align:right;font-size:16px;font-weight:bold;width:25%;color:#bc4445;\">Quantity:</td>")
.Append(" <td style=\"text-align:left;font-size:16px;font-weight:bold;width:25%;color:#000;\">").Append(txtQuantity.Text).AppendLine("</td>")
.AppendLine(" </tr>")
.AppendLine(" <tr>")
.AppendLine(" <td style=\"text-align:right;font-size:16px;font-weight:bold;width:25%;color:#bc4445;\">SKU:</td>")
.Append(" <td style=\"text-align:left;font-size:16px;font-weight:bold;width:25%;color:#000;\">").Append(txtSKU.Text).AppendLine("</td>")
.AppendLine(" <td style=\"text-align:right;font-size:16px;font-weight:bold;width:25%;color:#bc4445;\"></td>")
.Append(" <td style=\"text-align:left;font-size:16px;font-weight:bold;width:25%;color:#000;\"></td>")
.AppendLine(" </tr>")
.AppendLine(" <tr>")
.AppendLine(" <td style=\"width:100%;\" colspan=\"4\">")
.AppendLine(" <table style=\"border:none; width:100%\">")
.AppendLine(" <tr>")
.AppendLine(" <td colspan=\"4\">")
.AppendLine(" <span style=\"font-weight:bold; color:#bc4445; text-decoration:underline\">Assignment and Request Details:</span>")
.AppendLine(" </td>")
.AppendLine(" </tr>")
.AppendLine(" <tr>")
.AppendLine(" <td style=\"width:20%; text-align:right\"><span class=\"formRedText\">Requested By:</span></td>")
.Append(" <td style=\"width:25%; text-align:left\">").AppendLine(ddlRequestedBy.SelectedItem.Text)
.AppendLine(" </td>")
.AppendLine(" <td style=\"width:20%; text-align:right\"><span class=\"formRedText\">Assigned To:</span></td>")
.Append(" <td style=\"width:25%; text-align:left\">");
if (ddlAssignedTo.SelectedIndex != -1) { bodyHtml.AppendLine(ddlAssignedTo.SelectedItem.Text); } else { bodyHtml.AppendLine("N/A"); }
bodyHtml.AppendLine(" </td>")
.AppendLine(" </tr>")
.AppendLine(" <tr>")
.AppendLine(" <td style=\"width:18%; text-align:right\"><span class=\"formRedText\">Date Created:</span></td>")
.AppendLine(" <td style=\"width:18%; text-align:left\">")
.AppendLine(DateTime.Now.ToShortDateString())
.AppendLine(" </td>")
.AppendLine(" <td style=\"width:18%; text-align:right\"><span class=\"formRedText\">Due By:</span></td>")
.Append(" <td style=\"width:18%; text-align:left\">").Append(txtDueByDate.Value).AppendLine("</td>")
.AppendLine(" </tr>")
.AppendLine(" <tr>")
.AppendLine(" <td style=\"width:10%; text-align:right\"><span class=\"formRedText\">Status:</span></td>")
.Append(" <td style=\"width:10%; text-align:left\">").AppendLine(ddlStatus.SelectedText)
.AppendLine(" </td>")
.AppendLine(" <td style=\"width:10%; text-align:right\"><span class=\"formRedText\">Priority:</span></td>")
.Append(" <td style=\"width:10%; text-align:left\">").AppendLine(ddlPriority.SelectedText)
.AppendLine(" </td>")
.AppendLine(" </tr>")
.AppendLine(" </table>")
.AppendLine(" </td>")
.AppendLine(" </tr>")
.AppendLine(" <tr>")
.Append(" <td style=\"width:100%; text-align:center\" colspan=\"4\">Created By: ").AppendLine(currentUser.DisplayName)
.AppendLine(" </td>")
.AppendLine(" </tr>")
.AppendLine(" <tr>")
.Append(" <td style=\"width:100%; text-align:center\" colspan=\"4\"><span style=\"color:#bc4445; font-weight:bold\">Request Notifications Sent To:</span> <br />")
.AppendLine(lblEmailsSentTo.Text)
.AppendLine(" </td>")
.AppendLine(" </tr>")
.AppendLine(" <tr>")
.AppendLine(" <td style=\"width:100%; text-align:center\" colspan=\"4\"><br /><br /></td>")
.AppendLine(" </tr>")
.AppendLine("</table><br /><br />");
if (cbSendComments.Checked)
{
bodyHtml.AppendLine("<div style=\"width:80%; color:#bc4445; margin: 0 auto; text-align:center;\">Comments<br /></div>")
.AppendLine("<div style=\"width:80%; background-color:#bc4445; margin: 0 auto; text-align: left; padding:3px; color: white; \">")
.Append(txtComments.Text).AppendLine("<br /><br />")
.AppendLine("<span style=\"padding-right:15px\">").AppendLine(currentUser.DisplayName).AppendLine("</span>")
.AppendLine(DateTime.Now.ToString("MMMM dd, yyyy"))
.AppendLine("</div>");
}
bodyHtml.AppendLine("</div><br /><br />");
bool result = msg.SendMail("*****@*****.**", emailList, "Low Inventory Request", bodyHtml.ToString(), submittedForm, formId, currentUser);
ddlCompany.Enabled = false;
txtOrderNumber.Enabled = false;
ddlPlants.Enabled = false;
txtLine.Enabled = false;
txtQuantity.Enabled = false;
txtSKU.Enabled = false;
ddlRequestedBy.Enabled = false;
ddlAssignedTo.Enabled = false;
txtDueByDate.Disabled = true;
ddlStatus.Enabled = false;
ddlPriority.Enabled = false;
cbNotifyStandard.Enabled = false;
cbNotifyRequester.Enabled = false;
cbNotifyOther.Enabled = false;
cbNotifyAssignee.Enabled = false;
cbSendComments.Enabled = false;
txtComments.Enabled = false;
string pageUrl = Request.Url.AbsoluteUri.Substring(0, Request.Url.AbsoluteUri.Count() - Request.Url.Query.Count());
Response.Redirect(pageUrl + "?FormAction=add&sendEmail=" + result.ToString());
}
else
{
string pageUrl = Request.Url.AbsoluteUri.Substring(0, Request.Url.AbsoluteUri.Count() - Request.Url.Query.Count());
Response.Redirect(pageUrl + "?FormAction=add&sendEmail=NotRequired");
}
}
}
}
catch (Exception ex)
{
pnlCompleted.Visible = true;
pnlForm.Visible = false;
lblMessage.Text = "An error occured during submission of this request. <br /><br />It is possible that the form was completed before this error occurred, <br />so please contact your System Administrator before re-submitting.";
}
}
public IEnumerable<PurchaseOrderStatus> GetPOStatuses()
{
using (FormContext ctx = new FormContext())
{
var StatusList = ctx.POStatuses.ToList();
return StatusList;
}
}
public void FillEmailAddressLabels()
{
lblNotifyAssigneeValue.Text = ddlAssignedTo.SelectedIndex != -1 ? ddlAssignedTo.SelectedItem.Text : "";
lblNotifyRequesterValue.Text = ddlRequestedBy.SelectedIndex != -1 ? ddlRequestedBy.SelectedItem.Text : "";
lblNotifyStandardValue.Text = ddlCompany.SelectedText;
List<String> listEmails = new List<String>();
if (cbNotifyStandard.Checked)
{
using (FormContext ctx = new FormContext())
{
if (ctx.EmailAddresses.Any(x => x.Status == 1 && x.TForm.FormName == "Low Inventory" && x.Company == ddlCompany.SelectedText))
{
ICollection<EmailAddress> emailAddresses = ctx.EmailAddresses.Where(x => x.Status == 1 && x.TForm.FormName == "Low Inventory" && x.Company == ddlCompany.SelectedText).ToList();
if (emailAddresses.Count() > 0)
{
foreach (EmailAddress email in emailAddresses)
{
listEmails.Add(email.Address);
}
}
}
}
}
if (cbNotifyAssignee.Checked)
{
if (lblNotifyAssigneeValue.Text != "")
{
listEmails.Add(lblNotifyAssigneeValue.Text);
}
}
if (cbNotifyRequester.Checked)
{
if (lblNotifyRequesterValue.Text != "")
{
listEmails.Add(lblNotifyRequesterValue.Text);
}
}
if (cbNotifyOther.Checked)
{
var notifyOtherList = ddlNotifyOther.CheckedItems;
if (notifyOtherList.Any())
{
foreach (var item in notifyOtherList)
{
if (item.Text != null)
{
listEmails.Add(item.Text);
}
}
}
}
string emailList = "";
foreach (string email in listEmails)
{
emailList += email + ", ";
}
if (emailList.Length >= 2)
{
if (emailList.Substring(emailList.Length - 2, 2) == ", ")
{
emailList = emailList.Substring(0, emailList.Length - 2);
}
}
lblEmailsSentTo.Text = emailList;
}
protected void btnAddComment_Click(object sender, EventArgs e)
{
try
{
Label lblRecordId = (Label)fvReport.FindControl("lblRecordId");
int recordId;
Int32.TryParse(lblRecordId.Text, out recordId);
RadTextBox txtNewComment = (RadTextBox)fvReport.FindControl("txtNewComment");
Repeater rptrComments = (Repeater)fvReport.FindControl("rptrComments");
UserLogic newLogic = new UserLogic();
System.Security.Principal.IPrincipal user = System.Web.HttpContext.Current.User;
SystemUsers currentUser = newLogic.GetCurrentUser(user);
using (var ctx = new FormContext())
{
var thisForm = ctx.MustIncludeForms.FirstOrDefault(eof => eof.RecordId == recordId);
Comments newComment = new Comments
{
Form = ctx.TForms.FirstOrDefault(x => x.FormName == "Must Include"),
Note = txtNewComment.Text,
RelatedFormId = thisForm.RecordId,
SystemComment = false,
Timestamp = DateTime.Now,
User = ctx.SystemUsers.FirstOrDefault(x => x.SystemUserID == currentUser.SystemUserID)
};
ctx.Comments.Add(newComment);
ctx.SaveChanges();
txtNewComment.Text = "";
txtNewComment.Invalid = false;
rptrComments.DataBind();
}
}
catch (Exception ex)
{
throw;
}
}
protected void ddlCompanyEdit_DataBinding(object sender, EventArgs e)
{
try
{
RadDropDownList ddlCompanyEdit = (RadDropDownList)sender;
Label lblRecordId = (Label)fvReport.FindControl("lblRecordId");
int recordId;
Int32.TryParse(lblRecordId.Text, out recordId);
using (var ctx = new FormContext())
{
var thisForm = ctx.MustIncludeForms.FirstOrDefault(eof => eof.RecordId == recordId);
ddlCompanyEdit.SelectedValue = thisForm.Company;
}
}
catch (Exception ex)
{
throw;
}
}
public IEnumerable<Warehouse> GetWarehouses()
{
using (FormContext ctx = new FormContext())
{
var whList = ctx.Warehouses.ToList();
return whList;
}
}
public void FillEmailAddressLabels()
{
Label lblNotifyAssigneeValue = (Label)fvReport.FindControl("lblNotifyAssigneeValue");
Label lblNotifyRequesterValue = (Label)fvReport.FindControl("lblNotifyRequesterValue");
Label lblNotifyStandardValue = (Label)fvReport.FindControl("lblNotifyStandardValue");
Label lblEmailsSentTo = (Label)fvReport.FindControl("lblEmailsSentTo");
RadComboBox ddlAssignedToEdit = (RadComboBox)fvReport.FindControl("ddlAssignedToEdit");
RadComboBox ddlRequestedByEdit = (RadComboBox)fvReport.FindControl("ddlRequestedByEdit");
RadDropDownList ddlCompanyEdit = (RadDropDownList)fvReport.FindControl("ddlCompanyEdit");
RadComboBox ddlNotifyOther = (RadComboBox)fvReport.FindControl("ddlNotifyOther");
CheckBox cbNotifyStandard = (CheckBox)fvReport.FindControl("cbNotifyStandard");
CheckBox cbNotifyAssignee = (CheckBox)fvReport.FindControl("cbNotifyAssignee");
CheckBox cbNotifyRequester = (CheckBox)fvReport.FindControl("cbNotifyRequester");
CheckBox cbNotifyOther = (CheckBox)fvReport.FindControl("cbNotifyOther");
lblNotifyAssigneeValue.Text = ddlAssignedToEdit.SelectedIndex != -1 ? ddlAssignedToEdit.SelectedItem.Text : "";
lblNotifyRequesterValue.Text = ddlRequestedByEdit.SelectedIndex != -1 ? ddlRequestedByEdit.SelectedItem.Text : "";
lblNotifyStandardValue.Text = ddlCompanyEdit.SelectedText;
List<String> listEmails = new List<String>();
if (cbNotifyStandard.Checked)
{
using (FormContext ctx = new FormContext())
{
if (ctx.EmailAddresses.Any(x => x.Status == 1 && x.TForm.FormName == "Must Include" && x.Company == ddlCompanyEdit.SelectedText))
{
ICollection<EmailAddress> emailAddresses = ctx.EmailAddresses.Where(x => x.Status == 1 && x.TForm.FormName == "Must Include" && x.Company == ddlCompanyEdit.SelectedText).ToList();
if (emailAddresses.Count() > 0)
{
foreach (EmailAddress email in emailAddresses)
{
listEmails.Add(email.Address);
}
}
}
}
}
if (cbNotifyAssignee.Checked)
{
if (lblNotifyAssigneeValue.Text != "")
{
listEmails.Add(lblNotifyAssigneeValue.Text);
}
}
if (cbNotifyRequester.Checked)
{
if (lblNotifyRequesterValue.Text != "")
{
listEmails.Add(lblNotifyRequesterValue.Text);
}
}
if (cbNotifyOther.Checked)
{
var notifyOtherList = ddlNotifyOther.CheckedItems;
if (notifyOtherList.Any())
{
foreach (var item in notifyOtherList)
{
if (item.Text != null)
{
listEmails.Add(item.Text);
}
}
}
}
string emailList = "";
foreach (string email in listEmails)
{
emailList += email + ", ";
}
if (emailList.Length >= 2)
{
if (emailList.Substring(emailList.Length - 2, 2) == ", ")
{
emailList = emailList.Substring(0, emailList.Length - 2);
}
}
lblEmailsSentTo.Text = emailList;
}
public IEnumerable<NotifyOtherList> GetOtherEmails()
{
try
{
using (FormContext ctx = new FormContext())
{
var userList = from s in ctx.SystemUsers
select new NotifyOtherList { Address = s.EmailAddress, Name = s.DisplayName };
var otherList = from n in ctx.NotificationEmailAddresses
select new NotifyOtherList { Address = n.Address, Name = n.Name };
return userList.Union(otherList).ToList().OrderBy(x => x.Name);
}
}
catch (Exception ex)
{
return null;
}
}
protected void fvReport_PreRender(object sender, EventArgs e)
{
Button btnUpdate = (Button)fvReport.FindControl("btnUpdate");
Button btnCancel = (Button)fvReport.FindControl("btnCancel");
Button btnBack = (Button)fvReport.FindControl("btnDetailsBack");
System.Security.Principal.IPrincipal user = System.Web.HttpContext.Current.User;
UserLogic uLogic = new UserLogic();
SystemUsers currentUser = uLogic.GetCurrentUser(user);
RadDropDownList ddlCompanyEdit = (RadDropDownList)fvReport.FindControl("ddlCompanyEdit");
Label lblCompanyEdit = (Label)fvReport.FindControl("lblCompanyEdit");
TextBox txtPOEdit = (TextBox)fvReport.FindControl("txtPOEdit");
TextBox txtArmstrongReferenceEdit = (TextBox)fvReport.FindControl("txtArmstrongReferenceEdit");
TextBox txtPatternEdit = (TextBox)fvReport.FindControl("txtPatternEdit");
TextBox txtLineEdit = (TextBox)fvReport.FindControl("txtLineEdit");
TextBox txtOrderNumberEdit = (TextBox)fvReport.FindControl("txtOrderNumberEdit");
TextBox txtCustomerEdit = (TextBox)fvReport.FindControl("txtCustomerEdit");
TextBox txtWarehouseEdit = (TextBox)fvReport.FindControl("txtWarehouseEdit");
RadDropDownList ddlStatusEdit = (RadDropDownList)fvReport.FindControl("ddlStatusEdit");
RadComboBox ddlRequestedByEdit = (RadComboBox)fvReport.FindControl("ddlRequestedByEdit");
RadComboBox ddlAssignedToEdit = (RadComboBox)fvReport.FindControl("ddlAssignedToEdit");
RadDropDownList ddlPriorityEdit = (RadDropDownList)fvReport.FindControl("ddlPriorityEdit");
HtmlInputText txtDueByDateEdit = (HtmlInputText)fvReport.FindControl("txtDueByDateEdit");
CheckBox cbNotifyStandard = (CheckBox)fvReport.FindControl("cbNotifyStandard");
CheckBox cbNotifyAssignee = (CheckBox)fvReport.FindControl("cbNotifyAssignee");
CheckBox cbSendComments = (CheckBox)fvReport.FindControl("cbSendComments");
CheckBox cbNotifyOther = (CheckBox)fvReport.FindControl("cbNotifyOther");
CheckBox cbNotifyRequester = (CheckBox)fvReport.FindControl("cbNotifyRequester");
RadComboBox ddlNotifyOther = (RadComboBox)fvReport.FindControl("ddlNotifyOther");
RadButton btnAddNewEmail = (RadButton)fvReport.FindControl("btnAddNewEmail");
Button btnAddComment = (Button)fvReport.FindControl("btnAddComment");
FillEmailAddressLabels();
Label lblRecordId = (Label)fvReport.FindControl("lblRecordId");
int recordId;
Int32.TryParse(lblRecordId.Text, out recordId);
Boolean isComplete;
using (var ctx = new FormContext())
{
var thisForm = ctx.MustIncludeForms.FirstOrDefault(eof => eof.RecordId == recordId);
isComplete = thisForm.Status.StatusText == "Completed" ? true : false;
}
if (currentUser.UserRole.RoleName == "ReportsUser" && isComplete)
{
ddlCompanyEdit.Enabled = false;
txtPOEdit.Enabled = false;
txtArmstrongReferenceEdit.Enabled = false;
txtPatternEdit.Enabled = false;
txtLineEdit.Enabled = false;
txtOrderNumberEdit.Enabled = false;
txtCustomerEdit.Enabled = false;
txtWarehouseEdit.Enabled = false;
ddlStatusEdit.Enabled = false;
ddlRequestedByEdit.Enabled = false;
ddlAssignedToEdit.Enabled = false;
ddlPriorityEdit.Enabled = false;
txtDueByDateEdit.Disabled = true;
cbNotifyStandard.Enabled = false;
cbNotifyAssignee.Enabled = false;
cbSendComments.Enabled = false;
cbNotifyOther.Enabled = false;
cbNotifyRequester.Enabled = false;
ddlNotifyOther.Enabled = false;
btnAddNewEmail.Enabled = false;
btnAddComment.Enabled = false;
btnUpdate.Enabled = false;
}
}
public IEnumerable<Status> GetStatuses()
{
FormContext ctx = new FormContext();
var StatusList = ctx.Statuses.ToList();
return StatusList;
}
protected void gvReport_RowDataBound(object sender, GridViewRowEventArgs e)
{
try
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Label lblRecordId = (Label)e.Row.FindControl("lblRecordId");
RadToolTip ttPO = (RadToolTip)e.Row.FindControl("ttPO");
string ltlPOHtml = "";
int recordId = Convert.ToInt32(lblRecordId.Text);
using (FormContext ctx = new FormContext())
{
var thisForm = ctx.MustIncludeForms.FirstOrDefault(x => x.RecordId == recordId);
ltlPOHtml += "<div style=\"border: 4px solid #d0604c; background-color: #FFF;\">Customer: " + thisForm.Customer + "<br /> Line: " + thisForm.Line + "</div>";
ttPO.Text = ltlPOHtml;
}
}
}
catch
{
}
}
public IEnumerable<ExpediteCode> GetExpediteCodes()
{
using (FormContext ctx = new FormContext())
{
var ExpediteCodeList = ctx.ExpediteCodes.Where(c => c.Status == 1).OrderBy(c => c.ExpediteCodeID).Select(c => new { Code = c.Code + " - " + c.Description, ExpediteCodeID = c.ExpediteCodeID }).ToList()
.Select(x => new ExpediteCode { ExpediteCodeID = x.ExpediteCodeID, Code = x.Code });
return ExpediteCodeList;
}
}
public IEnumerable<Priority> GetPriorities()
{
using (FormContext ctx = new FormContext())
{
var priList = ctx.Priorities.ToList();
return priList;
}
}
public void gvSkus_DeleteItem(int RecordId)
{
try
{
using (FormContext ctx = new FormContext())
{
SkuQuantity SkuToDelete = ctx.SkuQuantityItems.FirstOrDefault(x => x.RecordId == RecordId);
if (SkuToDelete != null)
{
ctx.SkuQuantityItems.Remove(SkuToDelete);
ctx.SaveChanges();
}
lblAddSkuMessage.Text = "";
}
}
catch (Exception ex)
{
lblAddSkuMessage.Text = "Unable to delete Material SKU# and Quantity. Please contact your system administrator.";
}
}
public IEnumerable<SystemUsers> GetUsers()
{
using (FormContext ctx = new FormContext())
{
if (ctx.SystemUsers.Any(x => x.Status == 1))
{
var userList = ctx.SystemUsers.Where(x => x.Status == 1).ToList();
return userList.OrderBy(x => x.DisplayName);
}
else
{
return null;
}
}
}
protected void btnAddSkuQuantity_Click(object sender, EventArgs e)
{
try
{
using (FormContext ctx = new FormContext())
{
SkuQuantity newSQ = new SkuQuantity
{
MaterialSku = txtMaterialSku.Text,
Quantity = txtQuantityOrdered.Text,
TempId = lblRandomIdentifier.Text,
Completed = false
};
ctx.SkuQuantityItems.Add(newSQ);
ctx.SaveChanges();
txtMaterialSku.Text = "";
txtQuantityOrdered.Text = "";
}
gvSkus.DataBind();
}
catch (Exception ex)
{
throw;
}
}
public IEnumerable<Comments> rptrComments_GetData()
{
try
{
Label lblRecordId = (Label)fvReport.FindControl("lblRecordId");
int recordId;
Int32.TryParse(lblRecordId.Text, out recordId);
Repeater rptrComments = (Repeater)fvReport.FindControl("rptrComments");
using (FormContext ctx = new FormContext())
{
if (ctx.Comments.Any(x => x.Form.FormName == "Must Include" && x.RelatedFormId == recordId))
{
IEnumerable<Comments> commentsList = ctx.Comments
.Where(x => x.Form.FormName == "Must Include" && x.RelatedFormId == recordId)
.Include(x => x.User)
.OrderByDescending(x => x.RecordId)
.ToList();
return commentsList;
}
}
return null;
}
catch (Exception ex)
{
return null;
}
}
protected void gvSkus_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
GridView gv = (GridView)sender;
GridViewRow gvr = (GridViewRow)gv.Rows[e.RowIndex];
Label lblRecordIdEdit = (Label)gvr.FindControl("lblRecordIdEdit");
int id = Convert.ToInt32(lblRecordIdEdit.Text);
using (FormContext ctx = new FormContext())
{
var sku = ctx.SkuQuantityItems.FirstOrDefault(x => x.RecordId == id);
sku.Completed = ((CheckBox)gvr.FindControl("cbCompletedEdit")).Checked;
sku.MaterialSku = ((TextBox)gvr.FindControl("txtMaterialSkuEdit")).Text;
sku.Quantity = ((TextBox)gvr.FindControl("txtQuantityEdit")).Text;
ctx.SaveChanges();
gvSkus.DataBind();
lblAddSkuMessage.Text = "";
}
}
catch (Exception ex)
{
lblAddSkuMessage.Text = "Unable to update Material SKU# and/or Quantity. Please contact your system administrator.";
}
}
protected void btnInsertEmail_Click(object sender, EventArgs e)
{
RadTextBox txtNameInsert = (RadTextBox)fvReport.FindControl("txtNameInsert");
RadTextBox txtAddressInsert = (RadTextBox)fvReport.FindControl("txtAddressInsert");
RadComboBox ddlNotifyOther = (RadComboBox)fvReport.FindControl("ddlNotifyOther");
RadioButtonList rblNotificationEmailStatusInsert = (RadioButtonList)fvReport.FindControl("rblNotificationEmailStatusInsert");
Label lblInsertEmailMessage = (Label)fvReport.FindControl("lblInsertEmailMessage");
try
{
using (FormContext ctx = new FormContext())
{
if (!ctx.NotificationEmailAddresses.Any(x => x.Name == txtNameInsert.Text || x.Address == txtAddressInsert.Text))
{
if (!ctx.SystemUsers.Any(x => x.EmailAddress == txtAddressInsert.Text))
{
NotificationEmailAddress newEmail = new NotificationEmailAddress();
newEmail.Timestamp = DateTime.Now;
newEmail.Name = txtNameInsert.Text;
newEmail.Address = txtAddressInsert.Text;
newEmail.Status = Convert.ToInt16(rblNotificationEmailStatusInsert.SelectedValue);
ctx.NotificationEmailAddresses.Add(newEmail);
ctx.SaveChanges();
lblInsertEmailMessage.Text = "";
txtAddressInsert.Text = "";
txtNameInsert.Text = "";
rblNotificationEmailStatusInsert.SelectedIndex = 0;
ddlNotifyOther.DataBind();
}
else
{
lblInsertEmailMessage.Text = "A System User already exists with this Email Address. Please enter a unique Email Address.";
}
}
else
{
if (ctx.NotificationEmailAddresses.Any(x => x.Name == txtNameInsert.Text && x.Address == txtAddressInsert.Text))
{
lblInsertEmailMessage.Text = "A Notification Email already exists with this Name and Email Address. Please enter a unique Name and Email Address.";
}
else if (ctx.NotificationEmailAddresses.Any(x => x.Name == txtNameInsert.Text))
{
lblInsertEmailMessage.Text = "A Notification Email already exists with this Name. Please enter a unique Name.";
}
else if (ctx.NotificationEmailAddresses.Any(x => x.Address == txtAddressInsert.Text))
{
lblInsertEmailMessage.Text = "A Notification Email already exists with this Email Address. Please enter a unique Email Address.";
}
}
}
}
catch (Exception ex)
{
lblInsertEmailMessage.Text = "Unable to add this Email Address. Please contact your system administrator.";
}
}
protected void Page_Load(object sender, EventArgs e)
{
UserLogic newLogic = new UserLogic();
System.Security.Principal.IPrincipal user = System.Web.HttpContext.Current.User;
SystemUsers currentUser = newLogic.GetCurrentUser(user);
if (newLogic.HasAccess(currentUser, "Direct Order"))
{
string msg = "";
string formAction = Request.QueryString["FormAction"];
if (!String.IsNullOrEmpty(formAction))
{
if (formAction == "add")
{
msg = "Direct Order Form successfully submitted.";
pnlCompleted.Visible = true;
pnlForm.Visible = false;
}
else
{
msg = "Form Submission Failed. Please try again or contact your System Administrator for more information.";
pnlCompleted.Visible = false;
pnlForm.Visible = true;
}
}
string sendEmail = Request.QueryString["sendEmail"];
if (!String.IsNullOrEmpty(sendEmail))
{
if (sendEmail.ToLower() == "false")
{
msg += " Some or all of the email notifications have failed. Please contact [email protected] for more information.";
}
}
lblMessage.Text = msg;
ddlNotifyOther.OpenDropDownOnLoad = false;
if (!IsPostBack)
{
FillEmailAddressLabels();
lblRandomIdentifier.Text = currentUser.SystemUserID + "_" + Guid.NewGuid();
cbNotifyStandard.Checked = false;
cbNotifyRequester.Checked = false;
cbNotifyOther.Checked = false;
cbNotifyAssignee.Checked = false;
try
{
using (FormContext ctx = new FormContext())
{
ddlExpediteCode.SelectedValue = ctx.ExpediteCodes.FirstOrDefault(x => x.Code == "EXP800").ExpediteCodeID.ToString();
}
}
catch (Exception ex)
{
}
}
}
else
{
Response.Redirect("/Default");
}
}
protected void ddlRequestedByEdit_DataBound(object sender, EventArgs e)
{
try
{
RadComboBox ddlRequestedByEdit = (RadComboBox)sender;
Label lblRecordId = (Label)fvReport.FindControl("lblRecordId");
int recordId;
Int32.TryParse(lblRecordId.Text, out recordId);
using (var ctx = new FormContext())
{
var thisForm = ctx.MustIncludeForms.FirstOrDefault(eof => eof.RecordId == recordId);
ddlRequestedByEdit.SelectedValue = thisForm.RequestedUser.SystemUserID.ToString();
}
}
catch (Exception ex)
{
throw;
}
}
public IEnumerable<Plant> GetPlants()
{
using (FormContext ctx = new FormContext())
{
var plantList = ctx.Plants.ToList();
return plantList;
}
}
