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