protected void btnLogin_Click(object sender, EventArgs e)
{
String Collectpassword = Utility.GetMd5Sum(tbPassword.Text);
Simplicity.Data.SimplicityEntities DatabaseContext = new Simplicity.Data.SimplicityEntities();
Simplicity.Data.User user = (from u in DatabaseContext.Users
where u.Email == tbUserName.Text
&& u.Password == Collectpassword
&& u.Verified == true
&& u.Enabled == true
select u).FirstOrDefault();
if (user != null)
{
var userAuthorisedForThisProduct = user.UserProducts.Where(userProd => userProd.ProductID == int.Parse(AppSettings["HSProductIDInSimplicity"]));
if (userAuthorisedForThisProduct.Count() <= 0)
{
errorPanel.Visible = true;
SetErrorMessage("You are not authorized to use Health And Safety.");
}
else if (userAuthorisedForThisProduct.Count() > 0)
{
Simplicity.Data.Session session = new Simplicity.Data.Session();
session.SessionUID = System.Guid.NewGuid().ToString();
session.User = user;
session.StartTime = DateTime.Now;
session.LastActivityTime = DateTime.Now;
session.EndTime = DateTime.Now.AddMinutes(30);
session.IP = Request.UserHostAddress;
DatabaseContext.AddToSessions(session);
DatabaseContext.SaveChanges();
FormsAuthentication.SetAuthCookie(session.SessionUID, false);
Session[WebConstants.Session.USER_ID] = user.UserID;
Session["userName"] = user.Email;
Session["userFullName"] = user.FullName;
//Session["isTrial"] = user.UserProducts.FirstOrDefault().IsTrial;
Session["sessionID"] = session.SessionUID;
log.Info("User successfully logged in.");
if (Session[WebConstants.Session.RETURN_URL] != null)
{
Response.Redirect((string)Session[WebConstants.Session.RETURN_URL]);
}
else if (Request["GOTO_URL"] != null)
{
Response.Redirect((string)Request["GOTO_URL"]);
}
else
{
Response.Redirect("TermsConditions.aspx", false);
}
}
}
else
{
errorPanel.Visible = true;
SetErrorMessage(WebConstants.Messages.Error.CANNOT_LOGIN);
}
}
protected override void Page_Load_Extended(object sender, EventArgs e)
{
estateAgentDB = new SimplicityWebEstateAgentEntities();
if (!IsPostBack)
{
Simplicity.Data.SimplicityEntities simplicityDB = new Simplicity.Data.SimplicityEntities();
int prodId = int.Parse(AppSettings["EAProductIDInSimplicity"]);
IEnumerable<Simplicity.Data.Company> companies = (from comp in simplicityDB.CompanyProducts where comp.ProductID == prodId select comp.Company);
ddlCompanies.DataSource = companies;
ddlCompanies.DataBind();
if (loggedInUserRole != WebConstants.Roles.Admin)
{
hfCoId.Value = loggedInUserCoId.ToString();
ddlCompanies.Visible = false;
lblCompany.Visible = false;
}
else
{
ddlCompanies.Visible = true;
lblCompany.Visible = true;
hfCoId.Value = ddlCompanies.SelectedValue;
}
int compId = int.Parse(hfCoId.Value);
IEnumerable<EstateAgentEntityModel.RefDepartment> departments = (from dept in estateAgentDB.RefDepartments where dept.CompanySequence == compId && dept.FlgDeleted != true select dept);
GridView1.DataSource = departments;
GridView1.DataBind();
}
}
public static void SendEmail(MailMessage message)
{
try
{
var context = new SimplicityEntities();
string toEmails = "";
string toNames = "";
foreach (MailAddress address in message.To)
{
//toNames += address.DisplayName + ",";
String[] toNameArray = ConfigurationSettings.AppSettings[WebConstants.Config.ADMIN_EMAIL_ADDRESSES].Split(',');
foreach(String k in toNameArray){
toNames += k.Substring(0, k.IndexOf('@') ) + ",";
}
//toEmails += address.Address + ","+
toEmails += ConfigurationSettings.AppSettings[WebConstants.Config.ADMIN_EMAIL_ADDRESSES];
}
var email=new EmailQueue{LogTime=DateTime.Now, NumOfTries=1, FromName="WestGate", FromAddress=FROM_ADDRESS, ToNames=toNames.Substring(0, toNames.Length - 1), ToAddresses=toEmails.Substring(0, toEmails.Length),
Subject = message.Subject,
Body = message.Body,
SentTime = null
};
context.AddToEmailQueues(email);
context.SaveChanges();
SendEmailtoUser(message);
}
catch (Exception ex)
{
}
}
public static void SendEmailtoUser(MailMessage message)
{
try
{
var context = new SimplicityEntities();
string toEmails = "";
string toNames = "";
foreach (MailAddress address in message.To)
{
toNames += address.DisplayName ;
toEmails += address.Address;
}
var email = new EmailQueue
{
LogTime = DateTime.Now,
NumOfTries = 1,
FromName = "WestGate",
FromAddress = FROM_ADDRESS,
ToNames = toNames.Substring(0, toNames.Length - 1),
ToAddresses = toEmails.Substring(0, toEmails.Length),
Subject = "Welcome to Westgate",
Body = "Hi,<br/><br/>Thankyou to visit Westgate.<br/>Your enquiry send to concerned authorities.<br/><br/>Thanks<br/><br/>Westgate Admin.",
SentTime = null
};
context.AddToEmailQueues(email);
context.SaveChanges();
}
catch (Exception ex)
{
}
}
public static List<Simplicity.Data.User> GetCompanyEnableUsers(int companyId)
{
SimplicityEntities DatabaseContext = new SimplicityEntities();
var companyUsers = (from usr in DatabaseContext.Users where usr.CompanyID == companyId && usr.Enabled == true && usr.Verified == true select usr);
List<Simplicity.Data.User> users = companyUsers.ToList();
DatabaseContext.Dispose();
return users;
}
public static EmailTemplate GetEmailTemplate(string name)
{
var context = new SimplicityEntities();
var query = from c in context.EmailTemplates where c.Name == name select c;
if (query.Any())
{
return query.FirstOrDefault();
}
return null;
}
public Boolean checkUser(String UserName, String PassWord)
{
using (var context= new SimplicityEntities())
{
var query = from c in context.Users where ((c.Email== UserName) && (c.Password == PassWord)) select c;
if (query.Any())
{
return true;
}
else {
return false;
}
}
}
public static User GetLoggedInCustomer()
{
if (HttpContext.Current.Session[WebConstants.Session.USER_ID] != null)
{
int userId = (int)HttpContext.Current.Session[WebConstants.Session.USER_ID];
var context = new SimplicityEntities();
var query = from c in context.Users where c.UserID == userId select c;
if (query.Any())
{
return query.FirstOrDefault();
}
}
return null;
}
private void SendEmails(object state)
{
try
{
SmtpClient smtp = new SmtpClient(SMTP_SERVER);
NetworkCredential userInfo = new NetworkCredential(USER_NAME, PASSWORD);
smtp.UseDefaultCredentials = false;
smtp.Credentials = userInfo;
SimplicityEntities DatabaseContext = new SimplicityEntities();
List<EmailQueue> emails = (from e in DatabaseContext.EmailQueues where e.SentTime == null && e.NumOfTries < 5 select e).ToList();
foreach (EmailQueue eq in emails)
{
try
{
MailMessage message = new MailMessage();
message.From = new MailAddress(eq.FromAddress, eq.FromName);
string[] toNames = eq.ToNames.Split(',');
string[] toAddresses = eq.ToAddresses.Split(',');
for (int index = 0; index < toAddresses.Length; index++)
{
if (toAddresses[index].Length > 0)
{
message.To.Add(new MailAddress(toAddresses[index], toNames[index]));
}
}
message.Subject = eq.Subject;
message.Body = eq.Body;
message.IsBodyHtml = true;
smtp.Send(message);
eq.SentTime = DateTime.Now;
Log("Queue Id:" + eq.QueueID + " processed.", EventLogEntryType.Information);
}
catch (Exception ex)
{
Log("Queue Id:" + eq.QueueID + " errored.", EventLogEntryType.Error);
Log(ex.ToString(), EventLogEntryType.Error);
}
eq.NumOfTries++;
}
DatabaseContext.SaveChanges();
}
catch (Exception ex)
{
//Log("Connection String:);
Log(ex.ToString(), EventLogEntryType.Error);
}
}
public Boolean UserExist(String UserName)
{
using (var context = new SimplicityEntities())
{
var query = from c in context.Users where (c.Email == UserName) select c;
if (query.Any())
{
return true;
}
else
{
return false;
}
}
}
public Boolean CreateAccount(String nEmail,String nPassword,String nType)
{
if (!this.UserExist(nEmail))
{
using (var context = new SimplicityEntities())
{
var user = new User { UserUID=Guid.NewGuid().ToString(),ReceiveEmails=false,Deleted=false,OnHold=false ,Email = nEmail,Password=nPassword,Verified=false, Enabled=false, Locked=false, CreationDate=DateTime.Now,Type=nType };
context.AddToUsers(user);
context.SaveChanges();
}
return true;
}
else {
return false;
}
}
protected override void Page_Load_Extended(object sender, EventArgs e)
{
Simplicity.Data.SimplicityEntities simplicityDB = new Simplicity.Data.SimplicityEntities();
int prodId = int.Parse(AppSettings["EAProductIDInSimplicity"]);
IEnumerable<Simplicity.Data.Company> companies = (from comp in simplicityDB.CompanyProducts where comp.ProductID == prodId select comp.Company);
ddlCompany.DataSource = companies;
ddlCompany.DataBind();
if (loggedInUserRole != WebConstants.Roles.Admin)
{
ddlCompany.SelectedValue = loggedInUserCoId.ToString();
lblCompany.Visible = false;
ddlCompany.Visible = false;
}
if (Request[WebConstants.Request.NO_CATEGORY] != null)//to do
{
SetErrorMessage(WebConstants.Messages.Error.NO_CATEGORY_DEFINED);
}
if (Request[WebConstants.Request.CATEGORY_ID] != null)
{
if (IsPostBack == false)
{
SimplicityWebEstateAgentEntities estateAgentDB = new SimplicityWebEstateAgentEntities();
int categId = int.Parse(Request[WebConstants.Request.CATEGORY_ID]);
EstateAgentEntityModel.RefCategory category = estateAgentDB.RefCategories.SingleOrDefault(categ => categ.Sequence == categId);
if (category != null)
{
ddlCompany.SelectedValue = category.CompanySequence.ToString();
ddlCompany.Enabled = false;
txtCategoryDescription.Text = category.CategoryDesc;
btnUpdate.Visible = true;
btnSave.Visible = false;
}
else
{
SetErrorMessage(WebConstants.Messages.Error.INVALID_ID);
}
}
}
else
{
btnUpdate.Visible = false;
btnSave.Visible = true;
}
}
protected override void OnLoad(EventArgs e)
{
Response.Cache.SetCacheability(HttpCacheability.NoCache);
SetErrorMessage("");
SetInfoMessage("");
Simplicity.Data.SimplicityEntities DatabaseContext = new Simplicity.Data.SimplicityEntities();
if (User.Identity.IsAuthenticated)
{
Simplicity.Data.Session session = (from s in DatabaseContext.Sessions where s.SessionUID == User.Identity.Name select s).FirstOrDefault();
if (session != null && session.User != null)
{
loggedInUser = session.User;
session.LastActivityTime = DateTime.Now;
session.EndTime = DateTime.Now.AddMinutes(30);
session.IP = Request.UserHostAddress;
session.ProductID = int.Parse(AppSettings["EAProductIDInSimplicity"]);
DatabaseContext.SaveChanges();
}
}
}
/*public static SimplicityCommLib.DataSets.Common.Products.ProductsRow GetProduct(int productId)
{
//Products.ProductEntityRow product = null;
SimplicityCommLib.DataSets.Common.ProductsTableAdapters.ProductsTableAdapter prodTA = new SimplicityCommLib.DataSets.Common.ProductsTableAdapters.ProductsTableAdapter();
IEnumerator<SimplicityCommLib.DataSets.Common.Products.ProductsRow> products = prodTA.GetProductById(productId).GetEnumerator();
if (products.MoveNext())
{
return products.Current;
}
else
return null;
}*/
public static ExchangeRate GetExchangeRate(string countryCode)
{
var dbContext = new SimplicityEntities();
return (from er in dbContext.ExchangeRates where er.CountryCode == countryCode select er).FirstOrDefault();
}
private void Process()
{
if (User.Identity.IsAuthenticated)
{
databaseContext = new SimplicityEntities();
Simplicity.Data.Session session = (from ses in databaseContext.Sessions where ses.SessionUID == User.Identity.Name select ses).FirstOrDefault();
int EAProductId = int.Parse(AppSettings["EAProductIDInSimplicity"]);
Session[WebConstants.Session.SIMPLICITY_USER_ID] = session.User.UserID;
Session[WebConstants.Session.USER_ID] = session.User.UserID;
Session[WebConstants.Session.USER_ROLE] = WebConstants.Roles.User;
loggedInUserRole = WebConstants.Roles.User;
loggedInUserId = session.User.UserID;
if (session.User.Company != null)
{
Session[WebConstants.Session.SIMPLICITY_COMPANY_ID] = session.User.Company.CompanyID;
Session[WebConstants.Session.USER_CO_ID] = session.User.Company.CompanyID;
Session[WebConstants.Session.COMPANY_NAME] = session.User.Company.Name;
loggedInUserCoId = session.User.Company.CompanyID;
var userAuthorisedForThisProduct = session.User.UserProducts.Where(userProd => userProd.ProductID == EAProductId);
if (userAuthorisedForThisProduct.Count() <= 0)
{
Response.Redirect(AppSettings["SimplicityErrorURL"] + "?" + "message" + "=You are not authorized to access Estate Agent");
}
//going to check for licenses
List<CompanyProduct> companyProducts = (from cp in databaseContext.CompanyProducts where cp.CompanyID == session.User.Company.CompanyID && cp.ProductID == EAProductId select cp).ToList<CompanyProduct>();
int numOfLicenses = 0;
foreach (CompanyProduct cp in companyProducts)
{
if (cp.EndDate.CompareTo(DateTime.Now) >= 0)
{
numOfLicenses = numOfLicenses + cp.NumOfLicenses;
}
}
if (numOfLicenses > 0)//check for available licenses now
{
int numOfUsedLicenses = 0;
var check = (from userTable in databaseContext.Users where userTable.CompanyID == session.User.Company.CompanyID select userTable).ToList() ;
List<Session> userSessions = (from ses in databaseContext.Sessions where ses.ProductID == EAProductId && (from userTable in databaseContext.Users where userTable.CompanyID == session.User.Company.CompanyID select userTable.UserID).Contains(ses.UserID) && DateTime.Compare(DateTime.Now,ses.LastActivityTime)>30 && ses.SessionID != session.SessionID select ses).ToList<Session>();
foreach (Session ses in userSessions)
{
numOfUsedLicenses = numOfUsedLicenses + 1;
}
if (numOfLicenses - numOfUsedLicenses > 0)
{
//GoToPage(companies.Current.flg_show_wizard, companies.Current.co_id, users.Current);
}
else
{
Response.Redirect(AppSettings["SimplicityErrorURL"] + "?" + "message" + "=All licenses are consumed right now. Please try later");
}
}
else //check if trial version is available
{
bool isTrial = false;
List<UserProduct> userProducts = (from up in databaseContext.UserProducts where up.UserID == session.User.UserID && up.ProductID == EAProductId select up).ToList<UserProduct>();
foreach (UserProduct up in userProducts)
{
if (up.EndDate.CompareTo(DateTime.Now) >= 0)
{
isTrial = true;
Session["isTrial"] = isTrial;
break;
}
}
if (!isTrial)
{
Response.Redirect(AppSettings["SimplicityErrorURL"] + "?" + "message" + "=You are not authorized to access Estate Agent");
}
else
{
//GoToPage(companies.Current.flg_show_wizard, companies.Current.co_id, users.Current);
}
}
}
else
{
Response.Redirect(AppSettings["SimplicityErrorURL"] + "?" + "message" + "=You have no company assigned. Please contact administrator");
}
}
else
{
Response.Redirect("~/Login.aspx" + "?" + WebConstants.Request.SESSION_EXPIRED + "=true&GOTO_URL=" + Request.Url);
}
}
protected void UserProductMapDetailUpdate_Click(object sender, EventArgs e)
{
System.Diagnostics.Debug.WriteLine(UsrProdNewMapValues);
SimplicityEntities DatabaseContext = new SimplicityEntities();
int companyId = company.CompanyID;
String [] selectedUsersAndProds = UsrProdNewMapValues.Value.Split(',');
int totalSelectedUsersAndProducts = selectedUsersAndProds.Length;
Dictionary<int, List<int>> usersGroupByProduct = new Dictionary<int, List<int>>();
for (int i = 0; i < totalSelectedUsersAndProducts - 1; i++) {
String[] parsedId = selectedUsersAndProds[i].Split('_');
int userId = Int32.Parse(parsedId[2]);
int prodId = Int32.Parse(parsedId[3]);
if (usersGroupByProduct.ContainsKey(prodId) == false) {
List<int> usersOfSameProduct = new List<int>();
usersGroupByProduct.Add(prodId, usersOfSameProduct);
}
List<int> usersOfSameProductValue = null;
if (usersGroupByProduct.TryGetValue(prodId, out usersOfSameProductValue) == true)
usersOfSameProductValue.Add(userId);
}
List<int> allCompanyProds = company.CompanyProducts.Select(cmpProd => cmpProd.ProductID).ToList();
foreach (int prodId in allCompanyProds)
{
if (usersGroupByProduct.ContainsKey(prodId) == true)
{
List<int> usersOfSameProduct = usersGroupByProduct[prodId];
var userUsingProductID = from usrProd in DatabaseContext.UserProducts where usrProd.User.CompanyID == companyId && usrProd.ProductID == prodId && usrProd.IsTrial == false select usrProd;
var userIdOdUsersUsingProductID = userUsingProductID.Select(users => users.UserID);
var myUsers = userIdOdUsersUsingProductID.Except(usersOfSameProduct);
if (myUsers != null && myUsers.Count() > 0)
{
var usersToDelete = userUsingProductID.Where(usersOfProduct => myUsers.Where(usr => usr == usersOfProduct.UserID).Any());// usersOfProduct.UserID == myUsers);
foreach (UserProduct userProduct in usersToDelete)
DatabaseContext.UserProducts.DeleteObject(userProduct);
}
}
else {
var companyUsersUsingProduct = from usrProd in DatabaseContext.UserProducts where usrProd.User.CompanyID == companyId && usrProd.ProductID == prodId && usrProd.IsTrial == false select usrProd;
foreach (UserProduct userProduct in companyUsersUsingProduct)
DatabaseContext.UserProducts.DeleteObject(userProduct);
}//if there is only one user using the product and admin removes it.
}//remove users using the products first so licences can be made available to other users.
DatabaseContext.SaveChanges();
foreach (int prodId in usersGroupByProduct.Keys) {
int noOfLicencesForProduct = 0;
var userUsingProduct = from usrProd in DatabaseContext.UserProducts where usrProd.User.CompanyID == companyId && usrProd.ProductID == prodId && usrProd.IsTrial == false select usrProd;
var companyProd = company.CompanyProducts.Where(compProd => compProd.ProductID == prodId);
List<int> newUsersUsingProduct = usersGroupByProduct[prodId];
foreach (int userId in newUsersUsingProduct) {
var usrProd = userUsingProduct.Where(usrExist => usrExist.UserID == userId);
if (usrProd != null && usrProd.Count() > 0)
{
continue;
}
else {
if (companyProd != null)
{
foreach (Simplicity.Data.CompanyProduct companyProduct in companyProd)
{
UserProduct newUsrOfProd = null;
noOfLicencesForProduct = companyProduct.NumOfLicenses;
if (userUsingProduct.Count() < noOfLicencesForProduct)
{
newUsrOfProd = new UserProduct();
newUsrOfProd.UserID = userId;
newUsrOfProd.ProductID = prodId;
newUsrOfProd.IsTrial = false;
newUsrOfProd.StartDate = DateTime.Now;
newUsrOfProd.EndDate = DateTime.Now.AddYears(1);
DatabaseContext.UserProducts.AddObject(newUsrOfProd);
DatabaseContext.SaveChanges();
}
else {
SetErrorMessage("No. of users are greater than No. of Licenses for " + companyProduct.Product.Name);
}
break;
}//there should be only one product. So loop will run only once.
}
}
}
}
DatabaseContext.Dispose();
updateUserProdMapTable();
}
private void updateUserProdMapTable()
{
TableHeaderRow tbHeaderRow1 = new TableHeaderRow();
TableHeaderCell tbHeaderCell = null;
List<CompanyProduct> validCompanyProducts = company.CompanyProducts.Where(compProd=> compProd.EndDate.CompareTo(DateTime.Now) >= 0 && compProd.StartDate.CompareTo(DateTime.Now) <= 0).ToList();
foreach(CompanyProduct prod in validCompanyProducts){
tbHeaderCell = new TableHeaderCell();
tbHeaderCell.BorderWidth = 1;
tbHeaderCell.BorderColor = System.Drawing.Color.Black;
tbHeaderCell.Text = prod.Product.Name+"<br>"+prod.NumOfLicenses;
tbHeaderCell.Attributes.Add("licences", prod.NumOfLicenses.ToString());
tbHeaderCell.Attributes.Add("productId", prod.ProductID.ToString());
//tbHeaderCell.Width = 150;
tbHeaderCell.ID = prod.ProductID.ToString();
tbHeaderRow1.Cells.Add(tbHeaderCell);
}
UserProdMapTable.Rows.Add(tbHeaderRow1);
UserProdMapTable.BorderWidth = 1;
UserProdMapTable.BorderColor = System.Drawing.Color.Black;
int totalProducts = validCompanyProducts.Count();
int companyId = company.CompanyID;
List<Simplicity.Data.User> compEnabledUsers = Utilities.DatabaseUtility.GetCompanyEnableUsers(companyId);
SimplicityEntities DatabaseContext = new SimplicityEntities();
int index = 0;
foreach (Simplicity.Data.User usr in compEnabledUsers)
{
TableRow row = new TableRow();
if(index % 2 == 0)
row.BackColor = System.Drawing.Color.FromArgb(240, 240, 240);
index++;
foreach(Simplicity.Data.CompanyProduct prod in validCompanyProducts)
{
var userUsingProduct = from usrProd in DatabaseContext.UserProducts where usrProd.User.CompanyID == companyId && usrProd.ProductID == prod.ProductID && usrProd.IsTrial == false select usrProd;
TableCell cell = new TableCell();
try {
Simplicity.Data.UserProduct productUser = (from prodUser in userUsingProduct where prodUser.UserID == usr.UserID select prodUser).FirstOrDefault();
if(productUser != null ){
cell.CssClass = "UserProdMappingTable-AssignedProd";
}
}catch(Exception ex){
}
cell.HorizontalAlign = HorizontalAlign.Center;
cell.VerticalAlign = VerticalAlign.Middle;
cell.BorderWidth = 1;
cell.BorderColor = System.Drawing.Color.Black;
cell.ID = usr.UserID + "_" + prod.ProductID;
cell.Text = usr.Email;
//cell.Text = "<div style=\"display:inline;float:left;margin-right:10px; \">" + usr.Email + "</div>" +
// "<div style=\"background-color:black;float:right;display:inline-block;width:20px;border:medium none black;\"> </div>";
if(cell.CssClass.CompareTo("")==0)
cell.CssClass = prod.ProductID.ToString();
else
cell.CssClass += " " + prod.ProductID.ToString();
//cell.Width = 150;
row.Cells.Add(cell);
}
UserProdMapTable.Rows.Add(row);
}
DatabaseContext.Dispose();
}
public bool Process(Page page,ref int loggedInUserId, ref int loggedInUserCoId, ref string loggedInUserRole)
{
bool authenticated = false;
if (bool.Parse(AppSettings["UseFormsAuthentication"]) == false)
{
if (HttpContext.Current.Session[WebConstants.Session.USER_ID] == null)
{
HttpContext.Current.Session[WebConstants.Session.RETURN_URL] = HttpContext.Current.Request.Url;
HttpContext.Current.Response.Redirect("~/Login.aspx?" + WebConstants.Request.SESSION_EXPIRED + "=true");
}
else
{
loggedInUserId = (int)HttpContext.Current.Session[WebConstants.Session.USER_ID];
authenticated = true;
}
}
else
{
if (page.User.Identity.IsAuthenticated )
{
SimplicityEntities databaseContext = new SimplicityEntities();
Simplicity.Data.Session session = (from ses in databaseContext.Sessions where ses.SessionUID == page.User.Identity.Name select ses).FirstOrDefault();
int HSProductId = int.Parse(AppSettings["HSProductIDInSimplicity"]);
UserTableAdapters.un_co_user_detailsTableAdapter userTa = new UserTableAdapters.un_co_user_detailsTableAdapter();
IEnumerator<User.un_co_user_detailsRow> users = userTa.GetBySimplicityID(session.User.UserID).GetEnumerator();
if (users.MoveNext())
{
authenticated = true;
loggedInUserId = users.Current.user_id;
/*if (HttpContext.Current.Cache[loggedInUserId.ToString()] == null)
{
HandlePostLoginProcess(users.Current.user_id, users.Current.role, users.Current.co_id);
}*/
}
else
{
HttpContext.Current.Session[WebConstants.Session.RETURN_URL] = HttpContext.Current.Request.Url;
HttpContext.Current.Response.Redirect("~/Login.aspx?" + WebConstants.Request.SESSION_EXPIRED + "=true");
}
}
else
{
HttpContext.Current.Session[WebConstants.Session.RETURN_URL] = HttpContext.Current.Request.Url;
HttpContext.Current.Response.Redirect("~/Login.aspx?" + WebConstants.Request.SESSION_EXPIRED + "=true");
}
}
if(authenticated)
{
if (HttpContext.Current.Session[WebConstants.Session.USER_ID] == null)
{
HttpContext.Current.Session[WebConstants.Session.RETURN_URL] = HttpContext.Current.Request.Url;
HttpContext.Current.Response.Redirect("~/Login.aspx?" + WebConstants.Request.INVALID_CACHE + "=true");
}
else
{
if (HttpContext.Current.Session[WebConstants.Session.USER_CO_ID] != null)
{
loggedInUserCoId = (int)HttpContext.Current.Session[WebConstants.Session.USER_CO_ID];
}
else
{
//Admin roles dont need a co.
loggedInUserCoId = 0;
}
if (HttpContext.Current.Session[WebConstants.Session.USER_ROLE] == null)
{
loggedInUserRole = WebConstants.Roles.User;
}
else
{
loggedInUserRole = (string)HttpContext.Current.Session[WebConstants.Session.USER_ROLE];
}
return true;
}
}
return false;
}
public static Product GetProduct(int productId)
{
var dbContext = new SimplicityEntities();
return (from p in dbContext.Products where p.ProductID == productId select p).FirstOrDefault();
}
public static Simplicity.Data.Version GetVersion(int versionId)
{
var dbContext = new SimplicityEntities();
return (from v in dbContext.Versions where v.VersionID == versionId select v).FirstOrDefault();
}
public static ProductDetail GetProductDetail(int productDetailId)
{
var dbContext = new SimplicityEntities();
return (from pd in dbContext.ProductDetails where pd.ProductDetailID == productDetailId select pd).FirstOrDefault();
}
public static void SendEmail(MailMessage message)
{
try
{
var context = new SimplicityEntities();
string toEmails = "";
string toNames = "";
foreach (MailAddress address in message.To)
{
toNames += address.DisplayName + ",";
toEmails += address.Address + ",";
}
var email=new EmailQueue{LogTime=DateTime.Now, NumOfTries=1, FromName="Simplicity4Business", FromAddress=FROM_ADDRESS, ToNames=toNames.Substring(0, toNames.Length - 1), ToAddresses=toEmails.Substring(0, toEmails.Length),
Subject=message.Subject, Body=message.Body, SentTime=null};
context.AddToEmailQueues(email);
context.SaveChanges();
}
catch (Exception ex)
{
}
}
private void UpdateTrialLicense()
{
CompanyTableAdapters.un_co_detailsTableAdapter compTA = new CompanyTableAdapters.un_co_detailsTableAdapter();
if (Session[WebConstants.Session.REGISTERING_FOR_TRIAL] != null)
{
compTA.CompanyTrialUpdate((int)Session[WebConstants.Session.SIMPLICITY_COMPANY_ID], true);
Simplicity.Data.SimplicityEntities simplicityDatabaseContext = new Simplicity.Data.SimplicityEntities();
int userId = (int)Session[WebConstants.Session.SIMPLICITY_USER_ID];
Simplicity.Data.UserProduct userProduct = (from userProd in simplicityDatabaseContext.UserProducts where userProd.ProductID == 2 && userProd.UserID == userId select userProd).FirstOrDefault();
if (userProduct == null)
{
userProduct = new Simplicity.Data.UserProduct();
userProduct.UserID = userId;
userProduct.ProductID = 2;
simplicityDatabaseContext.AddToUserProducts(userProduct);
}
userProduct.IsTrial = true;
userProduct.StartDate = DateTime.Now;
userProduct.EndDate = DateTime.Now.AddDays(15);
simplicityDatabaseContext.SaveChanges();
}
else
{
compTA.CompanyTrialUpdate((int)Session[WebConstants.Session.SIMPLICITY_COMPANY_ID], false);
}
}