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