///New Product confirmation Mail public static bool SendProductOrderedMail(string language, Guid? uId, Guid? pId) { Tag4sEntities db = new Tag4sEntities(); var user = db.UserPasswords.Find(uId); var invoice = db.Invoices.Find(pId) ?? user.User.Invoices.OrderByDescending(row => row.Date).FirstOrDefault(); if (invoice == null) invoice = new Invoice(); if (String.IsNullOrWhiteSpace(user.EmailAddress)) return false; var message = new MailMessage(); var systemEmailAddress = db.Applications.Single(r => r.Description == language).SystemEmailAddress; message.From = new System.Net.Mail.MailAddress(systemEmailAddress); message.To.Add(new System.Net.Mail.MailAddress(user.EmailAddress)); message.Bcc.Add(new System.Net.Mail.MailAddress(systemEmailAddress)); message.Subject = db.Applications.Single(r => r.Description == language).TemplateProductOrderedSubject; string messageBody = db.Applications.Single(r => r.Description == language).TemplateProductOrdered; messageBody = messageBody.Replace("[volledige naam]", user.FullName); messageBody = messageBody.Replace("[LaatsteFaktuur]", invoice.Amount.ToString()); messageBody = messageBody.Replace("[Crediet]", user.User.Credit.ToString()); messageBody = messageBody.Replace("[Bedrijfsnaam]", user.User.Organisation); messageBody = messageBody.Replace("[Emailadres]", systemEmailAddress); message.Body = messageBody; SendMailMessage(message); return true; }
// // GET: /Q/ public ActionResult Index(string id) { //www.tag4s.com/q?aaaggg if (Request["id"] != null) { try { string eId = Request["id"]; using (var db = new Tag4sEntities()) { var userContract = db.UserContracts.FirstOrDefault(u => u.eId == eId); if (userContract != null) { var redirectURI = "/redirect/index/{0}"; Response.Redirect(String.Format(redirectURI, userContract.Id.ToString()), true); } } } catch { } } return null; }
public static IEnumerable<Contract> Contracts1() { using (var te = new Tag4sEntities()) { var contracts = te.Contracts.Where(c => c.Id != null); return contracts.ToList(); } }
private string GetDisplay(ref Tag4sEntities db, ViewFilterKeys key, Guid id) { switch (key) { case ViewFilterKeys.genderid: return db.Genders.Find(id).Name; case ViewFilterKeys.nofilter: default: return string.Empty; } }
// To Do: Add a From and To to the email; public static bool SendMail(string senderEmail, string recipientEmail, string messageTitle, string messageBody) { Tag4sEntities db = new Tag4sEntities(); var message = new MailMessage(); message.From = new System.Net.Mail.MailAddress(senderEmail); //TO DO: add multiple emails to Sender. message.To.Add(new System.Net.Mail.MailAddress(recipientEmail)); message.Subject = messageTitle; message.Body = "<html><head><meta content=\"text/html;charset=utf-8\" /></head><body><p>" + messageBody + "</p></body></html>"; SendMailMessage(message); return true; }
///Password Reset confirmation Mail public static bool SendConfirmationMail(string language, Guid? uId, bool sendBcc = true) { Tag4sEntities db = new Tag4sEntities(); var user = db.UserPasswords.Find(uId); var message = new MailMessage(); //var verifyUrl = System.Web.HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority) + "/User/PasswordReset"; if (String.IsNullOrWhiteSpace(user.EmailAddress)) return false; var systemEmailAddress = db.Applications.FirstOrDefault().SystemEmailAddress; message.From = new System.Net.Mail.MailAddress(systemEmailAddress); message.To.Add(new System.Net.Mail.MailAddress(user.EmailAddress)); if (sendBcc) { message.Bcc.Add(new System.Net.Mail.MailAddress(systemEmailAddress)); } string password = user.Password; message.Subject = db.Applications.Single(r => r.Description == language).TemplateUserForgotPasswordSubject; string messageBody = db.Applications.Single(r => r.Description == language).TemplateUserForgotPassword; messageBody = messageBody.Replace("[volledige naam]", user.FullName); messageBody = messageBody.Replace("[Wachtwoord]", password); messageBody = messageBody.Replace("[wachtwoord]", password); messageBody = messageBody.Replace("[Gebruikersnaam]", user.UserName); messageBody = messageBody.Replace("[Bedrijfsnaam]", user.User.Organisation); messageBody = messageBody.Replace("[Emailadres]", systemEmailAddress); message.Body = messageBody; //message.Body = "<html><head><meta content=\"text/html;charset=utf-8\" /></head><body><p>Dear " + user.RealName // + ", </p><p>An account has been created with the following details:</p>" // + "<p>User: "******"<br>Password: "******"<br>License: " + user.License.Name // + "<br>You will be promted to change your random password at your first login.</p><div>Best regards,</div><div>Someone</div><p>Do not forward " // + "this email.</p></body></html>"; SendMailMessage(message); return true; }
public static List<SelectListItem> Contracts(Guid? id) { using (var te = new Tag4sEntities()) { var contracts = te.Contracts.Where(c => c.Id != null); List<SelectListItem> list = new List<SelectListItem>(); foreach (var contract in contracts) { bool selected = false; if (id.HasValue) selected = id.Value == contract.Id; SelectListItem newItem = new SelectListItem { Selected = selected, Text = contract.Name, Value = contract.Id.ToString() }; list.Add(newItem); } return list; } }
///New User confirmation Mail public static bool SendUserRegisteredMail(string language, Guid? uId, bool sendBcc = true) { Tag4sEntities db = new Tag4sEntities(); var user = db.UserPasswords.Find(uId); if (String.IsNullOrWhiteSpace(user.EmailAddress)) return false; var message = new MailMessage(); var systemEmailAddress = db.Applications.Single(r => r.Description == language).SystemEmailAddress; message.From = new System.Net.Mail.MailAddress(systemEmailAddress); message.To.Add(new System.Net.Mail.MailAddress(user.EmailAddress)); if (sendBcc) { message.Bcc.Add(new System.Net.Mail.MailAddress(systemEmailAddress)); } string password = user.Password.DecodeString(); message.Subject = db.Applications.Single(r => r.Description == language).TemplateUserRegisteredSubject; string messageBody = db.Applications.Single(r => r.Description == language).TemplateUserRegistered; messageBody = messageBody.Replace("[volledige naam]", user.FullName); messageBody = messageBody.Replace("[Wachtwoord]", password); messageBody = messageBody.Replace("[Gebruikersnaam]", user.UserName); messageBody = messageBody.Replace("[Bedrijfsnaam]", user.User.Organisation); messageBody = messageBody.Replace("[Emailadres]", systemEmailAddress); message.Body = messageBody; SendMailMessage(message); return true; }
public static IEnumerable<User> Resellers(bool isBeheerder, User user = null) { using (var te = new Tag4sEntities()) { //te.Connection.Open(); IEnumerable<User> result; if (user != null) { if (user.UserRole.Name == "Klant") { result = te.Users.Where(u => u.Id == user.ReselerId).ToList(); return result; } if (user.UserRole.Name == "Reseller") { result = te.Users.Where(u => u.Id == user.ReselerId).ToList(); return result; } } if (isBeheerder) result = te.Users.Where(u => u.Id == null).ToList(); else result = te.Users.Where(u => u.UserRole.Name.Equals("Beheerder") || u.UserRole.Name.Equals("Reseller")).ToList(); return result; } }
public static IEnumerable<Weekday> WeekDays(ref Dictionary<string, string> translationdictionary) { using (var te = new Tag4sEntities()) { var weekdays = te.Weekdays.Where(c => c.Id != null).ToList(); foreach (var weekday in weekdays) { weekday.Name = weekday.Name.TranslateString(ref translationdictionary); } return weekdays.ToList(); } }
public static IEnumerable<UserRole> UserRoles(bool isBeheerder, User user = null) { using (var te = new Tag4sEntities()) { IEnumerable<UserRole> result; if (user != null) { if (user.UserRole.Name == "Klant") { result = te.UserRoles.Where(u => u.Name.Equals("Klant")).ToList(); return result; } if (user.UserRole.Name == "Reseller") { result = te.UserRoles.Where(u => u.Name.Equals("Klant")).ToList(); return result; } } if (isBeheerder) result = te.UserRoles.Where(u => u.Name.Equals("Beheerder")).ToList(); else result = te.UserRoles.Where(u => !u.Name.Equals("Beheerder")).ToList(); //te.Connection.Close(); return result; } }
public static List<SelectListItem> UserRoles(Guid id) { using (var te = new Tag4sEntities()) { var userRoles = te.UserRoles.Where(u => u.Id != null); List<SelectListItem> list = new List<SelectListItem>(); foreach (var userRole in userRoles) { SelectListItem newItem = new SelectListItem { Selected = userRole.Id == id, Text = userRole.Name, Value = userRole.Id.ToString() }; list.Add(newItem); } return list; } }
public ViewFilter(ref Tag4sEntities db, ViewFilterKeys key, Guid id) { Key = key; Id = id; Display = GetDisplay(ref db, key, id); }