public Results Create(RecordsModel model) { using (var connection = GetConnection()) { try { connection.Open(); var result = connection.Insert(new { Id = model.Id, TypeId = model.TypeId, Source = model.Source, Money = model.Money, Remark = model.Remark, CreateOn = model.CreateOn, CreateBy = model.CreateBy }, OPIM_Common.TableName.Records); return(new Results()); } catch (Exception ex) { return(new Results(ex.Message)); } } }
public Results Update(RecordsModel model) { using (var connection = GetConnection()) { try { connection.Open(); var result = connection.Update(new { //TypeId = model.TypeId, //Source = model.Source, Money = model.Money, Remark = model.Remark }, new { Id = model.Id }, OPIM_Common.TableName.Records); return(new Results()); } catch (Exception ex) { return(new Results(ex.Message)); } } }
public void ShouldGetCachedHeadToHeadRecord() { //given var resultsModel = new RecordsModel { PlayerOneWins = 1, Results = new List <ResultsModel> { new ResultsModel { AwayScore = 1 } } }; string headToHeadResultsKey = string.Format("{0}_{1}", 1, 2); _cache.Set(headToHeadResultsKey, resultsModel, _cacheItemPolicy); var repository = new ResultsCacheRepository(new CachingManager(_cache)); //when var resultsModels = repository.GetHeadToHeadRecord(1, 2); Assert.IsNotNull(resultsModels); Assert.That(resultsModels.PlayerOneWins, Is.EqualTo(resultsModel.PlayerOneWins)); Assert.That(resultsModels.Results.Count, Is.EqualTo(1)); Assert.That(resultsModels.Results.First().AwayScore, Is.EqualTo(1)); End(); }
// PUT: api/Records/5 public HttpResponseMessage Post([FromBody] RecordsModel recModel) { _service.UpdateUserRecord(recModel); var response = Request.CreateResponse(HttpStatusCode.Moved); response.Headers.Location = new Uri("http://localhost:54196/ApiHarness.html"); return(response); }
public ActionResult Add(RecordsModel model) { model.Id = Guid.NewGuid(); model.CreateOn = DateTime.Now.ToString("yyyy/MM/dd"); model.CreateBy = _authentication.MemberShipId; //获得当前登录账户Id model.Source = "网站"; var result = _recordRespository.CreateRecord(model); return(Json(result)); }
public Results CreateRecord(RecordsModel model) { if (model.TypeId == Guid.Empty || model.TypeId == null) { return(new Results("请选择类型")); } if (model.Source == null) { return(new Results("请选择记录来源")); } return(_recordDapper.Create(model)); }
public Results UpdateRecord(RecordsModel model) { if (model.Id == null || model.Id == Guid.Empty) { return(new Results("Id不能为空")); } if (model.Money < 0) { return(new Results("输入的金额不合法")); } return(_recordDapper.Update(model)); }
public void CreateNewCustomerRecord(ref string sMessage, ref RecordsModel recordsModel) { #region Local variables string sNombreSP, sResult = string.Empty; DbModel dbModel = new DbModel(); DbViewModel dbViewModel = new DbViewModel(); #endregion if (recordsModel.CustomerEmail is null || !IsCustomerEmailGood(recordsModel.CustomerEmail)) { sMessage = "Por favor verifique que el correo electrónico se haya ingresado en el formato correcto"; }
//получение всех обработанных заявок private void GetAllRecords() { records = RecordsController.GetAllRecords(); List <RecordsModel> recordsModels = new List <RecordsModel>(); foreach (var rcd in records) { RecordsModel recordModel = new RecordsModel() { RecordId = rcd.RecordId, DoctorName = rcd.User.FullName, Service = rcd.Service.Name, CardId = rcd.CardId, Date = rcd.Date.ToString().Substring(0, 10), Time = rcd.Time.Interval, }; recordsModels.Add(recordModel); } GridRecords = recordsModels; }
public RecordsModel GetHeadToHeadRecord(int playerOne, int playerTwo) { var parameters = new { UserOneId = playerOne, UserTwoId = playerTwo, }; var headToHeadRecordList = new RecordsModel { Results = new List <ResultsModel>() }; using (var reader = _helper.ExecuteReader("up_HeadToHeadRecord", parameters)) { while (reader.Read()) { headToHeadRecordList.TotalMatches = (int)reader["TotalMatches"]; headToHeadRecordList.TotalDraws = (int)reader["TotalDraws"]; headToHeadRecordList.PlayerOneWins = (int)reader["PlayerOneWins"]; headToHeadRecordList.PlayerTwoWins = (int)reader["PlayerTwoWins"]; } reader.NextResult(); while (reader.Read()) { headToHeadRecordList.Results.Add(new ResultsModel { HomeTeam = reader["HomeUser"].ToString(), AwayTeam = reader["AwayUser"].ToString(), HomeScore = (int)reader["HomeScore"], AwayScore = (int)reader["AwayScore"], ResultId = (Guid)reader["ResultId"] }); } } return(headToHeadRecordList); }
private static RecordsModel BuildRecordsModel(string title, List <RecordsTempData> tempData, int idSeason = -1) { var recordModel = new RecordsModel { Title = title, IdSeason = idSeason }; var topScorer = tempData.OrderByDescending(td => td.Goals).ThenBy(td => td.Penalties) .ThenByDescending(td => td.Assists).ThenBy(td => td.Player).FirstOrDefault(); if (topScorer != null) { recordModel.GoalRecord = new RecordsPlayer { ExtraStat = topScorer.Penalties, Player = topScorer.Player, Stat = topScorer.Goals } } ; var assistKing = tempData.OrderByDescending(td => td.Assists).ThenByDescending(td => td.Goals) .ThenBy(td => td.Penalties).ThenBy(td => td.Player).FirstOrDefault(); if (assistKing != null) { recordModel.AssistRecord = assistKing.Assists != 0 ? new RecordsPlayer { Stat = assistKing.Assists, Player = assistKing.Player } : new RecordsPlayer { Stat = 0, Player = "No Statistics" }; } return(recordModel); }
//fetching city details from database public List <RecordsModel> fetchCity() { List <RecordsModel> objCityList = new List <RecordsModel>(); try { conn = dbc.openConnection(); cmd = new MySqlCommand("sp_fetchCity", conn); cmd.CommandType = CommandType.StoredProcedure; MySqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { RecordsModel objCity = new RecordsModel(); objCity.id = sdr["id"].ToString(); objCity.city = sdr["city"].ToString(); objCityList.Add(objCity); } return(objCityList); } catch (Exception ex) { string message = ex.Message; } finally { dbc.closeConnection(); } return(objCityList); }
public RecordsControllerTests() { _mapper = new Mock <IMapper>(); _playerRepository = new Mock <IPlayerRepository>(); _resultRepository = new Mock <IResultRepository>(); var playerModels = new List <PlayerModel>() { new PlayerModel { PlayerName = "Hemang", PlayerId = 1 } }; var domainPlayerModels = new List <DataAccess.Models.PlayerModel>() { new DataAccess.Models.PlayerModel { PlayerName = "Hemang", PlayerId = 1 } }; _playerRepository.Setup(x => x.GetAllPlayers()).Returns(domainPlayerModels); _mapper.Setup(x => x.Map <List <PlayerModel> >(domainPlayerModels)).Returns(playerModels); var recordsModel = new RecordsModel { TotalMatches = 1, PlayerOneWins = 2, PlayerTwoWins = 3, TotalDraws = 4, Results = new List <ResultsModel> { new ResultsModel { AwayScore = 0, AwayTeam = "Villa", HomeScore = 3, HomeTeam = "Arsenal", ResultId = Guid.NewGuid() } } }; var domainRecordsModel = new DataAccess.Models.RecordsModel { TotalMatches = 1, PlayerOneWins = 2, PlayerTwoWins = 3, TotalDraws = 4, Results = new List <DataAccess.Models.ResultsModel> { new DataAccess.Models.ResultsModel { AwayScore = 0, AwayTeam = "Villa", HomeScore = 3, HomeTeam = "Arsenal", ResultId = Guid.NewGuid() } } }; _resultRepository.Setup(x => x.GetHeadToHeadRecord(1, 2)).Returns(domainRecordsModel); _mapper.Setup(x => x.Map <RecordsModel>(domainRecordsModel)).Returns(recordsModel); }
/// <summary> /// Initializes a new instance of the <see cref="RecordsController" /> class. /// </summary> /// <autogeneratedoc /> /// TODO Edit XML Comment Template for #ctor public RecordsController( ) { MyRecordsModel = new RecordsModel( ); }
public ActionResult Update(RecordsModel model) { var result = _recordRespository.UpdateRecord(model); return(Json(result)); }
public Results CreateFromCsv(Guid memberShipId, string path) { //判断是不是有类型Type Guid typeOutId = Guid.Empty; var typeOut = _typesDapper.GetTypeByName("支付宝支出").ToList(); if (typeOut.Count < 1) { TypesModel typeOutModel = new TypesModel(); typeOutModel.Id = Guid.NewGuid(); typeOutModel.InOrOut = 1; typeOutModel.CreateBy = memberShipId; typeOutModel.CreateOn = DateTime.Now; typeOutModel.Name = "支付宝支出"; var createTypeOutResult = _typesDapper.Create(typeOutModel); if (createTypeOutResult.Success) { typeOutId = typeOutModel.Id; } else { return(new Results("创建类型失败")); } } else { typeOutId = typeOut[0].Id; } Guid typeInId = Guid.Empty; var typeIn = _typesDapper.GetTypeByName("支付宝收入").ToList(); if (typeIn.Count < 1) { TypesModel typeInModel = new TypesModel(); typeInModel.Id = Guid.NewGuid(); typeInModel.InOrOut = 0; typeInModel.CreateBy = memberShipId; typeInModel.CreateOn = DateTime.Now; typeInModel.Name = "支付宝收入"; var createTypeInResult = _typesDapper.Create(typeInModel); if (createTypeInResult.Success) { typeInId = typeInModel.Id; } else { return(new Results("创建类型失败")); } } else { typeInId = typeIn[0].Id; } //添加数据 var dt = FileHelper.OpenCSV(path); var length = dt.Rows.Count; var type1 = dt.Rows[2][10].ToString(); List <RecordsModel> list = new List <RecordsModel>(); for (int i = 0; i < length; i++) { if (!StringHelper.IsNullOrEmptyOrWhiteSpace(dt.Rows[i][10].ToString())) { RecordsModel model = new RecordsModel(); model.Id = Guid.NewGuid(); model.Money = decimal.Parse(dt.Rows[i][9].ToString()); model.Remark = dt.Rows[i][8].ToString(); model.CreateBy = memberShipId; model.CreateOn = StringHelper.DateTimeConver(dt.Rows[i][2].ToString().Split(' ')[0]); model.Source = "支付宝"; var type = dt.Rows[i][10].ToString().TrimEnd(); if (type == "收入") { model.TypeId = typeInId; } if (type == "支出") { model.TypeId = typeOutId; } list.Add(model); } } foreach (var item in list) { _recordDapper.Create(item); } return(new Results()); }
public void UpdateUserRecord(RecordsModel recModel) { _context.UpdateUserRecordById(recModel); }