private void bindCombo() { assett.ItemsSource = CE.AdminAssets.ToList(); List <Account> t1 = CE.Accounts.Where(s => s.memId == memid).ToList <Account>(); var t = from tt in t1 join acde in CE.AccountDetails on tt.id equals acde.accountId join ass in CE.AdminAssets on acde.assetId equals ass.id select new { ass.id, ass.name, }; var t2 = t.Distinct(); //var ast2= CE.AdminAssets.SqlQuery("select * from AdminAssets" + // " where id= any (select assetId from model1.dbo.AccountDetails t1 " + // "inner join model1.dbo.account t2 on t1.accNum = t2.accNum " + // "where t2.memId = " + memid + " )").ToList<AdminAsset>(); asset2.ItemsSource = t2; var memlist = CE.AdminMembers.ToList(); var rem = memlist.Find(x => x.id == memid); memlist.Remove(rem); AdminMember allItem = new AdminMember() { code = "Бүгд", id = 0 }; memlist.Add(allItem); membee.ItemsSource = memlist; membee.SelectedIndex = memlist.Count() - 1; }
public Барьцаа() { InitializeComponent(); bindCombo(); AdminMember memb = CE.AdminMembers.Where(r => r.id == memId).FirstOrDefault <AdminMember>(); if (memb == null) { MessageBox.Show("There is no member has id : " + memId); return; } short type = Convert.ToInt16(memb.type); List <Adminmtype> list = new List <Adminmtype>() { new Adminmtype() { id = 0, minValue = 50 }, new Adminmtype() { id = 1, minValue = 100 }, new Adminmtype() { id = 3, minValue = 150 }, }; Adminmtype mty = list.Where(r => r.id == type).FirstOrDefault <Adminmtype>(); minval = Convert.ToInt32(mty.minValue); }
private void bindCombo() { var acclist = CE.AdminAccounts.Where(s => s.memberid == memId && s.accountType == 3).ToList(); linkAc.ItemsSource = acclist; linkAc_Copy.ItemsSource = acclist; var memlist = CE.AdminMembers.ToList(); members = memlist; var rem = memlist.Find(x => x.id == memId); members.Remove(rem); AdminMember allItem = new AdminMember() { code = "Бүгд", id = 0 }; members.Add(allItem); membee.ItemsSource = members; int indexx = members.Count(); membee.SelectedIndex = indexx - 1; }
public HttpResponseMessage DeleteAdministratorMember(AdminMember adminMember) { var modelValidation = adminMember.Validate(this.AccountSession, ValidationMode.Delete); if (modelValidation.IsValid) { try { // delete the administrator member account this.AuthenticationSecurity.DeleteMember(adminMember); // request successful return(CreateSuccessResponse(new { success = true }, HttpStatusCode.OK)); } catch (Exception ex) { Logger.Error(string.Format("Exception detected attempting to delete administration member {0} via user Id {1}", adminMember.Id, this.AccountSession.MemberId), ex); return(CreateErrorResponse(ex)); } } // invalid parameters, generate response return(CreateInvalidResponse(modelValidation)); }
public void DeleteMember(AdminMember member) { var userName = member.Email; if (this.IsMongoMembershipEnabled) { //try //{ // var status = MembershipCreateStatus.UserRejected; // var membershipUser = this.MembershipProvider.CreateUser(userName, password, userName, "", "", true, null, out status); // if (status == MembershipCreateStatus.Success) // { // // create a user account // model = this.Uow.Administrators.CreateMember(form, membershipUser.ProviderUserKey.ToString()); // if (model == null) // { // throw new Exception("failed to create administrator account"); // } // } // else // { // Logger.Warn(string.Format("Failed to create administrator: {0}. Reason: {1}", userName, status)); // } //} //catch (Exception e) //{ // Logger.Error(string.Format("Error creating administrator: {0}", userName), e); // throw e; //} } else { // delete the member account this.Uow.Administrators.DeleteMember(member); } try { if (Roles.GetRolesForUser(userName).Count() > 0) { Roles.RemoveUserFromRoles(userName, Roles.GetRolesForUser(userName)); } ((SimpleMembershipProvider)System.Web.Security.Membership.Provider).DeleteAccount(userName); // deletes record from webpages_Membership table ((SimpleMembershipProvider)System.Web.Security.Membership.Provider).DeleteUser(userName, true); // deletes the record in the Membership table } catch (Exception e) { Logger.Error(string.Format("Error deleting WebSecurity administrator: {0}", member.Email), e); throw e; } }
public AdminMember UpdateMember(AdminMember member) { var userName = member.Email; if (this.IsMongoMembershipEnabled) { //try //{ // var status = MembershipCreateStatus.UserRejected; // var membershipUser = this.MembershipProvider.CreateUser(userName, password, userName, "", "", true, null, out status); // if (status == MembershipCreateStatus.Success) // { // // create a user account // model = this.Uow.Administrators.CreateMember(form, membershipUser.ProviderUserKey.ToString()); // if (model == null) // { // throw new Exception("failed to create administrator account"); // } // } // else // { // Logger.Warn(string.Format("Failed to create administrator: {0}. Reason: {1}", userName, status)); // } //} //catch (Exception e) //{ // Logger.Error(string.Format("Error creating administrator: {0}", userName), e); // throw e; //} } else { // update the member account this.Uow.Administrators.UpdateMember(member); } try { // update the SQL user email var wasUpdated = DatabaseHelper.UpdateMemberEmail(userName, member.Id); } catch (Exception e) { Logger.Error(string.Format("Error deleting WebSecurity administrator: {0}", member.Email), e); throw e; } // return a fresh copy return(this.Uow.Administrators.FindById(member.Id)); }