public ActionResult RegisterUserInRun(RunModel run)
{
UserModel user = UserHandler.GetUserDataByToken(Request.Headers["authorization"], true);
string sqlProc = "exec RegisterUserInRun";
Dictionary <string, object> queryParams = new Dictionary <string, object> {
{ "@runId", run.Id },
{ "@userId", user.Id },
{ "@registerdSide", RegistredSide.user.ToString() }
};
DbHandler dbHandler = new DbHandler();
dbHandler.GenerateProcedure(sqlProc, queryParams);
sqlProc = dbHandler.AddParamsToQuery(sqlProc, queryParams);
try
{
dbHandler.ExecuteQuery(sqlProc, queryParams);
}catch (Exception e)
{
string response = JsonConvert.SerializeObject(new { id = run.Id, messege = e.Message });
return(Conflict(response));
}
return(Ok());
}
private void UpdateUserDataInDB(UserModel newUserModel)
{
string sqlProc = "exec UpdateUserData";
Dictionary <string, object> queryParams = new Dictionary <string, object> {
{ "@Id", newUserModel.Id },
{ "@UserType", newUserModel.UserType },
{ "@UserLogin", newUserModel.UserLogin },
{ "@UserPass", newUserModel.UserPass },
{ "@UserName", newUserModel.UserName },
{ "@UserSureName", newUserModel.UserSureName },
{ "@UserTaxNumber", newUserModel.UserTaxNumber },
{ "@UserAddress", newUserModel.UserAddress },
{ "@UserCity", newUserModel.UserCity },
{ "@UserZipCode", newUserModel.UserZipCode },
{ "@UserMail", newUserModel.UserMail },
{ "@UserPhoneNumber", newUserModel.UserPhoneNumber },
{ "@UserPhoneNumber2", newUserModel.UserPhoneNumber2 },
{ "@UserSalt", newUserModel.UserSalt },
{ "@UserRole", newUserModel.UserRole },
{ "@Confirmed", newUserModel.Confirmed }
};
DbHandler dbHandler = new DbHandler();
dbHandler.GenerateProcedure(sqlProc, queryParams);
sqlProc = dbHandler.AddParamsToQuery(sqlProc, queryParams);
DataSet dataSet = dbHandler.GetSetFromDb(sqlProc, queryParams);
}
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());
}