public ResultMessageModel UserCreateRoom(UserActionModel userActionModel)
{
UserActionDataAccess userActionDataAccess = new UserActionDataAccess();
ResultMessageModel result = userActionDataAccess.UserCreateRoom(userActionModel);
return(result);
}
public ResultMessageModel UserGetRoomActive(UserActionModel userActionModel)
{
UserActionDataAccess userActionDataAccess = new UserActionDataAccess();
ResultMessageModel result = userActionDataAccess.GetRoomActive();
return(result);
}
async Task <ResultMessageModel> CreateRoom(int iUserID)
{
ResultMessageModel result = new ResultMessageModel();
try
{
UserActionModel userActionModel = new UserActionModel();
userActionModel.UserID = currentUser.UserID;
userActionModel.ActionType = USER_ACTION_TYPE.USER_CREATE_ROOM;
var client = new RestClient(ConfigurationManager.AppSettings["API_URL"].ToString());
var request = new RestRequest("api/UserAction");
request.AddObject(userActionModel);
request.Method = Method.POST;
var response = client.Post(request);
var content = response.Content; // raw content as string
result = JsonConvert.DeserializeObject <ResultMessageModel>(content);
}
catch (Exception ex)
{
result.Result = -1;
result.ResultID = 0;
result.ResultMessage = ex.Message;
}
return(result);
}
public ResultMessageModel LoginUser(UserActionModel userActionModel)
{
UserActionDataAccess userActionDataAccess = new UserActionDataAccess();
ResultMessageModel result = userActionDataAccess.LoginUser(userActionModel);
return(result);
}
static async Task <ResultMessageModel> LoginAsync(UserActionModel userActionModel)
{
ResultMessageModel result = new ResultMessageModel();
try
{
var client = new RestClient(ConfigurationManager.AppSettings["API_URL"].ToString());
var request = new RestRequest("api/UserAction");
request.AddObject(userActionModel);
request.Method = Method.POST;
var response = client.Post(request);
var content = response.Content; // raw content as string
result = JsonConvert.DeserializeObject <ResultMessageModel>(content);
if (result == null)
{
result = new ResultMessageModel();
result.Result = -1;
result.ResultMessage = "CALL_API_FAIL";
}
}
catch
{
result.Result = -1;
result.ResultMessage = "LOGIN_FAIL";
}
return(result);
}
// POST api/user
public HttpResponseMessage Post(UserModel user)
{
ResultMessageModel result = this.userRepository.SaveUser(user);
var response = Request.CreateResponse <ResultMessageModel>(System.Net.HttpStatusCode.OK, result);
return(response);
}
//// GET: api/UserAction
//public IEnumerable<string> Get()
//{
// return new string[] { "value1", "value2" };
//}
//// GET: api/UserAction/5
//public string Get(int id)
//{
// return "value";
//}
// POST: api/UserAction
public HttpResponseMessage Post(UserActionModel userActionModel)
{
ResultMessageModel result = userActionRepository.ProcessAction(userActionModel);
var response = Request.CreateResponse <ResultMessageModel>(System.Net.HttpStatusCode.OK, result);
return(response);
}
public ResultMessageModel CreateUser(UserModel umUser) // passing Bussiness object Here
{
ResultMessageModel result = new ResultMessageModel();
try
{
/* Because We will put all out values from our (UserRegistration.aspx)
* To in Bussiness object and then Pass it to Bussiness logic and then to
* DataAcess
* this way the flow carry on*/
SqlCommand cmd = new SqlCommand("usp_USER_CreateUser", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@pUserName", SqlDbType.VarChar, 50);
cmd.Parameters["@pUserName"].Value = umUser.UserName;
cmd.Parameters.Add("@pPassword", SqlDbType.VarChar, 50);
cmd.Parameters["@pPassword"].Value = umUser.Password;
cmd.Parameters.Add("@pEmail", SqlDbType.VarChar, 255);
cmd.Parameters["@pEmail"].Value = umUser.Email;
cmd.Parameters.Add("@pAddress", SqlDbType.NVarChar, 8000);
cmd.Parameters["@pAddress"].Value = umUser.Address;
cmd.Parameters.Add("@pPhone", SqlDbType.VarChar, 50);
cmd.Parameters["@pPhone"].Value = umUser.Phone;
cmd.Parameters.Add("@pResult", SqlDbType.Int);
cmd.Parameters.Add("@pResultID", SqlDbType.Int);
cmd.Parameters.Add("@pResultMessage", SqlDbType.VarChar, 50);
cmd.Parameters["@pResult"].Direction = ParameterDirection.Output;
cmd.Parameters["@pResultID"].Direction = ParameterDirection.Output;
cmd.Parameters["@pResultMessage"].Direction = ParameterDirection.Output;
con.Open();
cmd.ExecuteNonQuery();
result.Result = (int)cmd.Parameters["@pResult"].Value;
if (result.Result > 0)
{
result.ResultID = (int)cmd.Parameters["@pResultID"].Value;
}
result.ResultMessage = cmd.Parameters["@pResultMessage"].Value.ToString();
cmd.Dispose();
}
catch (Exception ex)
{
result.Result = -1;
result.ResultMessage = ex.Message;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(result);
}
public ResultMessageModel GetRoomActive()
{
ResultMessageModel result = new ResultMessageModel();
List <RoomModel> roomList = new List <RoomModel>();
try
{
/* Because We will put all out values from our (UserRegistration.aspx)
* To in Bussiness object and then Pass it to Bussiness logic and then to
* DataAcess
* this way the flow carry on*/
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand("usp_USER_GetRoomActive", con);
cmd.CommandType = CommandType.StoredProcedure;
da.SelectCommand = cmd;
da.Fill(dt);
cmd.Dispose();
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
roomList.Add(UtilsRepository.CreateItemFromRow <RoomModel>(row));
}
result.Result = dt.Rows.Count;
result.ResultID = 1;
result.ResultMessage = JsonConvert.SerializeObject(roomList);
}
else
{
result.Result = 0;
result.ResultID = 0;
result.ResultMessage = "NO_ROOM_ACTIVE";
}
}
catch (Exception ex)
{
result.Result = -1;
result.ResultID = 0;
result.ResultMessage = ex.Message;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(result);
}
private async void frmMain_Load(object sender, EventArgs e)
{
currentUser = await GetUserInfo(this.currentUser.UserID);
if (currentUser != null)
{
tbUserName.Text = currentUser.UserName;
tbPoint.Text = currentUser.Point.ToString();
tbRank.Text = currentUser.Rank.ToString();
this.Text = currentUser.UserName;
}
ResultMessageModel result = await GetRoomActive();
if (result.Result > 0)
{
listRoomModel.Clear();
listRoomModel = JsonConvert.DeserializeObject <List <RoomModel> >(result.ResultMessage);
RefreshRoomList();
}
}
private async void btCreateRoom_Click(object sender, EventArgs e)
{
//UserActionModel userAction = new UserActionModel();
//userAction.UserID = currentUser.UserID;
//userAction.ActionType = USER_ACTION_TYPE.USER_CREATE_ROOM;
ResultMessageModel result = await CreateRoom(currentUser.UserID);
if (result.Result > 0)
{
result = await GetRoomActive();
if (result.Result > 0)
{
listRoomModel.Clear();
listRoomModel = JsonConvert.DeserializeObject <List <RoomModel> >(result.ResultMessage);
RefreshRoomList();
}
}
}
public ResultMessageModel SaveUser(UserModel contact)
{
var ctx = HttpContext.Current;
ResultMessageModel result = new ResultMessageModel();
if (ctx != null)
{
try
{
UserDataAccess userDataAccess = new UserDataAccess();
result = userDataAccess.CreateUser(contact);
if (result.Result > 0)
{
// Email Message Code
var currentData = ((UserModel[])ctx.Cache[CacheKey]).ToList();
currentData.Add(contact);
ctx.Cache[CacheKey] = currentData.ToArray();
return(result);
}
else
{
return(result);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
result.Result = -1;
result.ResultMessage = ex.ToString();
return(result);
}
}
result.Result = -1;
result.ResultMessage = "DONT_HAVE_CONTEXT";
return(result);
}
private async void btLogin_Click(object sender, EventArgs e)
{
UserActionModel userActionModel = new UserActionModel();
userActionModel.UserName = tbUserName.Text;
userActionModel.ActionData = tbPassword.Text;
userActionModel.ActionType = USER_ACTION_TYPE.USER_LOGIN;
ResultMessageModel result = await LoginAsync(userActionModel);
if (result.Result > 0)//login ok
{
userActionModel.UserID = (int)result.ResultID;
this.Hide();
frmMain fMain = new frmMain();
fMain.currentUser.UserID = userActionModel.UserID;
fMain.ShowDialog();
this.Close();
}
else
{
MessageBox.Show(result.ResultMessage);
}
}
public ResultMessageModel ProcessAction(UserActionModel userActionModel)
{
ResultMessageModel result = new ResultMessageModel();
UserDataAccess userDataAccess = new UserDataAccess();
try
{
if (userActionModel.UserID <= 0)
{
userActionModel.UserID = userDataAccess.GetUserIDByUserName(userActionModel.UserName);
}
if (userActionModel.ActionType == USER_ACTION_TYPE.USER_ACTIVE)
{
result = ActiveUser(userActionModel);
}
else if (userActionModel.ActionType == USER_ACTION_TYPE.USER_LOGIN)
{
result = LoginUser(userActionModel);
}
else if (userActionModel.ActionType == USER_ACTION_TYPE.USER_GET_ROOM_LIST)
{
result = UserGetRoomActive(userActionModel);
}
else if (userActionModel.ActionType == USER_ACTION_TYPE.USER_CREATE_ROOM)
{
result = UserCreateRoom(userActionModel);
}
}
catch (Exception ex)
{
result.Result = -1;
result.ResultID = 0;
result.ResultMessage = ex.Message;
}
return(result);
}
/// <summary>
/// Comprueba un mensaje
/// </summary>
private void CheckMessageCommand(ResultMessageModel source, ResultMessageModel target)
{
Assert.Equal(Normalize(source.Message), Normalize(target.Message));
}
