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);
}
public async Task <JsonResult> Action(UserActionModel model)
{
JsonResult jsonResult = new JsonResult();
IdentityResult identityResult;
if (!string.IsNullOrEmpty(model.ID))
{
var User = await UserManager.FindByIdAsync(model.ID);
User.Id = model.ID;
User.UserName = model.UserName;
User.Email = model.Email;
User.PhoneNumber = model.PhoneNumber;
identityResult = await UserManager.UpdateAsync(User);
jsonResult.Data = new { Success = identityResult.Succeeded, Msg = string.Join(",", identityResult.Errors) };
return(jsonResult);
}
else
{
var User = new User
{
UserName = model.UserName,
Email = model.Email,
PhoneNumber = model.PhoneNumber,
};
identityResult = await UserManager.CreateAsync(User);
jsonResult.Data = new { Success = identityResult.Succeeded, Msg = string.Join(",", identityResult.Errors) };
return(jsonResult);
}
}
public async Task <JsonResult> Delete(UserActionModel model)
{
JsonResult json = new JsonResult();
IdentityResult result = null;
if (!string.IsNullOrEmpty(model.ID))
{
var user = await UserManager.FindByIdAsync(model.ID);
user.FullName = model.FullName;
user.Email = model.Email;
user.UserName = model.UserName;
user.Country = model.Country;
user.City = model.City;
user.Address = model.Address;
result = await UserManager.DeleteAsync(user);
json.Data = new { Success = result.Succeeded, Message = string.Join(",", result.Errors) };
}
else
{
json.Data = new { Success = false, Message = "Invalid user" };
}
return(json);
}
public async Task <ActionResult> Action(string ID)
{
UserActionModel model = new UserActionModel();
if (!string.IsNullOrEmpty(ID)) //we are trying to edit a record
{
var user = await UserManager.FindByIdAsync(ID);
model.ID = user.Id;
model.FullName = user.FullName;
model.Email = user.Email;
model.Username = user.UserName;
model.Country = user.Country;
model.City = user.City;
model.Address = user.Address;
}
return(PartialView("_Action", model));
}
public async Task <JsonResult> Delete(UserActionModel model)
{
JsonResult json = new JsonResult();
IdentityResult result = null;
if (!string.IsNullOrEmpty(model.ID)) //we are trying to delete a record
{
var user = await UserManager.FindByIdAsync(model.ID);
result = await UserManager.DeleteAsync(user);
json.Data = new { Success = result.Succeeded, Message = string.Join(", ", result.Errors) };
}
else
{
json.Data = new { Success = false, Message = "Invalid user." };
}
return(json);
}
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 List <UserActionModel> ListQuestionQueries(int QuestionId, int UserId)
{
try
{
List <UserActionModel> queries = new List <UserActionModel>();
using (SqlConnection conn = new SqlConnection(Properties.Settings.Default.DatabaseConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand("SELECT usa_description FROM USERS_ACTIONS WHERE EXQ_ID = @QuestionId AND USAT_ID = 0 AND ISNULL(USA_RESET_DATE, GETDATE()) >= GETDATE() AND US_ID = @UserId AND usa_description LIKE '%update%'", conn))
{
command.Parameters.AddWithValue("QuestionId", QuestionId);
command.Parameters.AddWithValue("UserId", UserId);
using (SqlDataReader reader = command.ExecuteReader())
{
// Execute each command in the history
while (reader.Read())
{
UserActionModel query = new UserActionModel();
query.Description = (String)reader["usa_description"];
queries.Add(query);
}
}
}
}
return(queries);
}
catch (Exception)
{
throw;
}
}
public ResultMessageModel LoginUser(UserActionModel userActionModel)
{
UserActionDataAccess userActionDataAccess = new UserActionDataAccess();
ResultMessageModel result = userActionDataAccess.LoginUser(userActionModel);
return(result);
}
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);
}
public async Task <ActionResult> Delete(string ID)
{
UserActionModel model = new UserActionModel();
var user = await UserManager.FindByIdAsync(ID);
model.ID = user.Id;
return(PartialView("_Delete", model));
}
//// 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 async Task <ActionResult> Delete(UserActionModel model)
{
var user = await UserManager.FindByIdAsync(model.ID);
await UserManager.DeleteAsync(user);
return(RedirectToAction("Index"));
}
public ActionResult Delete(int ID)
{
UserActionModel model = new UserActionModel();
var user = services.GetUserByID(ID);
model.UserID = user.UserID;
return(PartialView("_Delete", model));
}
public async Task <ActionResult> Edit(UserActionModel model)
{
var user = await UserManager.FindByIdAsync(model.ID);
user.FullName = model.FullName;
user.UserName = model.UserName;
user.Email = model.Email;
user.Phone = model.Phone;
user.Address = model.Address;
await UserManager.UpdateAsync(user);
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Action(UserActionModel model)
{
var user = new SMSUser();
user.FullName = model.FullName;
user.UserName = model.UserName;
user.Email = model.Email;
user.Phone = model.Phone;
user.Address = model.Address;
await UserManager.CreateAsync(user);
return(RedirectToAction("Index"));
}
public JsonResult AddAndEdit(UserActionModel model)
{
JsonResult json = new JsonResult();
var result = false;
if (model.UserID > 0)
{
var user = services.GetUserByID(model.UserID);
user.RoleID = model.RoleID;
user.UserName = model.UserName;
user.Password = model.Password;
user.EmailAddress = model.EmailAddress;
user.MobileNo = model.MobileNo;
user.Address = model.Address;
user.BillingAddress = model.BillingAddress;
user.UpdatedAt = DateTime.Now;
result = services.UpdateUser(user);
}
else
{
User user = new User();
user.RoleID = model.RoleID;
user.UserName = model.UserName;
user.Password = model.Password;
user.EmailAddress = model.EmailAddress;
user.MobileNo = model.MobileNo;
user.Address = model.Address;
user.BillingAddress = model.BillingAddress;
user.UpdatedAt = DateTime.Now;
result = services.SaveUser(user);
}
if (result)
{
json.Data = new { Success = true };
}
else
{
json.Data = new { Success = false, Message = "Unable to perform action on Main Menu" };
}
return(json);
}
public async Task <ActionResult> Action(string ID)
{
UserActionModel model = new UserActionModel();
if (!string.IsNullOrEmpty(ID))
{
User objectFirst = await UserManager.FindByIdAsync(ID);
model.ID = objectFirst.Id;
model.UserName = objectFirst.UserName;
model.Email = objectFirst.Email;
model.PhoneNumber = objectFirst.PhoneNumber;
}
//model.Roles = provinceService.GetAll();
return(PartialView("_Action", model));
}
public ResultMessageModel LoginUser(UserActionModel userActionModel) // 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_Login", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@pUserName", SqlDbType.VarChar, 50);
cmd.Parameters["@pUserName"].Value = userActionModel.UserName;
cmd.Parameters.Add("@pPassword", SqlDbType.VarChar, 50);
cmd.Parameters["@pPassword"].Value = userActionModel.ActionData;
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 async Task <ActionResult> Edit(string ID)
{
UserActionModel model = new UserActionModel();
if (!string.IsNullOrEmpty(ID))
{
var user = await UserManager.FindByIdAsync(ID);
model.ID = user.Id;
model.UserName = user.UserName;
model.FullName = user.FullName;
model.Address = user.Address;
model.Phone = user.Phone;
model.Email = user.Email;
}
return(PartialView("_Edit", model));
}
public async Task <ActionResult> Delete(string ID)
{
if (!string.IsNullOrEmpty(ID))
{
var User = await UserManager.FindByIdAsync(ID);
UserActionModel model = new UserActionModel
{
ID = User.Id,
UserName = User.UserName
};
return(PartialView("_Delete", model));
}
else
{
return(PartialView("_Delete"));
}
}
public async Task <ActionResult> Action(string ID)
{
UserActionModel model = new UserActionModel();
if (!string.IsNullOrEmpty(ID))
{
var user = await UserManager.FindByIdAsync(ID);
model.ID = user.Id;
model.FullName = user.FullName;
model.Email = user.Email;
model.UserName = user.UserName;
model.Country = user.Country;
model.City = user.City;
model.Address = user.Address;
}
// model.Role = accomodationPS.GetAllaCOMOdationPS();
return(PartialView("_Action", model));
}
public async Task <ActionResult> Delete(UserActionModel model)
{
JsonResult jsonResult = new JsonResult();
IdentityResult identityResult;
if (!string.IsNullOrEmpty(model.ID))
{
var user = await UserManager.FindByIdAsync(model.ID);
identityResult = await UserManager.DeleteAsync(user);
jsonResult.Data = new { Success = identityResult.Succeeded, Message = string.Join(",", identityResult.Errors) };
}
else
{
jsonResult.Data = new { Success = false, Message = "Empty Record " };
}
return(jsonResult);
}
public ActionResult AddAndEdit(int?ID)
{
UserActionModel model = new UserActionModel();
if (ID.HasValue)
{
var User = services.GetUserByID(ID.Value);
model.UserID = User.UserID;
model.RoleID = User.RoleID;
model.UserName = User.UserName;
model.Password = User.Password;
model.UserName = User.UserName;
model.EmailAddress = User.EmailAddress;
model.MobileNo = User.MobileNo;
model.Address = User.Address;
model.BillingAddress = User.BillingAddress;
}
model.Roles = roleServices.GetAllRoles();
return(PartialView("_AddAndEdit", model));
}
public JsonResult Delete(UserActionModel model)
{
JsonResult json = new JsonResult();
var result = false;
var user = services.GetUserByID(model.UserID);
result = services.DeleteUser(user);
if (result)
{
json.Data = new { Success = true };
}
else
{
json.Data = new { Success = false, Message = "Unable to perform action on Main Menu" };
}
return(json);
}
public async Task <JsonResult> Action(UserActionModel model)
{
JsonResult json = new JsonResult();
IdentityResult result = null;
if (!string.IsNullOrEmpty(model.ID)) //we are trying to edit a record
{
var user = await UserManager.FindByIdAsync(model.ID);
user.FullName = model.FullName;
user.Email = model.Email;
user.UserName = model.Username;
user.Country = model.Country;
user.City = model.City;
user.Address = model.Address;
result = await UserManager.UpdateAsync(user);
}
else //we are trying to create a record
{
var user = new HBUser();
user.FullName = model.FullName;
user.Email = model.Email;
user.UserName = model.Username;
user.Country = model.Country;
user.City = model.City;
user.Address = model.Address;
result = await UserManager.CreateAsync(user);
}
json.Data = new { Success = result.Succeeded, Message = string.Join(", ", result.Errors) };
return(json);
}
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);
}
public void SubscribeWithnoController(ReciveUserActionModel model)
{
try
{
List <UserActionModel> list = new List <UserActionModel>();
_logger.LogDebug($"SubscribeWithnoController:收到数据向Redis添加:{model.areaid}大厅,{model.type}类型,{model.platForm}平台,{model.version}版本,时间:{model.date},系统时间{DateTime.Now}");
//向rides list添加元素
DateTime time = model.date;
//获取uuid
string config = model.data;
JObject jo = JsonConvert.DeserializeObject <JObject>(config);
string uuid = " ";
if (jo.Property("UUID") != null)
{
uuid = jo["UUID"].ToString();
}
UserActionModel user = new UserActionModel()
{
id = model.id,
areaid = model.areaid,
date = model.date,
uid = model.uid,
version = model.version,
uuid = uuid,
platForm = model.platForm,
type = model.type
};
string ktime = "";
if (time.Minute > 0)
{
ktime = time.AddHours(1).ToString("yyyyMMddHH");
}
else
{
ktime = time.ToString("yyyyMMddHH");
}
list.Add(user);
_cache._redisProvider.RPush($"{model.areaid}_t{ktime}", list);
Random rand = new Random();
//7天保存
int second = 7 * ((int)KeyExpireTime.realData);
_cache._redisProvider.KeyExpire($"{model.areaid}_t{ktime}", second);
var checkAct = _repository.QueryByContion(model.areaid, model.uid, model.type, model.platForm, model.version, uuid);
if (checkAct == null)
{
UserActionStatisticsModel actStat = new UserActionStatisticsModel()
{
areaid = model.areaid,
type = model.type,
platForm = model.platForm == null?" ":model.platForm,
uid = model.uid,
uuid = uuid,
added = model.date,
version = model.version == null?" ":model.version
};
List <UserActionStatisticsModel> stlist = new List <UserActionStatisticsModel>();
if (!string.IsNullOrEmpty(uuid) || actStat.uid != 0)
{
stlist.Add(actStat);
_repository.Insert(stlist);
}
}
//List<string> keys = new List<string>();
//string configKeys;
//foreach (var item in jo)
//{
// keys.Add(item.Key);
//}
//configKeys = string.Join(",", keys);
//var areaParams = _repository.GetAreaParams(model.areaid, model.type);
//if (areaParams != null)
//{
// if (configKeys.Equals(areaParams.configKeys))
// {
// return;
// }
// var akeys = areaParams.configKeys.Split(',');
// keys.Concat(akeys).ToList().Distinct();
// areaParams.configKeys = string.Join(",", keys);
// _repository.UpdateAreaParams(areaParams);
//}
//else
//{
// _repository.Insert(new List<AreaParamsModel>() {
// new AreaParamsModel()
// {
// areaid=model.areaid,
// configKeys=configKeys,
// type=model.type
// }
// });
//}
#region 检查版本号
//_logger.LogInformation($"SubscribeWithnoController:检查版本号");
var check = _repository.CheckAreaVersion(model.areaid, model.version.Trim());
List <AreaVersion> vs = new List <AreaVersion>()
{
new AreaVersion {
areaid = model.areaid, version = model.version.Trim()
}
};
if (check.Count == 0)
{
var res = _repository.Insert(vs);
}
if (check.Count > 1)
{
_repository.Delete(check);
_repository.Insert(vs);
}
#endregion
}
catch (Exception e)
{
_logger.LogError($"SubscribeWithnoController:{e.Message}");
}
}
public async Task <ActionResult> UserRole(UserActionModel model)
{
return(RedirectToAction("Index"));
}
