public ActionResult Members(string sort = "memberid", string order = "desc", string message = null)
{
//var verb = Request.HttpMethod;
ViewBag.Crumbs = new List <BreadCrumb>();
ViewBag.Crumbs.Add(new BreadCrumb {
Title = "home", Url = "/"
});
ViewBag.Crumbs.Add(new BreadCrumb {
Title = "administration", Url = "/administration"
});
ViewBag.Crumbs.Add(new BreadCrumb {
Title = "members"
});
ViewBag.Menu = "members";
var model = new MembersModel {
Message = message
};
var members = service.GetMembers(sort + " " + order);
var memberModels = Mapper.Map <List <Member>, List <MemberModel> >(members);
model.Members = new SortedList <MemberModel>(memberModels, sort, order);
return(View(model));
}
public AddPaymentWindow(OrderWindow ow, MembersModel mm, OrderHistoryModel ohm)
{
orderWin = ow;
membersModel = mm;
orderHistory = ohm;
InitializeComponent();
}
public MembersModel Load(int id)
{
var model = new MembersModel();
string queryString = "SELECT Id,FirstName,LastName FROM dbo.Members Where id = @Id;";
try
{
using (var connection = new SqlConnection(connectionString))
using (var cmd = new SqlCommand(queryString, connection))
{
cmd.Parameters.AddWithValue("@Id", id);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
model.Id = (int)reader[0];
model.FirstName = (string)reader[1];
model.LastName = (string)reader[2];
}
}
}
catch (Exception ex)
{
}
return(model);
}
public void Delete(MembersModel membersModel)
{
if (membersModel != null)
{
MemberMemoryDB.Delete(membersModel.Id);
}
}
public IActionResult MembersZhuChe(string ff = "")
{
MembersModel model = JsonConvert.DeserializeObject <MembersModel>(ff);
int i = _ibll.MembersZhuChe(model);
return(Ok(i));
}
private List <MembersModel> loadClientEmployees()
{
conDB = new ConnectionDB();
MembersModel empStockist = new MembersModel();
List <MembersModel> lstEmpStockist = new List <MembersModel>();
queryString = "SELECT ID, firstname, lastname, phonenumber, address, clienttype FROM dbpackage.tblclients where " +
"isDeleted = 0 AND clienttype = 5 ORDER BY lastname asc";
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
while (reader.Read())
{
empStockist.ID = reader["ID"].ToString();
empStockist.FirstName = reader["firstname"].ToString();
empStockist.LastName = reader["lastname"].ToString();
empStockist.ContactNo = reader["phonenumber"].ToString();
empStockist.Address = reader["address"].ToString();
empStockist.Fullname = empStockist.LastName + ", " + empStockist.FirstName;
lstEmpStockist.Add(empStockist);
empStockist = new MembersModel();
}
conDB.closeConnection();
return(lstEmpStockist);
}
public void MemberPostMemoryDeleteTest()
{
var member1 = new MembersModel()
{
FirstName = "Bob", LastName = "Jones"
};
var member2 = new MembersModel()
{
FirstName = "Sue", LastName = "Johnson"
};
var member3 = new MembersModel()
{
FirstName = "Bob", LastName = "Jones"
};
var members = new List <MembersModel>()
{
member1, member2, member3
};
var memberDao = new MembersMemoryDao();
memberDao.Save(members);
memberDao.Delete(member1);
var membersGetList = memberDao.Load();
Assert.AreEqual(2, membersGetList.Count);
Assert.AreEqual(2, membersGetList[0].Id);
Assert.AreEqual("Sue", membersGetList[0].FirstName);
Assert.AreEqual("Johnson", membersGetList[0].LastName);
}
public decimal?Insert(MembersModel model)
{
try
{
if (string.IsNullOrEmpty(model.Name))
{
throw new ApplicationException("Member name cannot be an empty string.");
}
if (model.Occupation == null || model.Occupation.Id <= 0)
{
throw new ApplicationException("Invalid occupation selected.");
}
return(_MembersRepository.Insert(model));
}
catch (Exception ex)
{
while (ex.Message.IndexOf("See the inner exception for details.") > 0)
{
ex = ex.InnerException;
}
_logger.LogError(ex.Message);
throw ex;
}
}
public ActionResult Edit(MembersModel model)
{
model.Status = DataDictionaryHelper.GetId("用户状态>启用");
if (ModelState.IsValid)
{
var info = service.GetById(model.Id);
if (info != null)
{
info.UserName = model.UserName;
info.UserRealName = model.UserRealName;
info.UserType = model.UserType;
info.ImageUrl = model.ImageUrl;
info.Tel = model.Tel;
info.Email = model.Email;
service.Update(info);
}
return(Json(new AjaxResult()
{
Result = Result.Success
}));
}
return(View(PluginHelper.GetViewPath(this.GetType(), "Edit"), model));
}
public void CalculatePremiumNullOccupationRatingTest()
{
var response1 = _controller.GetById((int)_primaryKeyPool[4]);
Assert.IsNotNull(response1);
Assert.IsInstanceOfType(response1, typeof(OkNegotiatedContentResult <MembersModel>));
OkNegotiatedContentResult <MembersModel> result1 = (OkNegotiatedContentResult <MembersModel>)response1;
Assert.IsNotNull(result1.Content);
Assert.IsInstanceOfType(result1.Content, typeof(MembersModel));
MembersModel content1 = (MembersModel)result1.Content;
Assert.AreEqual(content1.Id, _primaryKeyPool[4]);
content1.Occupation.OccupationRating = null;
var response2 = _controller.CalculatePremium(content1);
Assert.IsNotNull(response2);
Assert.IsInstanceOfType(response2, typeof(OkNegotiatedContentResult <decimal?>));
OkNegotiatedContentResult <decimal?> result2 = (OkNegotiatedContentResult <decimal?>)response2;
Assert.IsNotNull(result2.Content);
Assert.IsInstanceOfType(result2.Content, typeof(decimal?));
decimal?content = (decimal?)result2.Content;
Assert.AreEqual(0.00M, content);
}
public ActionResult Create()
{
MembersModel model = new MembersModel();
return(View(PluginHelper.GetViewPath(this.GetType(), "Create"), model));
}
public ActionResult Create(MembersModel model)
{
if (ModelState.IsValid)
{
if (model.Password != model.Password2)
{
ModelState.AddModelError("Password", "两次输入的密码不一致！");
return(View(PluginHelper.GetViewPath(this.GetType(), "Create"), model));
}
var info = new Members();
info = Mapper.Map <MembersModel, Members>(model);
if (info != null)
{
service.Add(info);
return(Json(new AjaxResult()
{
Result = Result.Success
}));
}
}
return(View(PluginHelper.GetViewPath(this.GetType(), "Create"), model));
}
public ActionResult MembersPage(ContentModel content)
{
var umbUsers = new List <MembersModel>();
var allUsers = Services.MemberService.GetAllMembers();
var persons = new MembersPageModel(content.Content);
foreach (var item in allUsers)
{
var NameandSurname = item.GetValue <string>("nameAndSurname");
var avatarId = item.GetValue <int>("avatar");
var avatar = UmbracoContext.MediaCache.GetById(avatarId);
var umbUser = new MembersModel();
umbUser.NameandSurname = NameandSurname;
if (item.GetValue("avatar") != null)
{
umbUser.Avatar = avatar;
umbUser.ImagemUrl = avatar.Url;
}
umbUsers.Add(umbUser);
}
persons.UmbUsers = umbUsers;
return(CurrentTemplate(persons));
}
public ActionResult PasswordEdit(MembersModel model)
{
if (ModelState.IsValid)
{
if (model.Password != model.Password2)
{
ModelState.AddModelError("Password", "两次输入的密码不一致！");
return(View(PluginHelper.GetViewPath(this.GetType(), "Create"), model));
}
var info = service.GetById(model.Id);
if (info != null)
{
info.Password = model.Password;
service.Update(info);
}
return(Json(new AjaxResult()
{
Result = Result.Success
}));
}
return(View(PluginHelper.GetViewPath(this.GetType(), "Edit"), model));
}
public async Task <HttpResponseMessage> Create(MembersModel model, int projectId)
{
if (!ModelState.IsValid)
{
return(this.InvalidModelState(ModelState));
}
var members = model.Members;
var newMembers = new List <ProjectAccess>();
using (var context = DB)
{
using (var dbTrans = context.Database.BeginTransaction())
{
try
{
var projectData = context.Projects.Where(a => a.Id == projectId).FirstOrDefault();
if (projectData == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Can't find project"));
}
var oldSetOfMembers = context.ProjectAccesses.Where(a => a.ProjectId == projectId && a.UserId != projectData.CreatedBy).ToList();
context.ProjectAccesses.RemoveRange(oldSetOfMembers);
await context.SaveChangesAsync();
for (var i = 0; i < members.Count; i++)
{
var member = members[i];
if (member.UserId == projectData.CreatedBy)
{
continue;
}
newMembers.Add(new ProjectAccess()
{
UserId = member.UserId,
ProjectId = projectId,
AccessTypeId = 1
});
}
context.ProjectAccesses.AddRange(newMembers);
await DB.SaveChangesAsync();
dbTrans.Commit();
}
catch (DbEntityValidationException ex)
{
dbTrans.Rollback();
throw new Exception("Error while creating entry", ex);
}
}
}
return(this.StatusOk());
}
private List <MembersModel> searchStockist()
{
conDB = new ConnectionDB();
MembersModel depotStockist = new MembersModel();
List <MembersModel> lstDepotStockist = new List <MembersModel>();
queryString = "SELECT ID, firstname, lastname, phonenumber, address, clienttype FROM dbpackage.tblclients where " +
"(isDeleted = 0) AND (clienttype = 5)";
queryString += " AND (dbpackage.tblclients.lastname like '%" + searchName.Text + "%' OR dbpackage.tblclients.firstname " +
"like '%" + searchName.Text + "%')";
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
while (reader.Read())
{
depotStockist.ID = reader["ID"].ToString();
depotStockist.FirstName = reader["firstname"].ToString();
depotStockist.LastName = reader["lastname"].ToString();
depotStockist.ContactNo = reader["phonenumber"].ToString();
depotStockist.Address = reader["address"].ToString();
depotStockist.Fullname = depotStockist.LastName + ", " + depotStockist.FirstName;
lstDepotStockist.Add(depotStockist);
depotStockist = new MembersModel();
}
conDB.closeConnection();
return(lstDepotStockist);
}
public void UpdateById(MembersModel model)
{
try
{
if (string.IsNullOrEmpty(model.Name))
{
throw new ApplicationException($"Member name cannot be an empty string. Member Id was {model.Id}.");
}
if (model.Occupation == null || model.Occupation.Id <= 0)
{
throw new ApplicationException($"Invalid occupation selected. Member Id was {model.Id}.");
}
_MembersRepository.UpdateById(model);
}
catch (Exception ex)
{
while (ex.Message.IndexOf("See the inner exception for details.") > 0)
{
ex = ex.InnerException;
}
_logger.LogError(ex.Message);
throw ex;
}
}
public void InsertTest()
{
OkNegotiatedContentResult <decimal?> pk4 = (OkNegotiatedContentResult <decimal?>)_controller.Insert(new MembersModel()
{
Name = "Mr Ray Price [TEST]",
DOB = new DateTime(1955, 9, 11),
SumInsured = 333000M,
Occupation = new OccupationsModel
{
Id = 5 // Mechanic
},
});
_primaryKeyPool.Add(pk4.Content);
var response = _controller.GetById((int)_primaryKeyPool[4]);
Assert.IsNotNull(response);
Assert.IsInstanceOfType(response, typeof(OkNegotiatedContentResult <MembersModel>));
OkNegotiatedContentResult <MembersModel> result = (OkNegotiatedContentResult <MembersModel>)response;
Assert.IsNotNull(result.Content);
Assert.IsInstanceOfType(result.Content, typeof(MembersModel));
MembersModel content = (MembersModel)result.Content;
Assert.AreEqual(content.Id, _primaryKeyPool[4]);
}
public decimal?CalculatePremium(MembersModel model)
{
try
{
if (model.DOB == null || model.Occupation == null || model.Occupation.OccupationRating == null)
{
return(0.00M);
}
int ageInYears = (int)Math.Round(Math.Abs(model.DOB.Subtract(DateTime.Now).TotalDays / 365.25));
decimal premium = (model.SumInsured * model.Occupation.OccupationRating.Factor * ageInYears) / 1000 * 12;
return(premium);
}
catch (Exception ex)
{
while (ex.Message.IndexOf("See the inner exception for details.") > 0)
{
ex = ex.InnerException;
}
_logger.LogError(ex.Message);
throw ex;
}
}
public IActionResult GetAllMembers()
{
var members = _membersService.GetAllMembers();
var model = new MembersModel(members);
return(View("AllMembers", model));
}
public List <MembersModel> Load()
{
// String commandText = "Select Count([CourseID]) FROM [MySchool].[dbo].[Course] Where Year=@Year";
var memberList = new List <MembersModel>();
string queryString = "SELECT Id,FirstName,LastName FROM dbo.Members;";
try
{
using (var connection = new SqlConnection(connectionString))
using (var cmd = new SqlCommand(queryString, connection))
{
connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var model = new MembersModel();
model.Id = (int)reader[0];
model.FirstName = (string)reader[1];
model.LastName = (string)reader[2];
memberList.Add(model);
}
connection.Close();
}
}
catch (Exception ex)
{
}
return(memberList);
}
public void Save(MembersModel membersModel)
{
using (var connection = new SqlConnection(connectionString))
using (var transaction = connection.BeginTransaction())
{
transaction.Commit();
}
}
//会员信息管理 Members
#region
//添加客户
public int MembersAdd(MembersModel model)
{
string sql = $"insert into Members values('{model.MembersAccount}','{model.MembersWeChat}','{model.MembersNumber}','{model.MembersPassword}','{model.MembersAddressID}','{model.MembersSite}','{model.MembersMoney}')";
using (SqlConnection connection = new SqlConnection(conStr))
{
return(connection.Execute(sql));
}
}
public static ApplicationResultModel SetMemberData(MembersModel membersModel)
{
var result = MemberData.SetMemberData(membersModel);
return(new ApplicationResultModel()
{
Success = true, Result = result.Result
});
}
public ActionResult Details(Guid id)
{
MembersModel model = new MembersModel();
var info = service.GetById(id);
model = Mapper.Map <Members, MembersModel>(info);
return(View(PluginHelper.GetViewPath(this.GetType(), "Details"), model));
}
//修改客户
public int MembersUpdate(MembersModel model)
{
string sql = $"update Members set ='{model.MembersNumber}', ='{model.MembersPassword}', ='{model.MembersSite}'";
using (SqlConnection connection = new SqlConnection(conStr))
{
return(connection.Execute(sql));
}
}
private void btnEditClient_Click(object sender, RoutedEventArgs e)
{
MembersModel depotStck = dgvMembers.SelectedItem as MembersModel;
if (depotStck != null)
{
AddClientWindow acw = new AddClientWindow(this, depotStck);
acw.ShowDialog();
}
}
public IHttpActionResult Insert([FromBody] MembersModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var result = _membersService.Insert(model);
return(Ok(result));
}
public IHttpActionResult UpdateById(MembersModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_membersService.UpdateById(model);
return(Ok(true));
}
public JsonResult GetPersons(int groupId)
{
List <Person> persons = _personService.Get(UserId, groupId); // here is order by order no
List <PersonModel> members = _autoMapperService.MapPersonEntities(persons);
var model = new MembersModel {
UniqueId = groupId, Members = members
};
string view = this.RenderPartialView("_PersonsList", model);
return(Json(new { View = view, Members = members }, JsonRequestBehavior.AllowGet));
}
