public ActionResult AddCompetition(CompetitionModel competition)
{
UserModel owner = UserHandler.GetUserDataByToken(Request.Headers["authorization"]);
owner = UserHandler.GetUserDataFromDbByLogin(owner.UserLogin);
#region dbAccess
string sqlProc = "exec dbo.AddCompetition";
Dictionary <string, object> queryParams = new Dictionary <string, object> {
{ "@description", competition.description },
{ "@startTime", competition.startTime.ToString("yyyy-MM-dd HH:mm:ss.fff") },
{ "@endTime", competition.endTime.ToString("yyyy-MM-dd HH:mm:ss.fff") },
{ "@placeOf", competition.placeOf },
{ "@ownerId", competition.ownerId }
};
DbHandler dbHandler = new DbHandler();
dbHandler.GenerateProcedure(sqlProc, queryParams);
dbHandler.GenerateQuerryValues(sqlProc, queryParams);
sqlProc = dbHandler.AddParamsToQuery(sqlProc, queryParams);
try
{
UserModel userModel = new UserModel();
DataSet dataSet = dbHandler.GetSetFromDb(sqlProc, queryParams);
foreach (DataRow row in dataSet.Tables["tab"].Rows)
{
userModel.UserMail = row["UserMail"].ToString();
userModel.UserLogin = row["UserLogin"].ToString();
}
return(Ok());
}
catch (Exception e)
{
return(Conflict(e.Message));
}
#endregion
return(Ok());
}
public ActionResult ValidateUser(string code)
{
string sqlProc = "exec dbo.ValidateUser";
Dictionary <string, object> queryParams = new Dictionary <string, object> {
{ "@Code", code }
};
DbHandler dbHandler = new DbHandler();
sqlProc = dbHandler.AddParamsToQuery(sqlProc, queryParams);
try
{
DataSet dataSet = dbHandler.GetSetFromDb(sqlProc, queryParams);
return(Ok(new { Result = "Confirmation ok" }));
}
catch (Exception e)
{
return(Conflict(new { Result = "Code is not good" }));
}
//CodeModel codeModel = _repositoryCodes.GetCodeModelByCode(code);
//bool codeIsValid = CodeHandler.IsCodeValid(codeModel, MailType.varyfication);
//if (codeIsValid)
//{
// UserModel userModel = _repositoryUsers.GetUserById(codeModel.UserId);
// UserModel userModelToSave = new UserModel();
// userModel.Confirmed = true;
// userModelToSave = userModel;
// ChangeUserData(userModelToSave, userModel);
// CodeModel usedCode = _repositoryCodes.GetCodeModelByCode(code);
// CodeModel CodeModelToSave = CodeHandler.DeactivateCode(usedCode, userModel);
// ChangeCodeData(CodeModelToSave, usedCode);
//}
}
static public UserModel GetUserDataFromDbByLogin(string login)
{
UserModel userModel = new UserModel();
string sqlProc = "SELECT * FROM Users WHERE UserLogin = @UserLogin";
Dictionary <string, object> queryParams = new Dictionary <string, object> {
{ "@UserLogin", login }
};
DbHandler dbHandler = new DbHandler();
try
{
DataSet dataSet = dbHandler.GetSetFromDb(sqlProc, queryParams);
foreach (DataRow row in dataSet.Tables["tab"].Rows)
{
userModel.Id = row["Id"].ToString();
userModel.UserType = row["UserType"].ToString();
userModel.UserLogin = row["UserLogin"].ToString();
userModel.UserPass = row["UserPass"].ToString();
userModel.UserName = row["UserName"].ToString();
userModel.UserSureName = row["UserSureName"].ToString();
userModel.UserTaxNumber = row["UserTaxNumber"].ToString();
userModel.UserAddress = row["UserAddress"].ToString();
userModel.UserCity = row["UserCity"].ToString();
userModel.UserZipCode = row["UserZipCode"].ToString();
userModel.UserMail = row["UserMail"].ToString();
userModel.UserPhoneNumber = row["UserPhoneNumber"].ToString();
userModel.UserPhoneNumber2 = row["UserPhoneNumber2"].ToString();
userModel.UserSalt = row["UserSalt"].ToString();
userModel.UserRole = row["UserRole"].ToString();
userModel.Confirmed = Convert.ToBoolean(row["Confirmed"]);
}
}
catch (Exception e)
{
}
return(userModel);
}
public ActionResult <IEnumerable <RunDto> > GetRunByCompetitionId(string Id)
{
UserModel user = UserHandler.GetUserDataByToken(Request.Headers["authorization"], true);
string sqlProc = "SELECT * FROM run (NOLOCK) WHERE competitionId = @competitionId";
Dictionary <string, object> queryParams = new Dictionary <string, object> {
{ "@competitionId", Id }
};
DbHandler dbHandler = new DbHandler();
DataSet dataSet = dbHandler.GetSetFromDb(sqlProc, queryParams);
int numberOfRuns = dataSet.Tables["tab"].Rows.Count;
RunModel[] runModels = new RunModel[numberOfRuns];
int runIterator = 0;
foreach (DataRow row in dataSet.Tables["tab"].Rows)
{
RunModel runModel = new RunModel();
runModel.competitionId = row["competitionId"].ToString();
runModel.Id = row["Id"].ToString();
runModel.ownerId = row["ownerId"].ToString();
runModel.description = row["description"].ToString();
runModel.target = row["target"].ToString();
runModel.noOfShots = int.Parse(row["noOfShots"].ToString());
runModels[runIterator] = runModel;
runIterator++;
}
//RunModel[] runModels = GetRunsByCompIdAndUserID(Id, user.Id);
return(Ok(runModels));
//user = _repositoryUsers.GetUserByLogin(user.UserLogin);
//var run = _repositoryRun.GetRunByCompetitionId(id);
//return Ok(_mapper.Map<IEnumerable<RunDto>>(run));
}