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