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