public IHttpActionResult Get(int memberId) { using (bkContext context = new bkContext()) { Matrimonial mat = context.Matrimonials.FirstOrDefault(x => x.MemberID == memberId); Member member = context.Members.FirstOrDefault(x => x.MemberID == memberId); if (mat == null) { return(BadRequest("Matrimony profile cannot be loaded")); } MatrimonyViewModel model = new MatrimonyViewModel(); model.Alcohol = mat.Alcohol; model.BirthTime = mat.BirthTime; model.BodyTypeId = mat.BodyTypeID; model.ComplexionTypeId = mat.ComplexionTypeID; model.Disability = mat.Disability; model.Height = mat.Height; model.Language = mat.Language; model.Mangal = mat.Mangal; model.MaritalStatusId = mat.MaritalStatusID; model.MaternalNukhId = mat.MaternalNukhID; model.MemberId = mat.MemberID; model.MonthlyIncome = mat.MonthlyIncome; model.OwnHome = mat.OwnHome; model.ProfileText = mat.ProfileText; model.Smoke = mat.Smoke; model.Tobacco = mat.Tobacco; model.Vegetarian = mat.Vegetarian; model.Weight = mat.Weight; model.Photo1Url = MemberWrapper.MatrimonyPhoto(mat.MemberID, mat.Member.Gender, 1, mat.ModifiedOn); model.Photo2Url = MemberWrapper.MatrimonyPhoto(mat.MemberID, mat.Member.Gender, 2, mat.ModifiedOn); model.Photo3Url = MemberWrapper.MatrimonyPhoto(mat.MemberID, mat.Member.Gender, 3, mat.ModifiedOn); return(Ok(model)); } }
public IHttpActionResult DeletePhoto(int photoNumber, int memberId) { if (!CanEditMember(memberId)) { return(BadRequest("You do not have permission to edit this member")); } if (photoNumber < 1 || photoNumber > 3) { return(BadRequest("Invalid photo number")); } string filePath = System.Web.Hosting.HostingEnvironment.MapPath(string.Format(@"~/Images/Matrimonials/{0}_{1}.jpg", memberId, photoNumber)); if (File.Exists(filePath)) { File.Delete(filePath); } string response = string.Empty; using (bkContext context = new bkContext()) { Matrimonial mat = context.Matrimonials.FirstOrDefault(x => x.MemberID == memberId); if (mat != null) { mat.ModifiedBy = LoggedInMemberId; mat.ModifiedOn = DateTime.Now; context.SaveChanges(); } response = MemberWrapper.MatrimonyPhoto(memberId, mat.Member.Gender, photoNumber, mat.ModifiedOn); } return(Ok(response)); }
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)); }