/// <summary>
/// deletes Event
/// </summary>
/// <param name="id"> user id </param>
/// returns string
public string DeleteEvent(string id)
{
using (var _ctx = new ChinmayaEntities())
{
var msg = "";
var rgstrusr = _ctx.EventRegistrations.Where(r => r.EventId == id).FirstOrDefault();
if (rgstrusr == null)
{
var evnt = _ctx.Events.Where(r => r.Id == id).FirstOrDefault();
_ctx.Events.Remove(evnt);
msg = "Event Deleted Successfully";
}
else
{
msg = "Users already registered for the Event";
}
try
{
_ctx.SaveChanges();
}
catch
{
throw;
}
return(msg);
}
}
/// <summary>
/// updates shared user data
/// </summary>
/// <param name="sam"> SharedAccount Model </param>
public SharedAccount UpdateSharedAccount(SharedAccountModel sam)
{
try
{
SharedAccount sharedAccount = null;
if (sam != null)
{
using (var _ctx = new ChinmayaEntities())
{
sharedAccount = _ctx.SharedAccounts.Where(x => x.From_UserId == sam.From_UserId).FirstOrDefault();
if (sharedAccount != null)
{
sharedAccount.IsApproved = sam.IsApproved;
sharedAccount.IsDeclined = sam.IsDeclined;
sharedAccount.UpdatedDate = DateTime.Now;
_ctx.Entry(sharedAccount).State = EntityState.Modified;
_ctx.SaveChanges();
}
}
}
return(sharedAccount);
}
catch
{
throw;
}
}
/// <summary>
/// gets all events data by user age
/// </summary>
/// <param name="age"> user age </param>
/// <returns> list of current event model </returns>
public List <CurrentEventModel> GetEventsData(int age)
{
using (var _ctx = new ChinmayaEntities())
{
var events = (from e in _ctx.Events
where e.AgeFrom <= age && age <= e.AgeTo
select new CurrentEventModel
{
Id = e.Id,
Name = e.Name,
Description = e.Description,
Weekday = _ctx.Weekdays.Where(i => i.Id == e.WeekdayId).Select(i => i.Name).FirstOrDefault(),
Frequency = _ctx.Frequencies.Where(i => i.Id == e.FrequencyId).Select(i => i.Name).FirstOrDefault(),
//StartTime = _ctx.EventSessions.Where(i => i.EventId == e.Id).Select(i => i.StartTime).FirstOrDefault(),
//EndTime = _ctx.EventSessions.Where(i => i.EventId == e.Id).Select(i => i.EndTime).FirstOrDefault(),
multimings = _ctx.EventTimings.Where(i => i.EventId == e.Id).Select(x => new multipleClassTimings
{
StartTime = x.StartTime,
EndTime = x.EndTime
}).ToList(),
teacherFname = _ctx.Users.Where(i => i.Id == (_ctx.TeacherClasses.Where(n => n.ClassId == e.Id).Select(n => n.Id).FirstOrDefault())).Select(i => i.FirstName).FirstOrDefault(),
teacherLname = _ctx.Users.Where(i => i.Id == (_ctx.TeacherClasses.Where(n => n.ClassId == e.Id).Select(n => n.Id).FirstOrDefault())).Select(i => i.LastName).FirstOrDefault(),
teacherdetails = _ctx.TeacherInfoes.Where(i => i.Id == (_ctx.TeacherClasses.Where(n => n.ClassId == e.Id).Select(n => n.Id).FirstOrDefault())).Select(i => i.Teacherdetails).FirstOrDefault(),
AgeFrom = e.AgeFrom,
AgeTo = e.AgeTo,
Amount = e.Amount
}).ToList();
return(events);
}
}
/// <summary>
/// adds shared user data
/// </summary>
/// <param name="sam"> SharedAccount Model </param>
public void PostSharedAccount(SharedAccountModel sam)
{
using (var _ctx = new ChinmayaEntities())
{
try
{
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <SharedAccountModel, SharedAccount>();
});
IMapper mapper = config.CreateMapper();
SharedAccount sa = new SharedAccount();
mapper.Map(sam, sa);
_ctx.SharedAccounts.Add(sa);
_ctx.SaveChanges();
}
catch
{
throw;
}
}
}
/// <summary>
/// gets user data
/// </summary>
/// <param name="Id"> user id </param>
/// <returns>User Family Member model </returns>
public UserFamilyMember GetUserData(string Id)
{
using (var _ctx = new ChinmayaEntities())
{
var userData = (from e in _ctx.Users
where e.Id == Id
select new UserFamilyMember
{
Id = e.Id,
FirstName = e.FirstName,
LastName = e.LastName,
}).FirstOrDefault();
if (userData == null)
{
userData = (from e in _ctx.FamilyMembers
where e.Id == Id
select new UserFamilyMember
{
Id = e.Id,
FirstName = e.FirstName,
LastName = e.LastName,
}).FirstOrDefault();
}
return(userData);
}
}
/// <summary>
/// get event details
/// </summary>
/// <param name="Id"> event id </param>
/// <returns> event model </returns>
public EventsModel GetEventDetails(string Id)
{
using (var _ctx = new ChinmayaEntities())
{
EventsModel emm = new EventsModel();
Event emData = _ctx.Events.Where(e => e.Id == Id).FirstOrDefault();
if (emData != null)
{
emm.Id = emData.Id;
emm.Name = emData.Name;
emm.Description = emData.Description;
emm.WeekdayId = emData.WeekdayId;
emm.FrequencyId = emData.FrequencyId;
emm.AgeFrom = emData.AgeFrom;
emm.AgeTo = emData.AgeTo;
emm.Amount = emData.Amount;
EventSession esessionData = _ctx.EventSessions.Where(es => es.EventId == emData.Id).FirstOrDefault();
emm.SessionId = esessionData.SessionId;
emm.StartDate = Convert.ToDateTime(esessionData.StartDate);
emm.EndDate = Convert.ToDateTime(esessionData.EndDate);
emm.StartTime = esessionData.StartTime;
emm.EndTime = esessionData.EndTime;
emm.Location = esessionData.Location;
emm.Instructor = esessionData.Instructor;
emm.Contact = esessionData.Contact;
emm.Other = esessionData.Other;
EventHoliday eHolidayData = _ctx.EventHolidays.Where(eh => eh.EventId == emData.Id).FirstOrDefault();
emm.HolidayDate = eHolidayData.HolidayDate;
}
return(emm);
}
}
/// <summary>
/// Get family primary account email id
/// </summary>
/// <param name="email"> user email </param>
/// <returns> primary account email id </returns>
public string GetFamilyPrimaryAccountEmail(string email)
{
string result = string.Empty;
using (var _ctx = new ChinmayaEntities())
{
var objFamilyMembers = _ctx.FamilyMembers.FirstOrDefault(x => x.Email == email);
if (objFamilyMembers != null)
{
var objUser = _ctx.Users.FirstOrDefault(x => x.Id == objFamilyMembers.UpdatedBy);
if (objUser != null)
{
return(objUser.Email);
}
}
else
{
if (IsEmailExists(email))
{
return(email);
}
}
}
return(result);
}
/// <summary>
/// updates email address
/// </summary>
/// <param name="el"> update email model </param>
/// <returns> true or false </returns>
public bool UpdateEmailAddress(UpdateEmail el)
{
using (var _ctx = new ChinmayaEntities())
{
var user = _ctx.Users.Where(r => r.Id == el.userId).FirstOrDefault();
if (user != null)
{
user.Email = el.email;
}
try
{
_ctx.Entry(user).State = EntityState.Modified;
_ctx.SaveChanges();
return(true);
}
catch (DbEntityValidationException e)
{
foreach (var even in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
even.Entry.Entity.GetType().Name, even.Entry.State);
foreach (var ve in even.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
return(false);
}
}
}
/// <summary>
/// gets all users details
/// </summary>
/// <returns> list of users object </returns>
public object GetAllUsers()
{
using (var _ctx = new ChinmayaEntities())
{
var users = (from u in _ctx.Users
where !_ctx.FamilyMembers.Any(f => f.Email == u.Email)
select new
{
Id = u.Id,
FullName = u.FirstName + " " + u.LastName,
AccountType = (u.IsIndividual) ? "Individual Account" : "Family Account",
DOB = u.DOB,
HomePhone = u.HomePhone,
CellPhone = u.CellPhone
}).ToList().Select(x => new
{
x.Id,
x.FullName,
x.AccountType,
DOB = string.Format("{0:MM/dd/yyyy}", x.DOB),
x.HomePhone,
x.CellPhone
});
return(users);
}
}
/// <summary>
/// gets user full name by email
/// </summary>
/// <param name="email"> user email </param>
/// <returns> user full name </returns>
public string GetUserFullNameByEmail(string email)
{
string fullname = string.Empty;
if (!string.IsNullOrEmpty(email))
{
using (var _ctx = new ChinmayaEntities())
{
var objUser = _ctx.Users.FirstOrDefault(x => x.Email == email);
if (objUser != null)
{
fullname = objUser.FirstName + " " + objUser.LastName;
}
else
{
var objFamilyUser = _ctx.FamilyMembers.FirstOrDefault(x => x.Email == email);
if (objFamilyUser != null)
{
fullname = objFamilyUser.FirstName + " " + objFamilyUser.LastName;
}
}
}
}
return(fullname);
}
/// <summary>
/// gets user family members data by user id
/// </summary>
/// <param name="Id"> user id </param>
/// <returns> User Family member model </returns>
public List <GetFamilyMemberForUser_Result> GetUserFamilyMemberData(string Id)
{
using (var _ctx = new ChinmayaEntities())
{
return(_ctx.GetFamilyMemberForUser(Id).ToList());
}
}
/// <summary>
/// gets user role name
/// </summary>
/// <param name="id"> user id </param>
/// <returns> user role </returns>
public string GetRoleName(int id)
{
using (var _ctx = new ChinmayaEntities())
{
return(_ctx.Roles.Where(r => r.Id == id).Select(n => n.Name).FirstOrDefault());
}
}
/// <summary>
/// updates user address
/// </summary>
/// <param name="cd"> Contact Details model </param>
public void UpdateAddress(ContactDetails cd)
{
using (var _ctx = new ChinmayaEntities())
{
var user = _ctx.Users.Where(r => r.Email == cd.Email).FirstOrDefault();
if (user != null)
{
user.Address = cd.Address;
user.City = cd.City;
user.StateId = cd.State;
user.CountryId = cd.Country;
user.ZipCode = cd.ZipCode;
user.HomePhone = cd.HomePhone;
}
try
{
_ctx.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var even in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
even.Entry.Entity.GetType().Name, even.Entry.State);
foreach (var ve in even.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
}
}
}
/// <summary>
/// saves check payment details
/// </summary>
/// <param name="chkp"> Check Payment Model </param>
public void PostCheckPayment(CheckPaymentModel chkp)
{
using (var _ctx = new ChinmayaEntities())
{
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <CheckPaymentModel, CheckPayment>();
});
IMapper mapper = config.CreateMapper();
var chk = new CheckPayment
{
AccountHolderName = chkp.AccountHolderName,
AccountTypeId = chkp.AccountTypeId,
BankName = chkp.BankName,
AccountNumber = chkp.AccountNumber,
RoutingNumber = chkp.RoutingNumber,
Amount = chkp.Amount,
StatusId = 1,
CreatedBy = chkp.CreatedBy,
CreatedDate = DateTime.Now
};
_ctx.CheckPayments.Add(chk);
try
{
_ctx.SaveChanges();
}
catch
{
throw;
}
}
}
/// <summary>
/// gets country id
/// </summary>
/// <param name="name"> country name </param>
/// <returns> country id </returns>
public int GetCountryId(string name)
{
using (var _ctx = new ChinmayaEntities())
{
return(_ctx.Countries.Where(c => c.Name == name).FirstOrDefault().Id);
}
}
/// <summary>
/// updates password
/// </summary>
/// <param name="pwd"> Update Password Model </param>
/// <returns> true or false </returns>
public bool UpdatePassword(UpdatePasswordModel pwd)
{
using (var _ctx = new ChinmayaEntities())
{
var userEmail = _ctx.Users.Where(r => r.Email == pwd.Email && r.Password == pwd.OldPassword).FirstOrDefault();
if (userEmail == null)
{
return(false);
}
else if (userEmail != null)
{
userEmail.Password = pwd.NewPassword;
}
try
{
_ctx.Entry(userEmail).State = EntityState.Modified;
_ctx.SaveChanges();
return(true);
}
catch
{
throw;
}
}
}
/// <summary>
/// gets user account type
/// </summary>
/// <param name="Id"> user id </param>
/// <returns> true or false </returns>
public bool GetIsIndividual(string Id)
{
using (var _ctx = new ChinmayaEntities())
{
return(_ctx.Users.Where(r => r.Id == Id).Select(n => n.IsIndividual).FirstOrDefault());
}
}
/// <summary>
/// checks is user family member or not
/// </summary>
/// <param name="email"> user email </param>
/// <returns> true or false </returns>
public bool IsFamilyMember(string email)
{
using (var _ctx = new ChinmayaEntities())
{
return(_ctx.FamilyMembers.Any(u => u.Email == email));
}
}
/// <summary>
/// adds user to directory by using user id
/// </summary>
/// <param name="id"> user id </param>
public void AddtoDirectory(string id)
{
using (var _ctx = new ChinmayaEntities())
{
var user = _ctx.Directories.Where(r => r.UserId == id).Select(n => n.UserId).FirstOrDefault();
if (user == null)
{
var dir = new Directory
{
UserId = id
};
_ctx.Directories.Add(dir);
}
try
{
_ctx.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var even in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
even.Entry.Entity.GetType().Name, even.Entry.State);
foreach (var ve in even.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
}
}
}
/// <summary>
/// checks whether user is active or inactive user
/// </summary>
/// <param name="email"> user email </param>
/// <returns> true or false </returns>
public bool IsActiveUser(string email)
{
using (var _ctx = new ChinmayaEntities())
{
return(_ctx.Users.Any(u => u.Email == email && u.Status == true));
}
}
/// <summary>
/// Gets Email by Address
/// </summary>
/// <param name="cd"></param>
/// <returns></returns>
public string GetPrimaryAccountEmailByAddress(ContactDetails cd)
{
try
{
using (var _ctx = new ChinmayaEntities())
{
var email = "";
var objUserList = _ctx.Users.Where(u => u.Address == cd.Address && !u.IsIndividual).ToList();
foreach (User objUser in objUserList)
{
if (objUser.City.ToLower() == cd.City.ToLower())
{
if (objUser.StateId == cd.State)
{
email = objUser.Email;
return(email);
}
}
else
{
email = "";
}
}
return(email);
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// saves Event Registration details
/// </summary>
/// <param name="evntr"> Event Registration Model </param>
public void PostEventRegistration(EventRegistrationModel evntr)
{
using (var _ctx = new ChinmayaEntities())
{
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <EventRegistrationModel, EventRegistration>();
});
IMapper mapper = config.CreateMapper();
var eventRegistration = new EventRegistration();
eventRegistration.EventId = evntr.EventId;
eventRegistration.FamilyMemberId = evntr.FamilyMemberId;
eventRegistration.OwnerId = evntr.OwnerId;
eventRegistration.CheckPaymentId = _ctx.CheckPayments.Where(r => r.CreatedBy == evntr.OwnerId).Select(n => n.Id).FirstOrDefault();
eventRegistration.InvoiceId = _ctx.CreditCardPayments.Where(r => r.UserId == evntr.OwnerId).Select(n => n.InvoiceId).FirstOrDefault();
eventRegistration.IsRegister = true;
eventRegistration.IsConfirm = true;
eventRegistration.IsPaid = true;
eventRegistration.CreatedBy = evntr.OwnerId;
eventRegistration.CreatedDate = DateTime.Now;
_ctx.EventRegistrations.Add(eventRegistration);
try
{
_ctx.SaveChanges();
}
catch
{
throw;
}
}
}
/// <summary>
/// Check user email exists or not
/// </summary>
/// <param name="email"> user email </param>
/// <returns> true or false </returns>
public bool IsEmailExists(string email)
{
using (var _ctx = new ChinmayaEntities())
{
return(_ctx.Users.Any(u => u.Email == email));
}
}
/// <summary>
/// updates phone number
/// </summary>
/// <param name="phone"> phone number </param>
public void UpdatePhone(UpdatePhone phone)
{
using (var _ctx = new ChinmayaEntities())
{
var user = _ctx.Users.Where(r => r.Email == phone.Email).FirstOrDefault();
if (user != null)
{
user.CellPhone = phone.OldPhone;
}
try
{
_ctx.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var even in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
even.Entry.Entity.GetType().Name, even.Entry.State);
foreach (var ve in even.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
}
}
}
/// <summary>
/// add or update user data
/// </summary>
/// <param name="user"> User Model </param>
public void PostUser(UserModel user)
{
using (var _ctx = new ChinmayaEntities())
{
try
{
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <UserModel, User>();
});
IMapper mapper = config.CreateMapper();
User ur = new User();
mapper.Map(user, ur);
if (string.IsNullOrEmpty(user.Id))
{
ur.Id = Guid.NewGuid().ToString();
ur.CreatedDate = DateTime.Now;
ur.RoleId = 2;
Dictionary <int, string> SecurityQuestions = new Dictionary <int, string>();
SecurityQuestions = user.UserSecurityQuestions;
UserSecurityQuestion usq = new UserSecurityQuestion();
foreach (var item in SecurityQuestions)
{
var UserSQ = new UserSecurityQuestion();
UserSQ.UserId = ur.Id;
UserSQ.SecurityQuestionId = item.Key;
UserSQ.Answer = item.Value;
_ctx.UserSecurityQuestions.Add(UserSQ);
_ctx.Users.Add(ur);
}
_ctx.SaveChanges();
}
else
{
_ctx.Entry(ur).State = EntityState.Modified;
_ctx.SaveChanges();
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
}
}
}
public List <KeyGuidValueModel> GetCenterCity(Guid id)
{
using (var _ctx = new ChinmayaEntities())
{
return(_ctx.CM_Cities.Where(s => s.StateGUID == id).Select(x => new KeyGuidValueModel
{
Id = x.CityGUID,
Name = x.CityName
}).ToList());
}
}
/// <summary>
/// gets cities
/// </summary>
/// <param name="id"> state id </param>
/// <returns> list of cities </returns>
public List <KeyValueModel> GetCityName(int id)
{
using (var _ctx = new ChinmayaEntities())
{
return(_ctx.Cities.Where(s => s.StateID == id).Select(x => new KeyValueModel
{
Id = x.Id,
Name = x.Name
}).ToList());
}
}
/// <summary>
/// user account type will changed
/// </summary>
/// <param name="id"> user id </param>
public void ChangeAccountType(string id)
{
using (var _ctx = new ChinmayaEntities())
{
var user = _ctx.Users.Where(i => i.Id == id).FirstOrDefault();
if (user != null)
{
user.IsIndividual = false;
_ctx.SaveChanges();
}
}
}
public List <KeyGuidValueModel> GetCenterCountryData()
{
using (var _ctx = new ChinmayaEntities())
{
var CenterCountryData = (from c in _ctx.CM_Countries
select new KeyGuidValueModel
{
Id = c.CountryGUID,
Name = c.CountryName
}).ToList();
return(CenterCountryData);
}
}
/// <summary>
/// gets user email
/// </summary>
/// <param name="Email"> user email </param>
/// <returns> Update email model </returns>
public UpdateEmail getEmail(string Id)
{
using (var _ctx = new ChinmayaEntities())
{
UpdateEmail mail = new UpdateEmail();
var eData = _ctx.Users.Where(f => f.Email == Id).FirstOrDefault();
if (eData != null)
{
mail.Email = Id;
}
return(mail);
}
}
