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));
}
