public ActionResult Login(UserInfoModel model)
{
if (string.IsNullOrEmpty(model.LoginName))
{
return(View(model));
}
else
{
string keyword = StringCipherCls.EncryptDES(model.Password, StringCipherCls.keyIn);
UserInfoEntity usermodel = IUserLogic.Load(model.LoginName); //登录用户
if ((usermodel != null) && (usermodel.Password == keyword))
{
Response.Cookies["UserId"].Value = usermodel.UserId;
Response.Cookies["UserId"].Expires = System.DateTime.Now.AddHours(1);
//Response.Cookies["UserName"].Value = usermodel.UserName;
Response.Cookies["UserName"].Value = HttpUtility.UrlEncode(usermodel.UserName, Encoding.GetEncoding("UTF-8"));
Response.Cookies["UserName"].Expires = System.DateTime.Now.AddHours(1);
return(RedirectToAction("Index", "Home"));
}
else
{
model.Msg = "用户名密码错误！";
return(View(model));
//return RedirectToAction("Login", "Home");
}
}
}
/// <summary>
/// 填写用户信息
/// </summary>
/// <param name="userInfo"></param>
/// <returns></returns>
public long AddUserInfo(UserInfoDTO userInfo)
{
using (B2CDbContext ctx = new B2CDbContext())
{
BaseService <CardTypeEntity> cardType
= new BaseService <CardTypeEntity>(ctx);
UserInfoEntity userInfoEntity = new UserInfoEntity();
userInfoEntity.Address = userInfo.Address;
userInfoEntity.Email = userInfo.Email;
userInfoEntity.Gender = userInfo.Gender;
userInfoEntity.IDCardNo = userInfo.IDCardNo;
userInfoEntity.Money = userInfo.Money;
userInfoEntity.PassAnswer = userInfo.PassAnswer;
userInfoEntity.PassQuestion = userInfo.PassQuestion;
string salt = CommomHelper.CreateVerifyCode(5);
string hash = CommomHelper.CalcMD5(salt + userInfo.Password);
userInfoEntity.PassWordSalt = salt;
userInfoEntity.PassWordHash = hash;
userInfoEntity.PhoneNumber = userInfo.PhoneNumber;
userInfoEntity.RoleInfoId = userInfo.RoleId;
userInfoEntity.UserName = userInfo.UserName;
userInfoEntity.UserStateId = userInfo.UserStateId;
foreach (var item in cardType.GetAll().Where(a => userInfo.CardTypeIds.Contains(a.Id)))
{
userInfoEntity.CardTypes.Add(item);
}
ctx.UserInfos.Add(userInfoEntity);
ctx.SaveChanges();
return(userInfoEntity.Id);
}
}
public void Login(HttpContext context)
{
string name = context.Request["name"];
string pwd = context.Request["pwd"];
//context.Response.ContentType = "text/plain";
DataTable dt = new UserInfoBLL().GetTable(name, pwd);
if (dt.Rows.Count > 0)
{
string id = dt.Rows[0][0].ToString();
context.Session["getuser"] = new UserInfoBLL().GetInfoById(id);
UserInfoEntity obj = (UserInfoEntity)context.Session["getuser"];
if (obj.UserStatr == 1)
{
//context.Session["user"] = dt;
//修改最后登录时间
new UserInfoBLL().GetUpadteLoginTime(obj.UserID.ToString());
contextResponseWrite(context, dt);
}
else
{
contextResponseWrite(context, "enableed");
return;
}
}
else
{
contextResponseWrite(context, "1");
}
}
/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="o">用户对象的实例</param>
/// <returns>bool</returns>
public static bool UpdateInfo(UserInfoEntity o)
{
string sql = " UPDATE UserInfo SET " +
"DepartmentID = @departmentid," +
"RoleID = @roleid," +
"UserFace = @userface," +
"UserName = @username," +
"UserAge = @userage," +
"UserSex = @usersex," +
"UserTel = @usertel," +
"UserAddress = @useraddress," +
"UserIphone = @useriphone," +
"UserRemarks = @userremarks," +
"BasePay = @basepay " +
" WHERE UserID = @userid";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@departmentid", o.DepartmentID),
new SqlParameter("@roleid", o.RoleID),
new SqlParameter("@userface", o.UserFace),
new SqlParameter("@username", o.UserName),
new SqlParameter("@userage", o.UserAge),
new SqlParameter("@usersex", o.UserSex),
new SqlParameter("@usertel", o.UserTel),
new SqlParameter("@useraddress", o.UserAddress),
new SqlParameter("@useriphone", o.UserIphone),
new SqlParameter("@userremarks", o.UserRemarks),
new SqlParameter("@basepay", o.BasePay),
new SqlParameter("@userid", o.UserID),
};
return(DBHelper.UpdateOpera(sql, parameters));
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html";
int id;
if (int.TryParse(context.Request.QueryString["id"], out id))
{
UserInfoEntity userInfo = userInfoService.GetUserInfoByUserId(id);
if (userInfo != null)
{
string filePath = context.Request.MapPath("ShowEditUser.html");
string fileContent = File.ReadAllText(filePath);
fileContent = fileContent.Replace("$name", userInfo.UserName)
.Replace("$age", userInfo.UserAge.ToString())
.Replace("$pwd", userInfo.UserPwd)
.Replace("$Id", userInfo.UserId.ToString());
context.Response.Write(fileContent);
}
else
{
context.Response.Write("查无此人！！！");
}
}
else
{
context.Response.Write("参数错了！！！");
}
}
private static string GetLocationInfo(UserInfoEntity userInfo)
{
if (userInfo == null)
{
return(string.Empty);
}
string text = "";
if (!string.IsNullOrEmpty(userInfo.Province) && !string.IsNullOrEmpty(userInfo.City))
{
text = string.Format("{0} {1}", userInfo.Province, userInfo.City);
}
else if (string.IsNullOrEmpty(userInfo.Province) && !string.IsNullOrEmpty(userInfo.City))
{
text = userInfo.City;
}
else if (string.IsNullOrEmpty(userInfo.City) && !string.IsNullOrEmpty(userInfo.Province))
{
text = userInfo.Province;
}
if (text.Length > 8)
{
return(text.CutText(10));
}
return(text);
}
public UserInfoEntity GetUserInfoByOpenId(string openId)
{
if (string.IsNullOrEmpty(openId))
{
return(null);
}
UserInfoEntity userInfo = null;
string cacheKey = RedisKeyConst.UserInfoKeyByOpenIdCacheKey(openId);
string userInfoKey = redisClient.Get(cacheKey);
if (!string.IsNullOrEmpty(userInfoKey))
{
userInfo = redisClient.Get <UserInfoEntity>(userInfoKey);
}
if (userInfo != null)
{
return(userInfo);
}
userInfo = userInfoDao.GetUserInfoByOpenId(openId);
if (userInfo != null)
{
if (string.IsNullOrEmpty(userInfoKey))
{
userInfoKey = RedisKeyConst.UserInfoByOpenIdAndUIdCacheKey(userInfo.OpenId, userInfo.UId);
redisClient.Set(cacheKey, userInfoKey, RedisKeyConst.UserInfoCacheSecond);
}
//缓存一个月
redisClient.Set(userInfoKey, userInfo, RedisKeyConst.UserInfoCacheSecond);
}
return(userInfo);
}
//修改
public void UpdatebyId(HttpContext context)
{
string id = context.Request["userid"];
string str = context.Request["Eentity"];
string[] obj = str.Split(',');
UserInfoEntity o = new UserInfoEntity()
{
};
o.UserID = Convert.ToInt32(id);
o.UserFace = (obj[0].IndexOf(".") != -1) ? (obj[1] + obj[0].Substring(obj[0].LastIndexOf("."))) : "";
o.UserName = obj[1];
o.DepartmentID = Convert.ToInt32(obj[2]);
o.RoleID = Convert.ToInt32(obj[3]);
o.UserAge = Convert.ToInt32(obj[4]);
o.UserSex = Convert.ToInt32(obj[5]);
o.UserTel = (obj[6]);
o.UserIphone = (obj[6]);
o.UserAddress = obj[7];
o.UserRemarks = obj[8];
o.BasePay = Convert.ToDouble(obj[9]);
//bool bo = new UserInfoBLL().UpdateInfo(o);
if (new UserInfoBLL().UpdateInfo(o))
{
LoginHandler.contextResponseWrite(context, "updatesuccess");
}
else
{
LoginHandler.contextResponseWrite(context, "updatefailed");
}
}
public JsonResult Login(string UserName, string UserPassword, bool RememberMe)
{
UserInfoEntity user = repository.GetUserInfo(UserName);
bool loginResult = false;
string loginMsg = "";
if (user == null)
{
loginMsg = "用户名不存在";
}
else if (user.UserPass != UserPassword)
{
loginMsg = "用户密码错误";
}
else
{
FormsAuthentication.SetAuthCookie(UserName, RememberMe);
user.LastLoginTime = DateTime.Now;
repository.SaveUserInfo(user);
loginResult = true;
}
if (loginResult)
{
return(Json(new { result = loginResult, loginMsg = loginMsg, UserID = user.UserID }));
}
else
{
return(Json(new { result = loginResult, loginMsg = loginMsg }));
}
}
public async Task<Response<OperationResult>> AddUserInfo(string userId, UserInfoDTO model)
{
var responce = new Response<OperationResult>()
{
Data = OperationResult.Failed
};
var isExist = await _context.Users.AnyAsync(x => x.Id == userId);
if (!isExist)
{
responce.Error = new Error("User can`t be founded by user id");
return responce;
}
var infoEnity = new UserInfoEntity(model, userId);
await _context.UsersInfo.AddAsync(infoEnity);
await _context.SaveChangesAsync();
var user = await _context.Users.FirstOrDefaultAsync(x => x.Id == userId);
user.UserInfo = infoEnity;
_context.Update(user);
await _context.SaveChangesAsync();
responce.Data = OperationResult.Success;
return responce;
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
//接收数据，显示未修改之前的值
int id = Convert.ToInt32(context.Request.Form["txtId"]);//接收隐藏域的值
UserInfoService userInfoService = new UserInfoService();
//拿到userInfo对象方式一：
//UserInfoEntity userInfo = userInfoService.GetUserInfoByUserId(id);
////将修改的数据，发给业务逻辑层，保存到数据库中
//userInfo.UserName = context.Request.Form["txtName"];
//userInfo.UserAge = Convert.ToInt32(context.Request.Form["txtAge"]);
//userInfo.UserPwd = context.Request.Form["txtPwd"];
//拿到userInfo对象方式二：
UserInfoEntity userInfo = new UserInfoEntity()
{
UserId = id,
UserName = context.Request.Form["txtName"],
UserAge = Convert.ToInt32(context.Request.Form["txtAge"]),
UserPwd = context.Request.Form["txtPwd"]
};
if (userInfoService.EditUserInfo(userInfo))
{
context.Response.Redirect("UserInfoList.ashx");//如果成功的话，跳转到用户信息页面
}
else
{
context.Response.Redirect("Error.html");
}
}
/// <summary>
/// Validate User login details
/// </summary>
/// <param name="UserName"></param>
/// <param name="Password"></param>
/// <returns></returns>
public UserInfoEntity ValidateUser(string UserName, string Password)
{
UserInfoEntity _userInfo = new UserInfoEntity();
try
{
using (var dao = DbActivity.Open())
{
CSqlDbCommand cmd = new CSqlDbCommand(DataHelper.DBCommands.VALIDATE_USERINFO);
cmd.Parameters.AddWithValue("UserName", UserName);
cmd.Parameters.AddWithValue("Password", Password);
dao.ExecReader(cmd);
while (dao.DataReader.Read())
{
_userInfo = new UserInfoEntity();
_userInfo.UserId = dao.DataReader["UserId"].ToInt();
_userInfo.UserName = dao.DataReader["UserName"].ToStr();
_userInfo.Password = dao.DataReader["Password"].ToStr();
_userInfo.Role = dao.DataReader["Role"].ToStr();
_userInfo.UpdatedOn = dao.DataReader["UpdatedOn"].ToDateTime();
_userInfo.ExpiredDate = dao.DataReader["ExpiredDate"].ToDateTime();
}
}
}
catch (Exception ex)
{
LoggerMgr.Web.Error(LoggerMgr.GetErrorMessageRootText(DataHelper.Layer.DataAccessLayer, DataHelper.DataAccess.OrdersContext, MethodInfo.GetCurrentMethod().Name), ex);
throw;
}
return(_userInfo);
}
private UserInfo FromEntity(UserInfoEntity userEntity)
{
var userInfo = new UserInfo(userEntity.userId);
userInfo.joinedRooms.AddRange(userEntity.joinedRooms);
return(userInfo);
}
public bool UpdateUserInfo(UserInfoModel userInfoModel)
{
UserInfoEntity userInfo = _mapper.Map <UserInfoEntity>(userInfoModel);
var userCode = _currentUser.UserCode;
using (var redisManager = _redisManagerPool.GetClient())
{
redisManager.Db = (int)RedisDB.DB0;
var currentUser = redisManager.Get <CurrentUser>(userCode);
if (currentUser == null)
{
throw new CNException("用户数据不存在");
}
userInfo.Id = _currentUser.Id;
var current = _mapper.Map <CurrentUser>(userInfo);
//清除Token信息，回到登录界面
redisManager.Remove(userCode);
redisManager.Remove(currentUser.Token);
}
var transaction = _con.BeginTransaction();
try
{
//修改用户的关注基金
UpdateFollowFunds(userInfoModel.FollowFundModels, transaction);
_con.UpdateReord(userInfo, transaction);
transaction.Commit();
}catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
return(true);
}
/// <summary>
/// 获取专业主管
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
// private string GetRoleUserId(string userid)
// {
// string sql = @"select userid from base_user where instr(rolename,'负责人' )> 0 and departmentid =
// (select departmentid from base_user where userid = @userid) ";
// DataTable dt = this.BaseRepository().FindTable(sql, new DbParameter[] { DbParameters.CreateDbParameter("@userid", userid) });
// string approverPeopleIds = "";
// foreach (DataRow dr in dt.Rows)
// {
// approverPeopleIds += dr["userid"] + ",";
// }
// return !string.IsNullOrEmpty(approverPeopleIds) ? approverPeopleIds.Substring(0, approverPeopleIds.Length - 1) : "";
// }
/// <summary>
/// 获取主要责任部门与次要责任部门name
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
private string GetDeptNames(string userid1, string userid2, string userid3)
{
UserInfoService userservice = new UserInfoService();
UserInfoEntity user = new UserInfoEntity();
ArrayList ids = new ArrayList();
string deptNames = "";
if (!string.IsNullOrEmpty(userid1) && userid1 != "0")
{
ids.Add(userid1);
}
if (!string.IsNullOrEmpty(userid2) && userid2 != "0")
{
ids.Add(userid2);
}
if (!string.IsNullOrEmpty(userid3) && userid3 != "0")
{
ids.Add(userid3);
}
if (ids.Count > 0)
{
foreach (string id in ids)
{
user = userservice.GetUserInfoEntity(id);
if (user != null)
{
deptNames += user.DeptName + "、";
}
}
}
return(!string.IsNullOrEmpty(deptNames) ? deptNames.Substring(0, deptNames.Length - 1) : "");
}
UserInfoEntity user = null;//new LoginHandler().GetUser();
public void ProcessRequest(HttpContext context)
{
user = (UserInfoEntity)context.Session["getuser"];
string op = context.Request["op"];
switch (op)
{
case "select":
SelectLeaveinfo(context);
break;
case "selectbyid":
SelectLeavebyidinfo(context);
break;
case "addinfo":
AddLeaveInfo(context);
break;
case "deleteinfo":
Deleteinfo(context);
break;
case "selectbydept":
Selectbydept(context);
break;
case "updateleavestate":
Updateleavestate(context);
break;
default:
break;
}
}
public bool CheckUser(string UserIds, string checkUser)
{
try
{
SqlMapClientTemplate.mapper.BeginTransaction();
string[] ids = UserIds.Split(',');
for (int i = 0; i < ids.Length; i++)
{
if (ids[i] != "")
{
UserInfoEntity userInfo = QueryForObject <UserInfoEntity>("UserInfoMap.Load", ids[i]);
userInfo.Flag = 1;
userInfo.UpdateDate = DateTime.Now;
userInfo.UpdateUser = checkUser;
Update("UserInfoMap.CheckUser", userInfo);
}
}
SqlMapClientTemplate.mapper.CommitTransaction();
return(true);
}
catch (Exception ex)
{
SqlMapClientTemplate.mapper.RollBackTransaction();
return(false);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html";
context.Response.Write("Hello World");
string userName = context.Request.Form["txtName"];
string userAge = context.Request.Form["txtAge"];
string userPwd = context.Request.Form["txtPwd"];
UserInfoEntity userInfoEntity = new UserInfoEntity()
{
UserName = userName,
UserAge = int.Parse(userAge),
UserPwd = userPwd
};
UserInfoService userInfoService = new UserInfoService();
if (userInfoService.AddUserInfo(userInfoEntity))
{
context.Response.Redirect("UserInfoList.ashx");
}
else
{
context.Response.Redirect("Error.html");
}
}
private async Task UpdateUserInfoForProactiveMessages(ITurnContext turnContext, CancellationToken cancellationToken)
{
try
{
var carwashUserId = (await _userProfileAccessor.GetAsync(turnContext, () => new UserProfile())).CarwashUserId;
if (carwashUserId == null)
{
return;
}
var activity = turnContext.Activity;
var user = (activity.Recipient.Role == RoleTypes.User || activity.From.Role == RoleTypes.Bot) ? activity.Recipient : activity.From;
var bot = (activity.Recipient.Role == RoleTypes.User || activity.From.Role == RoleTypes.Bot) ? activity.From : activity.Recipient;
var userInfo = new UserInfoEntity(
carwashUserId,
activity.ChannelId,
activity.ServiceUrl,
user,
bot,
activity.ChannelData,
activity.GetConversationReference());
await _table.ExecuteAsync(TableOperation.InsertOrReplace(userInfo), null, null, cancellationToken);
}
catch (Exception e)
{
_telemetryClient.TrackException(e);
}
}
public async Task <bool> UpdateUserInfoAsync(UpdateUserInfoDto user)
{
Logger.LogInformation($"{nameof(AccountService)}.{nameof(UpdateUserInfoAsync)}.Start");
var oldUser = await Db.UsersInfo.FindUserInfo(user.UserId);
if (oldUser == null)
{
throw new NotFoundException("This user does not exist");
}
var updateUser = new UserInfoEntity
{
UserId = user.UserId,
FirstName = user.FristName.IsNullOrEmpty() ? oldUser.FirstName : user.FristName,
LastName = user.LastName.IsNullOrEmpty() ? oldUser.LastName : user.LastName,
BirthDate = user.BirthDate.Year < 1900 ? oldUser.BirthDate : user.BirthDate,
SexType = user.SexType == SexType.Both ? oldUser.SexType : user.SexType,
CityId = user.City.IsNullOrEmpty() ? oldUser.CityId : (await Db.Cities.GetOrCreateCity(user.City)).CityId,
OriginalAvatarUrl = oldUser.OriginalAvatarUrl,
Description = user.Description.IsNullOrEmpty() ? oldUser.Description : user.Description
};
var result = await Db.UsersInfo.UpdateUserInfoAsync(updateUser);
Logger.LogInformation($"{nameof(AccountService)}.{nameof(UpdateUserInfoAsync)}.End");
return(result);
}
/// <summary>
/// 添加新用户
/// </summary>
/// <param name="o">用户对象的实例</param>
/// <returns>bool</returns>
public static bool InsertInfo(UserInfoEntity o)
{
string sql = "INSERT INTO UserInfo (DepartmentID, RoleID, UserNumber, UserFace, LoginName, LoginPwd, UserName, UserAge, UserSex, UserTel, UserAddress, UserIphone, UserRemarks, UserStatr, EntryTime, DimissionTime, BasePay)VALUES " +
"(" + o.DepartmentID + ", " + o.RoleID + ", '" + o.UserNumber + "', '" + o.UserFace + "', '" + o.LoginName + "', '" + o.LoginPwd + "', '" + o.UserName + "'," + o.UserAge + ", " + o.UserSex + ",'" + o.UserTel + "', '" + o.UserAddress + "','" + o.UserIphone + "','" + o.UserRemarks + "', 0, getdate(), getdate(), " + o.BasePay + ")";
return(DBHelper.UpdateOpera(sql));
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html";
//context.Response.Write("Hello World");
int id;
if (int.TryParse(context.Request.QueryString["uid"], out id))
{
//根据id把详细信息查询出来
UserInfoEntity userInfo = userInfoService.GetUserInfoByUserId(id);
if (userInfo != null)
{
string filePath = context.Request.MapPath("Detail.html");
string fileContent = File.ReadAllText(filePath);
fileContent = fileContent.Replace("$name", userInfo.UserName)
.Replace("$age", userInfo.UserAge.ToString())
.Replace("$pwd", userInfo.UserPwd);
context.Response.Write(fileContent);
}
else
{
// 如果根据id找到不到userInfo的信息
context.Response.Redirect("Error.html");
}
}
else
{
context.Response.Write("参数错误！!!!");
}
}
private static List <UserInfoEntity> Commnuity(string sql, params SqlParameter[] parameter)
{
List <UserInfoEntity> list = new List <UserInfoEntity>();
SqlDataReader sdr = DBHelper.GetReader(sql, parameter);
while (sdr.Read())
{
UserInfoEntity obj = new UserInfoEntity()
{
UserID = Convert.ToInt32(sdr["UserID"]),
DepartmentID = Convert.ToInt32(sdr["DepartmentID"]),
RoleID = Convert.ToInt32(sdr["RoleID"]),
UserNumber = sdr["UserNumber"].ToString(),
UserFace = sdr["UserFace"].ToString(),
LoginName = sdr["LoginName"].ToString(),
LoginPwd = sdr["LoginPwd"].ToString(),
UserName = sdr["UserName"].ToString(),
UserAge = Convert.ToInt32(sdr["UserAge"]),
UserSex = Convert.ToInt32(sdr["UserSex"]),
UserTel = Convert.ToString(sdr["UserTel"]),
UserAddress = Convert.ToString(sdr["UserAddress"]),
UserIphone = Convert.ToString(sdr["UserIphone"]),
UserRemarks = Convert.ToString(sdr["UserRemarks"]),
UserStatr = Convert.ToInt32(sdr["UserStatr"]),
EntryTime = Convert.ToDateTime(sdr["EntryTime"]),
DimissionTime = Convert.ToDateTime(sdr["DimissionTime"]),
BasePay = Convert.ToDouble(sdr["BasePay"]),
DepartmentName = sdr["DepartmentName"].ToString(),
RoleName = sdr["RoleName"].ToString()
};
list.Add(obj);
}
return(list);
}
public static List <ApplyDetailItem> GetCheckDetails(MomentEntity moment, UserInfoEntity momentUserInfo, RequestHead head)
{
var resultList = new List <ApplyDetailItem>()
{
new ApplyDetailItem()
{
UserInfo = UserInfoBuilder.BuildUserInfo(momentUserInfo, head),
Content = "首次提交审核",
CreateTimeDesc = DateTimeHelper.GetDateDesc(moment.CreateTime, true),
}
};
var applyDetaiList = applyDetailDao.GetListByMomentId(moment.MomentId);
if (applyDetaiList.NotEmpty())
{
var resultDic = GetUserInfo(applyDetaiList, head);
foreach (var item in applyDetaiList)
{
resultList.Add(new ApplyDetailItem()
{
CreateTimeDesc = DateTimeHelper.GetDateDesc(item.CreateTime, true),
Content = item.Content,
UserInfo = resultDic[item.UId]
});
}
}
return(resultList);
}
public ActionResult Login(string username, string password)
{
UserInfoEntity loginUserInfo = new UserInfoEntity {
UserName = username, PassWord = password
};
if (!ModelState.IsValid)
{
return(View(loginUserInfo));
}
var userInfo = UserLogin(loginUserInfo.UserName, loginUserInfo.PassWord);
if (userInfo != null)
{
//写入cookie
string key = CommonHelper.Md5(CommonHelper.COOKIE_KEY_USERINFO);
string data = JsonHelper.Serializer <UserInfoEntity>(userInfo);
CookieHelper.SetCookie(key, CommonHelper.DesEncrypt(data, CommonHelper.COOKIE_KEY_ENCRYPT));
Session[CommonHelper.SessionUserKey] = userInfo;
return(Request["ReturnUrl"] == null?Redirect("~") : Redirect(Request["ReturnUrl"]));
}
return(View(userInfo));
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
int id = Convert.ToInt32(ViewState["id"].ToString());
UserInfoEntity userinfoentity = new UserInfoEntity();
userinfoentity.UserId = id;
userinfoentity.LoginID = "0";
userinfoentity.Password = encryptdecrypt.Encrypt(txtPassword.Text);
userinfoentity.Email = txtEmail.Text;
userinfoentity.FirstName = txtFirstName.Text;
userinfoentity.LastName = txtLastName.Text;
userinfoentity.Location = txtLocation.Text;
userinfoentity.MobileNumber = txtMobileNumber.Text;
userinfoentity.PhoneNumber = txtPhoneNumber.Text;
userinfoentity.Status = Convert.ToInt32(ddlStatus.SelectedValue);
userinfoentity.UserType = Convert.ToInt32(ddlUserType.SelectedValue);
int result = userbl.CUDUserInfo(userinfoentity, 'u');
if (result == 1)
{
lblMessage.Text = "Details Updated Successfully!";
Clear();
Response.Redirect("UserList.aspx");
}
else
{
lblMessage.Text = "Please try again!";
}
}
catch
{
}
}
public string UsersSaveChanges(string jsonString, string action)
{
try
{
UserInfoEntity ue = JsonConvert.DeserializeObject <UserInfoEntity>(jsonString);
UserInfoManager pm = new UserInfoManager();
if (action == "add")
{
pm.Insert(ue);
}
else
{
UserInfoEntity ueOld = pm.GetUserByCode(ue.Code);
ueOld.Name = ue.Name;
ueOld.Type = ue.Type;
ueOld.Company = ue.Company;
ueOld.UpdateBy = SessionHelper.CurrentUser.Code;
pm.Update(ueOld);
}
return("success");
}
catch (Exception e)
{
return(e.ToString());
}
}
//public bool ValidUser(string username, string password)
//{
// bool result = false;
// SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DHRM_COREEntities"].ConnectionString);
// con.Open();
// SqlCommand cmd = new SqlCommand();
// cmd.CommandText = "select case when exists (select * from Membership where MEM_UserName = '******' and MEM_Password = '******') then 1 else 0 end";
// cmd.CommandType = System.Data.CommandType.Text;
// cmd.Connection = con;
// SqlDataReader reader = cmd.ExecuteReader();
// while (reader.Read())
// {
// }
// return result;
//}
public UserInfoEntity GetUserInfo(string username, string password)
{
UserInfoEntity entity = new UserInfoEntity();
SqlCommand cmd = null;
try
{
con.Open();
cmd = new SqlCommand("USP_GETUSERINFO", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 60 * 60 * 10;
cmd.Parameters.AddWithValue("@Username", username);
cmd.Parameters.AddWithValue("@Password", password);
cmd.Connection = con;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
entity.MEM_UserName = reader["MEM_UserName"].ToString();
entity.MEM_Password = reader["MEM_Password"].ToString();
entity.MEM_Email = reader["MEM_Email"].ToString();
entity.RoleName = reader["RoleName"].ToString();
entity.MEM_IsActive = reader["MEM_IsActive"].ToBoolean();
}
con.Close();
cmd.Dispose();
}
catch (Exception ex)
{
con.Close();
cmd.Dispose();
throw;
}
return(entity);
}
public async Task SaveUserImage(IFormFile file, string userName)
{
ApplicationUser user = await _userManager.GetUserAsync(userName);
UserInfoEntity userInfo = await _DBContext.UsersInfo.Include(ui => ui.User).FirstOrDefaultAsync(ui => ui.User == user);
using (MemoryStream ms = new MemoryStream())
{
await file.CopyToAsync(ms);
byte[] buffer = ms.ToArray();
using (MagickImage image = new MagickImage(buffer))
{
MagickGeometry size = new MagickGeometry(100);
image.Resize(size);
image.Strip();
image.Quality = 100;
buffer = image.ToByteArray();
}
userInfo.Photo = buffer;
}
_DBContext.UsersInfo.Update(userInfo);
await _DBContext.SaveChangesAsync();
}
public ActionResult CreateUser(UserInfoEntity userInfoEntity)
{
var result = false;
if (userInfoEntity != null)
{
if (userInfoEntity.UserId == 0)
{
userInfoEntity.PassWord = CommonHelper.Md5(userInfoEntity.PassWord);
userInfoEntity.CreateDate = DateTime.Now;
userInfoEntity.UserState = 1;
result = userInfoRepository.AddReturnInt(userInfoEntity) > 0;
}
else
{
var uerModel = userInfoRepository.GetSingle(userInfoEntity.UserId);
uerModel.UserName = userInfoEntity.UserName;
uerModel.UserSex = userInfoEntity.UserSex;
uerModel.UserPhone = userInfoEntity.UserPhone;
uerModel.UserMail = userInfoEntity.UserMail;
uerModel.UserAddress = userInfoEntity.UserAddress;
//uerModel.PassWord = CommonHelper.Md5(userInfoEntity.PassWord);
result = userInfoRepository.Update(uerModel);
}
}
ReturnJsonMessage msg = new ReturnJsonMessage();
msg.Text = result ? "保存成功" : "保存失败";
msg.Value = result ? "success" : "error";
return(Json(msg));
}
protected void Page_Load(object sender, EventArgs e)
{
lblStatusSubmissionFailed.Visible = false;
lblStatusSubmitted.Visible = false;
lblZurichAdvFailed.Visible = false;
lblZurichAdvSuccess.Visible = false;
activity = activityStatusDao.getActivity(13);
ViewState["activity"] = activity;
ZPlanResponseDataContract zPlanResponse = null;
string clonedFrom = "";
if (!IsPostBack)
{
/*string nextCaseId = Request.Form["caseid"];
string menuCaseId = Request.QueryString["caseid"];
if (nextCaseId != null && nextCaseId != "")
{
caseid = nextCaseId;
}
if (menuCaseId != null && menuCaseId != "")
{
caseid = menuCaseId;
}*/
string activityID = string.Empty;
string country = string.Empty;
if (Request.Form["Country"] != null)
{
country = Request.Form["Country"].ToString();
}
string salesChannel = string.Empty;
if (Request.Form["SalesChannel"] != null)
{
salesChannel = Request.Form["SalesChannel"].ToString();
}
if (Request.Form["ActivityID"] != null)
{
activityID = Request.Form["ActivityID"].ToString();
//activityID = "1500";
ZPlanDataContract zPlanContract = new ZPlanDataContract();
zPlanContract.ActivityId = activityID;
zPlanContract.Activity = ActivityTypeEnum.ZPlan;
zPlanContract.Action = ActionEnumContracts.View;
UserInfoEntity ufo = new UserInfoEntity();
ufo.Country = country;
ufo.RoleType = salesChannel;
zPlanContract.UserInfo = ufo;
zPlanResponse = new ZPlanResponseDataContract();
try
{
BusinessServiceClient client = new BusinessServiceClient();
client.ClientCredentials.Windows.AllowedImpersonationLevel =
System.Security.Principal.TokenImpersonationLevel.Impersonation;
zPlanResponse = client.ManageZPlan(zPlanContract);
if (zPlanResponse != null)
{
salesportalinfo salesPortalDto = new salesportalinfo();
salesPortalDto.activityid = activityID;
salesPortalDto.activitytype = zPlanResponse.ActivityType;
salesPortalDto.caseid = zPlanResponse.CaseId;
salesPortalDto.redirecturl = zPlanResponse.RedirectUrl;
salesPortalDto.roletype = zPlanResponse.RoleType;
salesPortalDto.salesportalurl = zPlanResponse.SalesPortalUrl;
salesPortalDto.userfirstname = zPlanResponse.UserFirstName;
salesPortalDto.userid = zPlanResponse.UserId;
salesPortalDto.userlastname = zPlanResponse.UserLastName;
salesPortalDto.usertype = zPlanResponse.UserType;
salesPortalDto.casestatus = zPlanResponse.CaseStatus;
salesPortalDto.country = country;
salesPortalDto.saleschannel = salesChannel;
activityStatusDao.saveSalesPortalInfo(activityID, salesPortalDto);
caseid = zPlanResponse.ActivityId;
//check if ClonedFrom is sent from portal
if (zPlanResponse.ClonedFrom != null && zPlanResponse.ClonedFrom != "")
{
clonedFrom = zPlanResponse.ClonedFrom;
//check if case has been cloned earlier
clonemappingid clonemapping = activityStatusDao.getCloneMappingForCaseid(clonedFrom, zPlanResponse.ActivityId);
if (clonemapping == null)
{
//if the case is not cloned, add entry in the clone mapping table and clone the case
clonemapping = new clonemappingid();
clonemapping.clonedfrom = clonedFrom;
clonemapping.newid = zPlanResponse.ActivityId;
activityStatusDao.saveClonemapping(clonemapping);
activityStatusDao.cloneCase(clonedFrom, zPlanResponse.ActivityId);
}
}
}
}
catch (Exception ex)
{
//log exception to db
exceptionlog exLog = new exceptionlog();
exLog.message = ex.Message + " class: MyZurichAdviser Method: Page_Load";
exLog.source = ex.Source;
string strtmp = ex.StackTrace;
strtmp = strtmp.Replace('\r', ' ');
strtmp = strtmp.Replace('\n', ' ');
exLog.stacktrace = strtmp;
exLog.targetsitename = ex.TargetSite.Name;
activityStatusDao.logException(exLog);
}
}
else
{
string backCaseId = Request.Form["caseid"];
string menuCaseId = Request.QueryString["caseid"];
if (backCaseId != null && backCaseId != "")
{
caseid = backCaseId;
}
else if (menuCaseId != null && menuCaseId != "")
{
caseid = menuCaseId;
}
else if (Session["fnacaseid"] != null)
{
caseid = Session["fnacaseid"].ToString();
}
else
{
caseid = "2040";
}
}
activityId.Value = caseid;
PersonalDetailsDAO dao = new PersonalDetailsDAO();
personaldetail detail = dao.getPersonalDetail(caseid);
if (detail != null)
{
if (zPlanResponse != null)
{
detail.datepicker = zPlanResponse.Dob;
detail.gender = zPlanResponse.Gender;
//detail.maritalstatus = zPlanResponse.MaritalStatus;
detail.name = zPlanResponse.UserFirstName;
detail.surname = zPlanResponse.UserLastName;
detail.nationality = zPlanResponse.Nationality;
detail.nric = zPlanResponse.NricOrPassport;
detail.occupation = zPlanResponse.Occupation;
if (zPlanResponse.Smoker)
{
detail.issmoker = "Yes";
}
else
{
detail.issmoker = "No";
}
detail.title = zPlanResponse.Title;
}
dao.updatePersonalDetails(detail);
}
else
{
detail = new personaldetail();
detail.caseid = caseid;
if (zPlanResponse != null)
{
detail.datepicker = zPlanResponse.Dob;
detail.gender = zPlanResponse.Gender;
//detail.maritalstatus = zPlanResponse.MaritalStatus;
detail.name = zPlanResponse.UserFirstName;
detail.surname = zPlanResponse.UserLastName;
detail.nationality = zPlanResponse.Nationality;
detail.nric = zPlanResponse.NricOrPassport;
detail.occupation = zPlanResponse.Occupation;
if (zPlanResponse.Smoker)
{
detail.issmoker = "Yes";
}
else
{
detail.issmoker = "No";
}
detail.title = zPlanResponse.Title;
}
dao.savePersonalDetails(detail);
}
if (caseid != "")
{
ViewState["caseid"] = caseid;
List<myzurichadviser> savedMzaoptions = mzaDao.getMza(caseid);
if (savedMzaoptions != null && savedMzaoptions.Count>0)
{
ViewState["casetype"] = "update";
}
else
{
ViewState["casetype"] = "new";
savedMzaoptions = new List<myzurichadviser>();
myzurichadviser mzadv = new myzurichadviser();
mzadv.caseid = caseid;
mzadv.selectedoptionid = 1;
savedMzaoptions.Add(mzadv);
mzadv = new myzurichadviser();
mzadv.caseid = caseid;
mzadv.selectedoptionid = 2;
savedMzaoptions.Add(mzadv);
}
populateMzaoptions(savedMzaoptions, caseid);
}
}
markStatusOnTab(caseid);
}
