public IHttpActionResult Search(MemberSearchModel model)
{
string firstName = string.IsNullOrWhiteSpace(model.FirstName) ? null : model.FirstName.Trim();
string lastName = string.IsNullOrWhiteSpace(model.LastName) ? null : model.LastName.Trim();
int? categoryId = model.CategoryID.HasValue && model.CategoryID.Value > 0 ? model.CategoryID : null;
int? nukhId = model.NukhID.HasValue && model.NukhID.Value > 0 ? model.NukhID : null;
string city = string.IsNullOrWhiteSpace(model.City) ? null : model.City.Trim();
string district = string.IsNullOrWhiteSpace(model.District) ? null : model.District.Trim();
string state = string.IsNullOrWhiteSpace(model.State) ? null : model.State.Trim();
string emailAddress = string.IsNullOrWhiteSpace(model.Email) ? null : model.Email.Trim();
string phoneNumber = string.IsNullOrWhiteSpace(model.PhoneNumber) ? null : model.PhoneNumber.Trim();
string sortOrder = string.IsNullOrWhiteSpace(model.SortOrder) ? null : model.SortOrder.Trim();
int? currentPage = model.CurrentPage.HasValue && model.CurrentPage.Value > 0 ? model.CurrentPage : null;
int? pageSize = model.PageSize.HasValue && model.PageSize.Value > 0 ? model.PageSize : null;
int? memberId = model.MemberId > 0 ? model.MemberId : (int?)null;
bool includeOnlyHOF = model.IncludeOnlyHOF;
MemberSearchResultModel mvm = new MemberSearchResultModel();
using (bkContext context = new bkContext())
{
ObjectParameter oParameter = new ObjectParameter("TotalRecords", typeof(int));
List <bk_MemberSearch_Result> results = context.bk_MemberSearch(firstName, lastName, categoryId, nukhId, city, district, state, emailAddress, phoneNumber, pageSize, currentPage, includeOnlyHOF, sortOrder, memberId, null, oParameter).ToList();
mvm.TotalRecords = (int)oParameter.Value;
foreach (var result in results)
{
var item = new MemberSearchResultItemModel();
item.Name = $"{result.FirstName} {result.LastName}";
item.Address1 = $"{result.Address1}, {result.Address2}".TrimEnd(' ').TrimEnd(',').TrimStart(',');
item.Address2 = $"{result.City}, {result.District}, {result.State}, {result.Country}".TrimEnd(' ').TrimEnd(',').TrimStart(',').Replace(", , ", ", ");
item.MemberId = result.MemberID;
item.FamilyId = result.FamilyID;
item.Gender = result.Gender;
item.Alive = result.Alive;
item.DOB = result.DOB;
item.DOD = result.DOD;
item.PhotoUrl = MemberWrapper.ProfilePhoto(result.MemberID, result.Gender, result.ModifiedOn);
mvm.Results.Add(item);
}
}
return(Ok(mvm));
}
public IHttpActionResult ProfilePhoto()
{
string url = "";
DateTime?modifiedOn;
bool gender;
using (bkContext context = new bkContext())
{
Member member = context.Members.FirstOrDefault(x => x.MemberID == LoggedInMemberId);
if (member != null)
{
gender = member.Gender;
modifiedOn = member.ModifiedOn;
url = MemberWrapper.ProfilePhoto(LoggedInMemberId, gender, modifiedOn);
}
}
return(Ok(url));
}
public IHttpActionResult GetMatrimony(int memberId)
{
using (bkContext context = new bkContext())
{
Matrimonial mat = context.Matrimonials.FirstOrDefault(x => x.MemberID == memberId);
if (mat == null)
{
return(BadRequest("Matrimony profile cannot be loaded"));
}
Member member = context.Members.FirstOrDefault(x => x.MemberID == memberId);
if (member == null)
{
return(BadRequest("Matrimony profile cannot be loaded"));
}
MatrimonyViewOnlyModel model = new MatrimonyViewOnlyModel();
model.MatrimonyModel.Alcohol = mat.Alcohol;
model.MatrimonyModel.BirthTime = mat.BirthTime;
model.MatrimonyModel.BodyTypeId = mat.BodyTypeID;
model.MatrimonyModel.ComplexionTypeId = mat.ComplexionTypeID;
model.MatrimonyModel.Disability = mat.Disability;
model.MatrimonyModel.Height = mat.Height;
model.MatrimonyModel.Language = mat.Language;
model.MatrimonyModel.Mangal = mat.Mangal;
model.MatrimonyModel.MaritalStatusId = mat.MaritalStatusID;
model.MatrimonyModel.MaternalNukhId = mat.MaternalNukhID;
model.MatrimonyModel.MemberId = mat.MemberID;
model.MatrimonyModel.MonthlyIncome = mat.MonthlyIncome;
model.MatrimonyModel.OwnHome = mat.OwnHome;
model.MatrimonyModel.ProfileText = mat.ProfileText;
model.MatrimonyModel.Smoke = mat.Smoke;
model.MatrimonyModel.Tobacco = mat.Tobacco;
model.MatrimonyModel.Vegetarian = mat.Vegetarian;
model.MatrimonyModel.Weight = mat.Weight;
model.MatrimonyModel.Photo1Url = MemberWrapper.MatrimonyPhoto(mat.MemberID, mat.Member.Gender, 1, mat.ModifiedOn);
model.MatrimonyModel.Photo2Url = MemberWrapper.MatrimonyPhoto(mat.MemberID, mat.Member.Gender, 2, mat.ModifiedOn);
model.MatrimonyModel.Photo3Url = MemberWrapper.MatrimonyPhoto(mat.MemberID, mat.Member.Gender, 3, mat.ModifiedOn);
model.MemberModel.MemberID = member.MemberID;
model.MemberModel.FirstName = member.FirstName;
model.MemberModel.LastName = member.LastName;
model.MemberModel.NickName = member.NickName;
model.MemberModel.Email = member.EmailAddress;
model.MemberModel.PhoneNumber = member.Phone;
model.MemberModel.Gender = member.Gender;
model.MemberModel.DOB = member.DOB;
model.MemberModel.BirthPlace = member.BirthPlace;
model.MemberModel.Alive = member.Alive;
model.MemberModel.DOD = member.DOD;
model.MemberModel.DeathPlace = member.DeathPlace;
model.MemberModel.EducationLevel = member.EducationLevel;
model.MemberModel.EducationField = member.EducationField;
model.MemberModel.OccupationId = member.OccupationID;
model.MemberModel.CompanyName = member.CompanyName;
model.MemberModel.JobTitle = member.JobTitle;
model.MemberModel.InstagramHandle = member.InstagramHandle;
model.MemberModel.FacebookHandle = member.FacebookHandle;
model.MemberModel.TwitterHandle = member.TwitterHandle;
model.MemberModel.MaritalStatusId = member.MaritalStatusID;
model.MemberModel.PhotoUrl = MemberWrapper.ProfilePhoto(member.MemberID, member.Gender, member.ModifiedOn);
model.MemberModel.FamilyId = member.FamilyMemberAssociations.Where(x => x.DefaultFamily).Select(x => x.FamilyId).FirstOrDefault();
model.MemberModel.ModifiedOn = mat.ModifiedOn.HasValue ? mat.ModifiedOn : mat.CreatedOn;
if (member.ModifiedOn > model.MemberModel.ModifiedOn)
{
model.MemberModel.ModifiedOn = member.ModifiedOn;
}
GetMaternalFamily_Result mResult = context.GetMaternalFamily(member.MemberID).FirstOrDefault();
if (mResult != null)
{
model.MemberModel.MaternalFamilyId = mResult.MaternalFamilyID;
model.MemberModel.MaternalFamilyName = string.Format("{0}, {1}", mResult.MaternalFamilyName, mResult.MaternalFamilyAddress);
}
return(Ok(model));
}
}
public IHttpActionResult Search(MatrimonySearchModel model)
{
int? categoryId = model.CategoryID.HasValue && model.CategoryID.Value > 0 ? model.CategoryID : null;
int? nukhId = model.NukhID.HasValue && model.NukhID.Value > 0 ? model.NukhID : null;
string city = string.IsNullOrWhiteSpace(model.City) ? null : model.City.Trim();
string district = string.IsNullOrWhiteSpace(model.District) ? null : model.District.Trim();
string state = string.IsNullOrWhiteSpace(model.State) ? null : model.State.Trim();
string country = string.IsNullOrWhiteSpace(model.Country) ? null : model.Country.Trim();
bool? gender = model.Gender;
int? occupationId = model.OccupationId.HasValue && model.OccupationId.Value > 0 ? model.OccupationId : null;
int? maritalStatusId = model.MaritalStatusId.HasValue && model.MaritalStatusId.Value > 0 ? model.MaritalStatusId : null;
int? minAge = model.MinimumAge.HasValue && model.MinimumAge.Value > 0 ? model.MinimumAge : null;
int? maxAge = model.MaximumAge.HasValue && model.MaximumAge.Value > 0 ? model.MaximumAge : null;
int? currentPage = model.CurrentPage.HasValue && model.CurrentPage.Value > 0 ? model.CurrentPage : null;
int? pageSize = model.PageSize.HasValue && model.PageSize.Value > 0 ? model.PageSize : null;
string sortOrder = string.IsNullOrWhiteSpace(model.SortOrder) ? null : model.SortOrder.Trim();
DateTime?minDOB = null;
DateTime?maxDOB = null;
if (minAge.HasValue)
{
maxDOB = DateTime.Today.AddYears(minAge.Value * -1);
}
if (maxAge.HasValue)
{
minDOB = DateTime.Today.AddYears(maxAge.Value * -1);
}
MemberSearchResultModel mvm = new MemberSearchResultModel();
using (bkContext context = new bkContext())
{
ObjectParameter oParameter = new ObjectParameter("TotalRecords", typeof(int));
List <bk_MatrimonySearch_Result> results = context.bk_MatrimonySearch(categoryId, nukhId, city, district, state, country, gender, occupationId, maritalStatusId, minDOB, maxDOB, pageSize, currentPage, sortOrder, oParameter).ToList();
mvm.TotalRecords = (int)oParameter.Value;
foreach (var result in results)
{
var item = new MemberSearchResultItemModel();
item.Name = $"{result.FirstName} {result.LastName}";
item.Address1 = $"{result.Address1}, {result.Address2}".TrimEnd(' ').TrimEnd(',').TrimStart(',');
item.Address2 = $"{result.City}, {result.District}, {result.State}, {result.Country}".TrimEnd(' ').TrimEnd(',').TrimStart(',').Replace(", , ", ", ");
item.MemberId = result.MemberID;
item.FamilyId = result.FamilyID;
item.Gender = result.Gender;
item.DOB = result.DOB;
item.OccupationId = result.OccupationID > 0 ? result.OccupationID : (int?)null;
item.MonthlyIncome = result.MonthlyIncome > 0 ? result.MonthlyIncome : (int?)null;
if (!string.IsNullOrWhiteSpace(result.EducationField) && !string.IsNullOrWhiteSpace(result.EducationLevel))
{
item.Education = $"{result.EducationLevel} - {result.EducationField}";
}
else if (!string.IsNullOrWhiteSpace(result.EducationLevel))
{
item.Education = $"{result.EducationLevel}";
}
else if (!string.IsNullOrWhiteSpace(result.EducationField))
{
item.Education = $"{result.EducationField}";
}
item.PhotoUrl = MemberWrapper.ProfilePhoto(result.MemberID, result.Gender, result.ModifiedOn);
item.Photo1Url = MemberWrapper.MatrimonyPhoto(result.MemberID, result.Gender, 1, result.ModifiedOn);
item.Photo2Url = MemberWrapper.MatrimonyPhoto(result.MemberID, result.Gender, 2, result.ModifiedOn);
item.Photo3Url = MemberWrapper.MatrimonyPhoto(result.MemberID, result.Gender, 3, result.ModifiedOn);
mvm.Results.Add(item);
}
}
return(Ok(mvm));
}
public IHttpActionResult Get(int memberId, int familyId)
{
using (bkContext context = new bkContext())
{
Member member = context.Members.Where(x => x.MemberID == memberId).FirstOrDefault();
if (member == null)
{
return(BadRequest("Your record cannot be loaded. Please try again or contact Administrator for help"));
}
List <FamilyMemberAssociation> fmAssociation = context.FamilyMemberAssociations.Where(x => x.FamilyId == familyId).ToList();
MemberViewModel vm = new MemberViewModel();
vm.MemberID = member.MemberID;
vm.FirstName = member.FirstName;
vm.LastName = member.LastName;
vm.NickName = member.NickName;
vm.Email = member.EmailAddress;
vm.PhoneNumber = member.Phone;
vm.Gender = member.Gender;
vm.DOB = member.DOB;
vm.BirthPlace = member.BirthPlace;
vm.Alive = member.Alive;
vm.DOD = member.DOD;
vm.DeathPlace = member.DeathPlace;
vm.EducationLevel = member.EducationLevel;
vm.EducationField = member.EducationField;
vm.OccupationId = member.OccupationID;
vm.CompanyName = member.CompanyName;
vm.JobTitle = member.JobTitle;
vm.InstagramHandle = member.InstagramHandle;
vm.FacebookHandle = member.FacebookHandle;
vm.TwitterHandle = member.TwitterHandle;
vm.MaritalStatusId = member.MaritalStatusID;
vm.Anniversary = member.Anniversary;
vm.PhotoUrl = MemberWrapper.ProfilePhoto(member.MemberID, member.Gender, member.ModifiedOn);
vm.ModifiedOn = member.ModifiedOn.HasValue ? member.ModifiedOn : member.CreatedOn;
vm.ProfileText = member.ProfileText;
GetMaternalFamily_Result mResult = context.GetMaternalFamily(member.MemberID).FirstOrDefault();
if (mResult != null)
{
vm.MaternalFamilyId = mResult.MaternalFamilyID;
vm.MaternalFamilyName = string.Format("{0}, {1}", mResult.MaternalFamilyName, mResult.MaternalFamilyAddress);
}
GetPaternalFamily_Result pResult = context.GetPaternalFamily(member.MemberID, member.Gender, member.MaritalStatusID).FirstOrDefault();
if (pResult != null)
{
vm.PaternalFamilyId = pResult.PaternalFamilyID;
vm.PaternalFamilyName = string.Format("{0}, {1}", pResult.PaternalFamilyName, pResult.PaternalFamilyAddress);
}
FamilyMemberAssociation fma = fmAssociation.FirstOrDefault(x => x.MemberId == memberId);
if (fma != null)
{
vm.RelatedMemberId = fma.RelatedId;
vm.RelationTypeId = fma.RelationTypeId;
vm.DefaultFamily = fma.DefaultFamily;
}
vm.canEdit = CanEditMember(fmAssociation, memberId);
return(Ok(vm));
}
}