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