private static List <SelectListItem> getevent(int CustomerId, string eventid) { EventRegistrationEntities entities = new EventRegistrationEntities(); var eventids = entities.EventMasters.Where(x => x.CustomerId == CustomerId).Select(x => x.EventId).ToList(); var eventusereventids = entities.EventUsers.Where(x => x.CustomerId == CustomerId).Select(x => x.EventId).ToList(); eventids = eventids.Concat(eventusereventids).ToList(); List <SelectListItem> eventlist = (from p in entities.EventMasters.AsEnumerable().Where(a => eventids.Contains(a.EventId)).GroupBy(a => a.EventName) select new SelectListItem { Text = p.Select(a => a.EventName).FirstOrDefault(), Value = p.Select(a => a.EventId).FirstOrDefault().ToString() }).ToList(); foreach (var item in eventlist) { if (item.Value == eventid) { item.Selected = true; } } eventlist.Insert(0, new SelectListItem { Text = "--Select Event--", Value = "0" }); return(eventlist); }
public ActionResult Editprofile(int CustomerId = 0) { EventRegistrationEntities entities = new EventRegistrationEntities(); Customer customer = CustomerService.GetCustomerById(Convert.ToInt32(Session["CustomerId"])); if (customer == null) { return(HttpNotFound()); } CustomerModel model = new CustomerModel(); model.CustomerId = customer.CustomerId; model.FirstName = customer.FirstName; model.LastName = customer.LastName; model.Email = customer.Email; model.Contactno = customer.Contactno; model.Username = customer.Username; model.CompanyName = customer.CompanyName; model.Date_of_Registration = customer.Date_of_Registration; model.address1 = customer.Address1; model.address2 = customer.Address2; model.City = customer.City; model.Pincode = Convert.ToInt32(customer.Pincode); model.State = customer.State; List <SelectListItem> countrylist = getcountry(); model.countrylist = countrylist; model.Country = customer.Country; return(View(model)); }
public override string GetUserNameByEmail(string email) { using (EventRegistrationEntities dbContext = new EventRegistrationEntities()) { string username = (from u in dbContext.Customers where string.Compare(email, u.Email) == 0 select u.Username).FirstOrDefault(); return(!string.IsNullOrEmpty(username) ? username : string.Empty); } }
private static List <SelectListItem> getevent(int CustomerId) { EventRegistrationEntities entities = new EventRegistrationEntities(); List <SelectListItem> eventlist = (from p in entities.EventMasters.AsEnumerable().Where(a => a.CustomerId == CustomerId).GroupBy(a => a.EventName) select new SelectListItem { Text = p.Select(a => a.EventName).FirstOrDefault(), Value = p.Select(a => a.EventId).FirstOrDefault().ToString() }).ToList(); eventlist.Insert(0, new SelectListItem { Text = "--Select Event--", Value = "0" }); return(eventlist); }
private static List <SelectListItem> getcountry() { EventRegistrationEntities entities = new EventRegistrationEntities(); List <SelectListItem> countrylist = (from p in entities.countries.AsEnumerable() select new SelectListItem { Text = p.CountryName, Value = p.CountryName.ToString() }).ToList(); countrylist.Insert(0, new SelectListItem { Text = "--Select Country--", Value = "" }); return(countrylist); }
private static List <SelectListItem> getevent() { EventRegistrationEntities entities = new EventRegistrationEntities(); List <SelectListItem> eventlist = (from p in entities.EventMasters.AsEnumerable() select new SelectListItem { Text = p.EventName, Value = p.EventId.ToString() }).ToList(); eventlist.Insert(0, new SelectListItem { Text = "--Select Event--", Value = "0" }); return(eventlist); }
private static List <SelectListItem> getdomain() { EventRegistrationEntities entities = new EventRegistrationEntities(); List <SelectListItem> domainlist = (from p in entities.EventMasters.AsEnumerable() select new SelectListItem { Text = p.DomainName, Value = p.DomainName.ToString() }).ToList(); domainlist.Insert(0, new SelectListItem { Text = "--Select Domain--", Value = "" }); return(domainlist); }
public static bool IsEmailVerified(string username) { if (string.IsNullOrEmpty(username)) { return(false); } using (EventRegistrationEntities dbContext = new EventRegistrationEntities()) { var user = (from us in dbContext.Customers where string.Compare(username, us.Email, StringComparison.OrdinalIgnoreCase) == 0 && us.IsActive == true select us).FirstOrDefault(); return((user != null) ? true : false); } }
/// <summary> /// /// </summary> /// <param name="username"></param> /// <param name="userIsOnline"></param> /// <returns></returns> public override MembershipUser GetUser(string username, bool userIsOnline) { using (EventRegistrationEntities dbContext = new EventRegistrationEntities()) { var customer = (from us in dbContext.Customers.Include("CustomerRoles") where string.Compare(username, us.Email, StringComparison.OrdinalIgnoreCase) == 0 select us).FirstOrDefault(); if (customer == null) { return(null); } var selectedUser = new CustomMembershipUser(customer); return(selectedUser); } }
/// <summary> /// /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// <returns></returns> public override bool ValidateUser(string username, string password) { if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(password)) { return(false); } using (EventRegistrationEntities dbContext = new EventRegistrationEntities()) { var user = (from us in dbContext.Customers where string.Compare(username, us.Email, StringComparison.OrdinalIgnoreCase) == 0 && string.Compare(password, us.Password, StringComparison.OrdinalIgnoreCase) == 0 select us).FirstOrDefault(); return((user != null) ? true : false); } }
private static List <SelectListItem> getTransactiontype() { EventRegistrationEntities entities = new EventRegistrationEntities(); var transtype = (from p in entities.Transactions.AsEnumerable() select p.TransactionType).Distinct().ToList(); List <SelectListItem> list = new List <SelectListItem>(); list.Insert(0, new SelectListItem { Text = "--Select TransactionType--", Value = "" }); foreach (var item in transtype) { SelectListItem selectitem = new SelectListItem(); selectitem.Text = item; selectitem.Value = item; list.Add(selectitem); } return(list); }
// Executes when the user navigates to this page. protected override void OnNavigatedTo(NavigationEventArgs e) { Uri serviceRoot = new Uri("EventRegistrationDataService.svc", UriKind.Relative); EventRegistrationEntities data = new EventRegistrationEntities(serviceRoot); var q = from ev in data.Events where ev.DateFrom >= DateTime.Today && ev.DateFrom <= DateTime.Today.AddMonths(2) select ev; DataServiceQuery <Event> query = (DataServiceQuery <Event>)q; query.BeginExecute(ar => { var query1 = ar.AsyncState as DataServiceQuery <Event>; var events = query1.EndExecute(ar); foreach (var ev in events) { EventList.Add(ev); } }, query); //var client = new RegistrationServiceClient(); //client.GetEventsCompleted += (sender, e1) => // { // if (e1.Error != null) // { // } // else // { // foreach (var ev in e1.Result) // { // eventList.Add(ev); // } // } // }; //client.GetEventsAsync(DateTime.Today, DateTime.Today.AddMonths(2)); }
/// <summary> /// /// </summary> /// <param name="username"></param> /// <returns></returns> public override string[] GetRolesForUser(string username) { if (!HttpContext.Current.User.Identity.IsAuthenticated) { return(null); } var userRoles = new string[] { }; using (EventRegistrationEntities dbContext = new EventRegistrationEntities()) { var selectedUser = (from us in dbContext.Customers.Include("Customerroles") where string.Compare(us.Username, username, StringComparison.OrdinalIgnoreCase) == 0 select us).FirstOrDefault(); if (selectedUser != null) { userRoles = new[] { selectedUser.CustomerRoles.Select(r => r.Role.RoleName).ToString() }; } return(userRoles.ToArray()); } }