/// <summary>
/// Creates the member.
/// </summary>
/// <param name="member">The member.</param>
/// <param name="userName">Name of the user.</param>
/// <returns></returns>
public PublicMethodResult CreateMember(MemberDetailViewModel member, string CreateUser)
{
try
{
Member PartStaticHtml = ReturnMappingMember(member);
//SETP 1.確認是否有同樣資料，Email、手機號碼皆不可相同
var memberInfo = _MemberRep.GetSingle(s => s.Email == PartStaticHtml.Email || s.PhoneNumber == PartStaticHtml.PhoneNumber);
if (memberInfo == null)
{
_MemberRep.MemberInsertInto(PartStaticHtml, CreateUser);
ReturnModel.ResultBool = true;
ReturnModel.ActionResult = DataAction.CreateScuess;
ReturnModel.Result = EnumHelper.GetEnumDescription(DataAction.CreateScuess);
}
else
{
ReturnModel.ResultBool = false;
ReturnModel.ActionResult = DataAction.CreateFailReapet;
ReturnModel.Result = EnumHelper.GetEnumDescription(DataAction.CreateFailReapet);
}
}
catch (Exception e)
{
ReturnModel.ResultBool = false;
ReturnModel.ActionResult = DataAction.CreateFail;
ReturnModel.Result = EnumHelper.GetEnumDescription(DataAction.CreateFail);
}
return(ReturnModel);
}
public MembershipDetail()
{
var vm = new MemberDetailViewModel();
BindingContext = vm;
InitializeComponent();
}
public ActionResult UpdataAction(MemberDetailViewModel instance)
{
var Detail = MemberWorkflow.GetMemberDetail(instance.Id);
MemberViewModel data = new MemberViewModel();
data.Id = Detail.Id;
data.CompanyId = instance.CompanyId;
data.WorkId = Detail.WorkId;
data.Password = (instance.Password != null && instance.Password != Detail.Password) ? instance.Password : Detail.Password;
if ((bool)instance.Member)
{
data.RoleName = "Member";
}
else if ((bool)instance.Admin)
{
data.RoleName = "Administrator";
}
else if ((bool)instance.Lock)
{
data.RoleName = "Lock";
}
data.Email = instance.Email;
data.Age = instance.Age;
data.Name = instance.Name;
data.CreateDateTime = (DateTime)Detail.CreateDateTime;
data.CreateUserId = Detail.CreateUserId;
data.Remark = Detail.Remark;
var result = MemberWorkflow.Update(data, "Clarke");
return(RedirectToAction("Index"));
}
public MemberDetailViewModel GetMemberDetail(Guid?MemberId)
{
MemberDetailViewModel result = null;
result = this.MemberRepository.GetMemberDetail(MemberId);
return(result);
}
public MemberDetailView(List <MemberItem> items, MemberItem selectedItem)
{
InitializeComponent();
var viewModel = new MemberDetailViewModel(items, selectedItem);
viewModel.OnRequestClose += (s, e) => Close();
DataContext = viewModel;
}
public ActionResult MemberList()
{
MemberDetailViewModel memberDetailViewModel = new MemberDetailViewModel();
memberDetailViewModel.MemberList = (from a in db.Member join b in db.MemberRole on a.MemberRoleId equals b.MemberRoleId select new MemberDetail {
Email = a.Email, IsActive = b.IsActive, MemberId = a.MemberId, MemberRoleDesc = b.MemberRoleDesc, MemberRoleId = a.MemberRoleId, Password = a.Password
}).ToList();
return(View("MemberList", memberDetailViewModel));
}
public ActionResult ShowUpdate(int id)
{
MemberDetailViewModel memberDetailViewModel = new MemberDetailViewModel();
memberDetailViewModel.UpdatedMember = (from a in db.Member join b in db.MemberRole on a.MemberRoleId equals b.MemberRoleId where a.MemberId == id select new MemberDetail {
Email = a.Email, IsActive = b.IsActive, MemberId = a.MemberId, MemberRoleDesc = b.MemberRoleDesc, MemberRoleId = a.MemberRoleId, Password = a.Password
}).First();
memberDetailViewModel.Roles = db.MemberRole.Where(s => s.IsActive != 0).ToList();
return(PartialView(memberDetailViewModel));
}
public IActionResult MemberDetail(int Id)
{
TblMembers _TblMembers =
UnitOfWork.Repository <DevelopersHub.Models.TblMembers>().Get(x => x.Id == Id);
MemberDetailViewModel _MemberDetailViewModel = new MemberDetailViewModel();
_MemberDetailViewModel.Member = _TblMembers;
return(View(_MemberDetailViewModel));
}
public MemberDetailViewModel UpdateMemberDetail(MemberDetailViewModel memberDetail)
{
return(_connection.DbPath.ExecStoredProcedure <MemberDetailViewModel>("UpdateMemberDetail",
new
{
memberDetail.MemberId,
memberDetail.PasswordHash,
memberDetail.PasswordSalt,
memberDetail.NickName
}).FirstOrDefault());
}
public PartialViewResult _MemberDetail()
{
var uye = _uyeService.Get_WIncById(_sessionService.GetUyeSession().Id);
var model = new MemberDetailViewModel
{
Uye = uye,
Ulkeler = _ulkeService.GetList(),
Sehirler = _sehirService.GetListByUlkeId(uye.Sehir.UlkeId)
};
return PartialView(model);
}
public ActionResult MemberDetail(string username)
{
var customer = _customerRepository.GetCustomerByUsername(username);
var viewModel = new MemberDetailViewModel()
{
Customer = customer,
Vouchers = _gameRepository.GetAllVouchersFromCustomer(customer)
};
return(View(viewModel));
}
/// <summary>
/// ViewModel To DBModel
/// </summary>
/// <param name="viewModel"></param>
/// <returns></returns>
private Member ReturnMappingMember(MemberDetailViewModel viewModel)
{
Member dbViewModel = new Member();
var mapper = AutoMapperConfig.InitializeAutoMapper().CreateMapper();
dbViewModel = mapper.Map <Member>(viewModel);
// 手動綁訂, ChoosePostalCode 從 View 回來直接綁中文字，而非原來的 PostalCode
int choosePostalCode = Convert.ToInt16(viewModel.ChoosePostalCode);
ZipCode zipcode = _ZipCodeRep.GetSingle(s => s.PostalCode == choosePostalCode);
dbViewModel.ZipCodeID = zipcode == null ? 0 : zipcode.ID;
return(dbViewModel);
}
public ActionResult MemberProfile(MemberDetailViewModel memberDetailViewModel)
{
memberDetailViewModel.MemberId = GetSessionUser.Id;
var result = _memberBusiness.UpdateMemberDetail(memberDetailViewModel);
if (!result.Success)
{
ModelState.AddModelError("errorMemberProfile", result.Message);
memberDetailViewModel.Error = Errors(GetModelErrors());
}
return(Json(memberDetailViewModel));
}
/// <summary>
/// Returns the member detail.
/// </summary>
/// <param name="ActionType">Type of the action.</param>
/// <param name="guid">The unique identifier.</param>
/// <returns></returns>
public MemberDetailViewModel ReturnMemberDetail(DataAction ActionType, string guid)
{
MemberDetailViewModel DetailViewModel = new MemberDetailViewModel();
Member MemberViewModel = GetMemberById(guid);
var mapper = AutoMapperConfig.InitializeAutoMapper().CreateMapper();
DetailViewModel = mapper.Map <MemberDetailViewModel>(MemberViewModel);
ZipCode zipcode = _ZipCodeRep.GetSingle(s => s.ID == MemberViewModel.ZipCodeID);
//手動綁入
DetailViewModel.ActionType = ActionType;
DetailViewModel.ChooseCity = zipcode == null ? "" : zipcode.City;
DetailViewModel.ChoosePostalCode = zipcode == null ? "" : zipcode.PostalCode.ToString();
return(DetailViewModel);
}
public MemberDetailViewModel GetMemberDetail(Guid?MemberId)
{
MemberDetailViewModel results = null;
using (var dbcontext = MemberDbContext.CreateContext())
{
var queryable = this.ApplyJoinDetail(dbcontext.Member, dbcontext.Identity, dbcontext.Role,
dbcontext.CompanyConfing, dbcontext.MemberActivity);
queryable = queryable.Where(x => x.Id == MemberId);
results = queryable.First();
}
return(results);
}
public ActionResult Update(MemberDetailViewModel memberDetail)
{
if (!ModelState.IsValid)
{
return(RedirectToAction("MemberList"));
}
else
{
var updatedUser = db.Member.SingleOrDefault(x => x.MemberId == memberDetail.UpdatedMember.MemberId);
updatedUser.Email = memberDetail.UpdatedMember.Email;
updatedUser.IsActive = memberDetail.UpdatedMember.IsActive;
updatedUser.MemberId = memberDetail.UpdatedMember.MemberId;
updatedUser.MemberRoleId = memberDetail.UpdatedMember.MemberRoleId;
updatedUser.Password = memberDetail.UpdatedMember.Password;
db.Entry(updatedUser).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("MemberList"));
}
}
/// <summary>
/// Update StaticHtml
/// </summary>
/// <param name="statichtml"></param>
/// <returns></returns>
public PublicMethodResult UpdateMember(MemberDetailViewModel member, string UpdateUser)
{
try
{
Member PartMember = ReturnMappingMember(member);
_MemberRep.MemberUpdate(PartMember, UpdateUser);
ReturnModel.ResultBool = true;
ReturnModel.ActionResult = DataAction.UpdateScuess;
ReturnModel.Result = EnumHelper.GetEnumDescription(DataAction.UpdateScuess);
}
catch (Exception e)
{
ReturnModel.ResultBool = false;
ReturnModel.ActionResult = DataAction.UpdateFail;
ReturnModel.Result = EnumHelper.GetEnumDescription(DataAction.UpdateFail);
}
return(ReturnModel);
}
public ActionResult MemberMain(DataAction ActionType,
string guid,
string selectName,
string selectContractCheck,
string selectPhoneNumber,
string selectCity,
string selectCountry,
int pages = 1)
{
TempData["Actions"] = ActionType;
MemberDetailViewModel data = new MemberDetailViewModel();
if (ActionType == DataAction.Update)
{
data = _MemberService.ReturnMemberDetail(ActionType, guid);
}
data.Sex = false;
#region KeepSelectBlock
pages = pages == 0 ? 1 : pages;
TempData["MemeberSelect"] = new MemberViewModel()
{
Header = new MemberListHeaderViewModel()
{
Name = selectName,
ContractCheck = selectContractCheck,
PhoneNumber = selectPhoneNumber == "" ? 0 : Convert.ToInt16(selectPhoneNumber),
CityDDL = selectCity,
CountyDDL = selectCountry
},
page = pages
};
MemberGetViewBag(selectContractCheck);
#endregion KeepSelectBlock
return(View(data));
}
public ActionResult MemberMain(DataAction actions, MemberDetailViewModel memberViewModel)
{
MemberViewModel searchBlock = (MemberViewModel)TempData["MemeberSelect"];
// KeepSelectBlock
MemberKeepSelectBlock(searchBlock, actions);
PublicMethodResult ResultViewModel = new PublicMethodResult();
if (ModelState.IsValid)
{
if (actions == DataAction.Create) //建立資料
{
memberViewModel.MemberID = Guid.NewGuid(); // 日後可統一 Guid 或是 String 型態
ResultViewModel = _MemberService.CreateMember(memberViewModel, SignInManagerId);
}
else //更新資料
{
ResultViewModel = _MemberService.UpdateMember(memberViewModel, SignInManagerId);
}
_MemberService.Save();
}
TempData["message"] = ResultViewModel.Result;
if (ResultViewModel.ResultBool) // 取決於導向頁面, True = 返回SystemRoles, False = 停在本頁
{
return(RedirectToAction("Member", new
{
ViewModel = searchBlock,
pages = searchBlock.page
}));
}
// 顯示資料
//memberViewModel = _MemberService.ReturnMemberDetail(actions, memberViewModel.MemberID.ToString().ToUpper());
return(View(memberViewModel));
}
public ResultSet <MemberDetailViewModel> UpdateMemberDetail(MemberDetailViewModel memberDetail)
{
var result = new ResultSet <MemberDetailViewModel>();
result.Object = memberDetail;
var member = GetMemberByMemberId(memberDetail.MemberId);
if (member.Success)
{
DateTime dateTime;
#region Basic Fields Validations
if (string.IsNullOrEmpty(memberDetail.NickName) || !ValidationUtils.UserNameIsValid(memberDetail.NickName))
{
result.Message = "Invalid nickname";
return(result);
}
else if ((!string.IsNullOrEmpty(memberDetail.CurrentPassword) && memberDetail.CurrentPassword.Length > 16))
{
result.Message = "Invalid password(maximum current password length can be 16 character)";
return(result);
}
else if ((!string.IsNullOrEmpty(memberDetail.NewPassword) && memberDetail.NewPassword.Length > 16))
{
result.Message = "Invalid password(maximum new password length can be 16 character)";
return(result);
}
else if ((!string.IsNullOrEmpty(memberDetail.NewPasswordMatch) && memberDetail.NewPasswordMatch.Length > 16))
{
result.Message = "Invalid password(maximum password repeat length can be 16 character)";
}
#endregion
#region This fields are exists?
/*************This nickname is exists***************************************/
var _existMember = _memberRepository.GetMemberByNickname(memberDetail.NickName);
if (_existMember != null && _existMember.Id != member.Object.Id)
{
result.Message = "This nick name is in use";
return(result);
}
#endregion
#region Password Operations
else if (!string.IsNullOrEmpty(memberDetail.NewPassword) && string.IsNullOrEmpty(memberDetail.NewPasswordMatch))
{
result.Message = "New password and repeat did not match";
return(result);
}
else if ((!string.IsNullOrEmpty(memberDetail.NewPassword) || !string.IsNullOrEmpty(memberDetail.NewPasswordMatch)) && (!string.IsNullOrEmpty(member.Object.PasswordHash)) &&
string.IsNullOrEmpty(memberDetail.CurrentPassword))
{
result.Message = "Please enter current password";
return(result);
}
else if (!string.IsNullOrEmpty(memberDetail.NewPassword) && !string.IsNullOrEmpty(memberDetail.NewPasswordMatch))
{
if (memberDetail.NewPassword != memberDetail.NewPasswordMatch)
{
result.Message = "New password and repeat did not match";
return(result);
}
string _hash = string.Empty, _salt = string.Empty;
if (!string.IsNullOrEmpty(member.Object.PasswordHash))
{
if (!_hashProvider.VerifyHashString(memberDetail.CurrentPassword, member.Object.PasswordHash, member.Object.PasswordSalt))
{
result.Message = "Current password is wrong";
return(result);
}
}
_hashProvider.GetHashAndSaltString(memberDetail.NewPassword, out _hash, out _salt);
memberDetail.PasswordHash = _hash;
memberDetail.PasswordSalt = _salt;
}
#endregion
var tempMemberDetail = _memberRepository.UpdateMemberDetail(memberDetail);
if (tempMemberDetail != null)
{
result.Success = true;
result.Object = tempMemberDetail;
result.Message = "Your informations are updated";
}
}
return(result);
}
public ActionResult MemberDetail(int memberId, string SortOrder, int MemDetail_page = 1)
{
MemberDetailViewModel Member = new MemberDetailViewModel();
Member.member = db.Users.Where(x => x.ID == memberId && x.IsActive == true && x.RoleID == 2 && x.IsEmailVerified == true).FirstOrDefault();
Member.memberProfile = db.UserProfile.Where(x => x.UserID == memberId && x.IsActive == true).FirstOrDefault();
//sortorder
ViewBag.TitleSortParm = SortOrder == "Title" ? "title_desc" : "Title";
ViewBag.CategorySortParm = SortOrder == "Category" ? "category_desc" : "Category";
ViewBag.StatusSortParm = SortOrder == "Status" ? "Status_desc" : "Status";
ViewBag.TotalDownloadSortParm = SortOrder == "Downloaded" ? "Downloaded_desc" : "Downloaded";
ViewBag.TotalEarningSortParm = SortOrder == "Earning" ? "Earning_desc" : "Earning";
ViewBag.DateAddSortParm = SortOrder == "DateAdd" ? "DateAdd_desc" : "DateAdd";
ViewBag.DatePubSortParm = SortOrder == "DatePub" ? "DatePub_desc" : "DatePub";
var notes = db.SellerNotes.Where(x => x.SellerID == memberId && x.Status != 6);
//sorting
switch (SortOrder)
{
case "title_desc":
notes = notes.OrderByDescending(s => s.Title);
break;
case "Title":
notes = notes.OrderBy(s => s.Title);
break;
case "category_desc":
notes = notes.OrderByDescending(s => s.NoteCategories.Name);
break;
case "Category":
notes = notes.OrderBy(s => s.NoteCategories.Name);
break;
case "Status_desc":
notes = notes.OrderByDescending(s => s.ReferenceData.Value);
break;
case "Status":
notes = notes.OrderBy(s => s.ReferenceData.Value);
break;
case "DateAdd_desc":
notes = notes.OrderByDescending(s => s.CreatedDate);
break;
case "DateAdd":
notes = notes.OrderBy(s => s.CreatedDate);
break;
case "DatePub_desc":
notes = notes.OrderByDescending(s => s.PublishedDate);
break;
case "DatePub":
notes = notes.OrderBy(s => s.PublishedDate);
break;
default:
notes = notes.OrderByDescending(s => s.PublishedDate);
break;
}
List <detailmodel> dmodel = new List <detailmodel>();
//calculating totaldownload and money
foreach (var total in notes)
{
int totalDownloaded;
decimal?totalMoney;
if (total.Status == 9 || total.Status == 11)
{
totalDownloaded = db.Downloads.Where(x => x.NoteID == total.ID && x.IsSellerHasAllowedDownload == true).Count();
var records = db.Downloads.Where(x => x.NoteID == total.ID && x.IsSellerHasAllowedDownload == true);
totalMoney = records.Sum(x => x.PurchasedPrice);
if (records.Count() == 0)
{
totalMoney = 0;
}
}
else
{
totalDownloaded = 0;
totalMoney = 0;
}
//add data to modal
detailmodel detailModel = new detailmodel()
{
sellnote = total,
totalDownload = totalDownloaded,
totalEarning = totalMoney
};
dmodel.Add(detailModel);
}
//sorting for two column
if (SortOrder == "Downloaded_desc")
{
dmodel = dmodel.OrderByDescending(x => x.totalDownload).ToList();
}
if (SortOrder == "Downloaded")
{
dmodel = dmodel.OrderBy(x => x.totalDownload).ToList();
}
if (SortOrder == "Earning_desc")
{
dmodel = dmodel.OrderByDescending(x => x.totalEarning).ToList();
}
if (SortOrder == "Earning")
{
dmodel = dmodel.OrderBy(x => x.totalEarning).ToList();
}
Member.memDetails = dmodel;
//pagination
var pager = new Pager(notes.Count(), MemDetail_page, 10);
ViewBag.currentPage = pager.CurrentPage;
ViewBag.endPage = pager.EndPage;
ViewBag.startpage = pager.StartPage;
ViewBag.totalPage = notes.Count();
Member.memDetails = dmodel.Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize);
return(View(Member));
}
public ActionResult MemberDetail(int member, string sort, int page = 1)
{
// viewbag for searching, sorting and pagination
ViewBag.Sort = sort;
ViewBag.PageNumber = page;
ViewBag.Member = member;
// get id of note status draft
var draftid = context.ReferenceData.Where(x => x.Value.ToLower() == "draft").Select(x => x.ID).FirstOrDefault();
// get member
Users users = context.Users.Where(x => x.ID == member).FirstOrDefault();
// get member's profile
UserProfile userprofiles = context.UserProfile.Where(x => x.UserID == users.ID).FirstOrDefault();
// get member's notes excluding note status draft
var notes = context.SellerNotes.Where(x => x.SellerID == users.ID && x.Status != draftid).ToList();
// create list of MemberDetailViewModel.MembersNote
var notelist = new List <MemberDetailViewModel.MembersNote>();
foreach (var note in notes)
{
// get data of downloaded notes for count how many people downloaded notes and get total earning
var downloadednoteslist = context.Downloads.Where(x => x.NoteID == note.ID && x.IsSellerHasAllowedDownload == true && x.AttachmentPath != null);
// create membernote object of MemberDetailViewModel.MembersNote
var membernote = new MemberDetailViewModel.MembersNote();
membernote.ID = note.ID;
membernote.Title = note.Title;
membernote.Category = note.NoteCategories.Name;
membernote.Status = note.ReferenceData.Value;
membernote.DownloadedNotes = downloadednoteslist.Count();
membernote.TotalEarning = downloadednoteslist.Select(x => x.PurchasedPrice).Sum();
membernote.DateAdded = note.CreatedDate;
membernote.PublishedDate = note.PublishedDate;
// add membernote object to notelist
notelist.Add(membernote);
}
// create object of MemberDetailViewModel
MemberDetailViewModel members = new MemberDetailViewModel();
members.FirstName = users.FirstName;
members.LastName = users.LastName;
members.Email = users.EmailID;
if (userprofiles != null)
{
members.DOB = userprofiles.DOB;
members.PhoneNumberCountryCode = userprofiles.PhoneNumberCountryCode;
members.PhoneNumber = userprofiles.PhoneNumber;
members.College = userprofiles.University;
members.Address1 = userprofiles.AddressLine1;
members.Address2 = userprofiles.AddressLine2;
members.City = userprofiles.City;
members.State = userprofiles.State;
members.ZipCode = userprofiles.ZipCode;
members.Country = userprofiles.Country;
members.ProfilePicture = userprofiles.ProfilePicture;
}
members.Notes = notelist.AsEnumerable();
// sorting member notes result
members.Notes = SortTableMemberNotes(sort, members.Notes);
// count total pages
ViewBag.TotalPages = Math.Ceiling(members.Notes.Count() / 5.0);
// show result according to pagination
members.Notes = members.Notes.Skip((page - 1) * 5).Take(5);
return(View(members));
}
