public ActionResult Edit(M_USER m_USER) { if (Session["Admin"] != null) { var sess = Session["Admin"].ToString(); if (m_USER.USER_ID != null) { m_USER.USER_ID = m_USER.USER_ID.Trim(); var userId = db.M_USER.Where(x => x.USER_ID == m_USER.USER_ID).FirstOrDefault(); if (userId != null) { m_USER.PASSWORD = m_USER.PASSWORD.Trim(); m_USER.LOGIN = m_USER.LOGIN.Trim(); m_USER.LOGIN_DOMAIN = m_USER.LOGIN_DOMAIN.Trim(); userId.LOGIN = m_USER.LOGIN; userId.LOGIN_DOMAIN = m_USER.LOGIN_DOMAIN; userId.PASSWORD = m_USER.PASSWORD; userId.LAST_UPD_DT = System.DateTime.Now; userId.LAST_UPD_BY = sess; db.SaveChanges(); } } return(RedirectToAction("Index")); } return(RedirectToAction("Login2", "Home")); }
/// <summary> /// Get user info/ company info. /// </summary> /// <param name="userId">User Id.</param> /// <returns>user info/ company info.</returns> public static UserEntity GetUserInfo(AloaiDataContext db, decimal?userId) { UserEntity userInfo = new UserEntity(); if (!userId.HasValue) { return(userInfo); } var user = from d in db.M_USERS where d.USER_ID == userId.Value select d; if (!user.Any()) { return(userInfo); } M_USER mUser = user.Single(); userInfo.name = mUser.NAME; ImageInfoEntity avatar = new ImageInfoEntity(); avatar.path = mUser.AVATAR; userInfo.avatar = avatar; return(userInfo); }
public bool UpdateModeUser(decimal id, decimal Mode) { IDbContextTransaction tran = _context.Database.BeginTransaction(); try { var query = from d in _context.M_USERS where d.USER_ID == id select d; if (query.Any()) { M_USER user = query.Single(); user.MODE_DEFAULT = Mode; _context.SaveChanges(); } // Commit transaction. tran.Commit(); return(true); } catch { // Rollback transaction. tran.Rollback(); return(false); } }
public bool DeleteUser(decimal id) { IDbContextTransaction tran = _context.Database.BeginTransaction(); try { var query = from d in _context.M_USERS where d.USER_ID == id select d; if (query.Any()) { M_USER user = query.Single(); _context.M_USERS.Add(user); _context.SaveChanges(); } // Remove image. if (!Utility.RemoveImage(_context, id, ImageType.Profile)) { return(false); } // Commit transaction. tran.Commit(); return(true); } catch { // Rollback transaction. tran.Rollback(); return(false); } }
/// <summary> /// Update user/ company infomation. /// </summary> /// <param name="db">DataContext.</param> /// <param name="userEntity">User entity</param> /// <returns>Ok: true, Fail: false</returns> public static bool UpdateUser(AloaiDataContext db, UserEntity userEntity) { var query = from d in db.M_USERS where d.USER_ID == userEntity.userId select d; M_USER user = query.Single(); user.PHONE_NUMBER = userEntity.phoneNumber; user.NAME = userEntity.name; if (userEntity.avatar != null) { string avartaPath = string.Empty; if (Utility.UploadAvatar(db, userEntity.userId, userEntity.avatar, userEntity.avatar.path, out avartaPath)) { user.AVATAR = avartaPath; } } user.MODE_DEFAULT = userEntity.modeDefault; user.UPD_DATETIME = Utility.GetSysDateTime(); List <T_PARTNER_CATALOG_UNIT> workerList = new List <T_PARTNER_CATALOG_UNIT>(); db.SaveChanges(); return(true); }
public ActionResult Login2([Bind(Include = "LOGIN,PASSWORD")] M_USER model) { //model.USER_FLG = false; var res = db.M_USER.Where(x => x.LOGIN == model.LOGIN).FirstOrDefault(); if (res != null) { var pass = res.PASSWORD == model.PASSWORD; if (pass == true) { if (res.LOGIN_DOMAIN == "Customer") { Session["CustId"] = res.USER_ID; Session["Admin"] = null; //int value = Convert.ToInt32(res.CustomerId); return(RedirectToAction("Index", "Survey")); } else if (res.LOGIN_DOMAIN == "Admin") { Session["Admin"] = res.USER_ID; Session["CustId"] = null; return(RedirectToAction("AdminActivities", "Admin")); } else if (res.LOGIN_DOMAIN == "Sales") { return(RedirectToAction("Index", "Sales")); } } } ViewBag.Error = "Username and Password do not Match"; return(View("Login2")); }
public ActionResult GetSystemMessage([FromRoute] decimal id) { var query = from d in _context.D_NOTIFYS where d.NOTIFY_ID == id select d; if (!query.Any()) { return(Ok(new Result { Status = 200, Message = string.Empty, Data = string.Empty })); } D_NOTIFY notify = query.Single(); NotifyEntity entity = new NotifyEntity(); entity.notifyId = notify.NOTIFY_ID; entity.notifyType = notify.NOTIFY_TYPE; entity.objectId = notify.OBJECT_ID; entity.notifyDate = notify.NOTIFY_DATE; entity.userSendId = notify.USER_SEND_ID; entity.userReceiveId = notify.USER_RECIEVE_ID; entity.receiveModeUser = notify.RECEIVE_MODE_USER; entity.content = notify.CONTENT; if (entity.notifyType == (int)NotifyType.System) { var user = from d in _context.M_USERS where d.USER_ID == notify.USER_RECIEVE_ID select d; M_USER userM = user.Single(); var message = from d in _context.M_SYSTEM_MESSAGES where d.MESSAGE_CD == entity.objectId && d.LANGUAGE_TYPE == userM.LANGUAGE_TYPE select d; if (message.Any()) { entity.content = message.SingleOrDefault().MESSAGE_CONTENT; } } return(Ok(new Result { Status = 200, Message = string.Empty, Data = entity.content })); }
public ActionResult CheckCanLogin(string id) { try { System.Web.Http.HttpError errorHttp = new System.Web.Http.HttpError("User can login!"); var query = from d in _context.M_USERS where d.PHONE_NUMBER == id && d.DELETE_FLG == 0 select d; if (query.Any()) { M_USER user = query.Single(); // User is blocked. if (user.BLOCK_FLG == 1 && user.BLOCK_FLG == (int)BlockFlag.Blocked) { errorHttp = new System.Web.Http.HttpError("User is blocked!"); return(Ok(new Result { Status = 404, Message = errorHttp.Message, Data = null })); } // User is deleted. //if (user.DELETE_FLG.HasValue && user.DELETE_FLG.Value != (int)DeleteFlag.Using) //{ // errorHttp = new HttpError("User is deleted!"); // return Request.CreateResponse(HttpStatusCode.Conflict, errorHttp); //} } return(Ok(new Result { Status = 200, Message = errorHttp.Message, Data = true })); } catch { // Rollback transaction. System.Web.Http.HttpError error = new System.Web.Http.HttpError("Error system!"); return(Ok(new Result { Status = 200, Message = error.Message, Data = null })); } }
public ActionResult DeleteConfirmed(M_USER id) { if (Session["Admin"] != null) { if (id.USER_ID != null) { id.USER_ID = id.USER_ID.Trim(); M_USER m_USER = db.M_USER.Find(id.USER_ID); m_USER.USER_FLG = "0"; db.SaveChanges(); } return(RedirectToAction("Index")); } return(RedirectToAction("Login2", "Home")); }
public ActionResult GetUserByPhone(string id) { if (!Utility.CheckPhoneExists(_context, id)) { return(Ok(new Result { Status = 404, Message = "Data not exists", Data = null })); } // M_USER user = db.M_USER.FirstOrDefault(x => x.PHONE_NUMBER == id && ); var query = from d in _context.M_USERS where d.PHONE_NUMBER == id && d.DELETE_FLG == 0 select d; M_USER user = query.Single(); UserEntity entity = new UserEntity(); entity.userId = user.USER_ID; entity.phoneNumber = user.PHONE_NUMBER; entity.modeDefault = user.MODE_DEFAULT; entity.modeUser = user.MODE_USER; entity.name = user.NAME; ImageInfoEntity avatar = new ImageInfoEntity(); avatar.path = user.AVATAR; entity.avatar = avatar; M_HIRER_INFO hirer = _context.M_HIRER_INFOS.FirstOrDefault(x => x.USER_ID == entity.userId); entity.userId = hirer.USER_ID; entity.score = hirer.SCORE; entity.likeNum = hirer.LIKE_NUM; return(Ok(new Result { Status = 200, Message = string.Empty, Data = entity })); }
/// <summary> /// Update token /// </summary> /// <param name="userId">user Id</param> /// <param name="token">Token string</param> /// <returns>Ok: true, Fail: false</returns> public bool UpdateToken(AloaiDataContext context, decimal userId, string token) { var query = from d in context.M_USERS where d.USER_ID == userId select d; if (query.Any()) { M_USER user = query.Single(); user.TOKEN = token; user.UPD_DATETIME = Utility.GetSysDateTime(); context.SaveChanges(); return(true); } return(false); }
public ActionResult GetUser(decimal id, string language) { if (!Utility.CheckUserExists(_context, id)) { return(Ok(new Result { Status = 404, Message = "Data not exists", Data = null })); } if (string.IsNullOrEmpty(language)) { language = Constant.LANGUAGE_VN; } M_USER user = _context.M_USERS.FirstOrDefault(x => x.USER_ID == id); UserEntity entity = new UserEntity(); entity.userId = user.USER_ID; entity.phoneNumber = user.PHONE_NUMBER; entity.modeDefault = user.MODE_DEFAULT; entity.modeUser = user.MODE_USER; entity.name = user.NAME; ImageInfoEntity avatar = new ImageInfoEntity(); avatar.path = user.AVATAR; entity.avatar = avatar; M_HIRER_INFO hirer = _context.M_HIRER_INFOS.FirstOrDefault(x => x.USER_ID == id); entity.userId = hirer.USER_ID; entity.score = hirer.SCORE; entity.likeNum = hirer.LIKE_NUM; return(Ok(new Result { Status = 200, Message = string.Empty, Data = entity })); }
public ActionResult GetAvatarByUserId(decimal id) { if (!Utility.CheckUserExists(_context, id)) { return(Ok(new Result { Status = 404, Message = "Data not exists", Data = null })); } M_USER user = _context.M_USERS.FirstOrDefault(x => x.USER_ID == id); return(Ok(new Result { Status = 200, Message = string.Empty, Data = user.AVATAR })); }
public bool UpdateAvatar(UserEntity userEntity) { IDbContextTransaction tran = _context.Database.BeginTransaction(); try { var query = from d in _context.M_USERS where d.PHONE_NUMBER == userEntity.phoneNumber && d.DELETE_FLG == 0 select d; if (!query.Any()) { return(false); } M_USER user = query.Single(); if (userEntity.avatar != null && !string.IsNullOrEmpty(userEntity.avatar.path)) { string avartaPath; if (Utility.UploadAvatar(_context, userEntity.userId, userEntity.avatar, userEntity.avatar.path, out avartaPath)) { user.AVATAR = avartaPath; } } // Commit transaction. tran.Commit(); return(true); } catch { // Rollback transaction. tran.Rollback(); return(false); } }
public ActionResult UpdateHirerInfo(HirerInfoEntity hirer) { var query = from d in _context.M_USERS where d.USER_ID == hirer.userId select d; if (query.Any()) { M_USER upd = query.Single(); upd.NAME = hirer.name; string avartaPath; if (Utility.UploadAvatar(_context, hirer.userId, hirer.avatar, hirer.avatar.path, out avartaPath)) { upd.AVATAR = avartaPath; } upd.UPD_DATETIME = Utility.GetSysDateTime(); _context.SaveChanges(); HirerInfoEntity hirerInfo = Utility.GetHirerInfo(_context, hirer.userId); return(Ok(new Result { Status = 200, Message = string.Empty, Data = hirerInfo })); } return(Ok(new Result { Status = 404, Message = string.Empty, Data = null })); }
/// <summary> /// Get hirer/ company info. /// </summary> /// <param name="hirerId">Hirer Id.</param> /// <returns>Hirer Info Entity</returns> public static HirerInfoEntity GetHirerInfo(AloaiDataContext db, decimal hirerId) { HirerInfoEntity hirerEntity = new HirerInfoEntity(); // User info. var user = from d in db.M_USERS where d.USER_ID == hirerId select d; if (user.Any()) { M_USER userEntity = user.Single(); // Hirer info. var hirerInfo = from d in db.M_HIRER_INFOS where d.USER_ID == hirerId select d; if (hirerInfo.Any()) { M_HIRER_INFO info = hirerInfo.Single(); hirerEntity.userId = info.USER_ID; hirerEntity.score = info.SCORE.Value; hirerEntity.likeNum = info.LIKE_NUM; hirerEntity.status = info.STATUS; ImageInfoEntity avatar = new ImageInfoEntity(); avatar.path = userEntity.AVATAR; hirerEntity.avatar = avatar; hirerEntity.name = userEntity.NAME; hirerEntity.phoneNumber = userEntity.PHONE_NUMBER; hirerEntity.token = userEntity.TOKEN; } } return(hirerEntity); }
public ActionResult GetUser(decimal id) { if (!Utility.CheckUserExists(_context, id)) { return(Ok(new Result { Status = 404, Message = "Data not exists", Data = null })); } M_USER user = _context.M_USERS.FirstOrDefault(x => x.USER_ID == id); UserEntity entity = new UserEntity(); entity.userId = user.USER_ID; entity.phoneNumber = user.PHONE_NUMBER; entity.modeUser = user.MODE_USER; UserEntity uEntity = Utility.GetUserInfo(_context, user.USER_ID); entity.name = uEntity.name; entity.avatar = uEntity.avatar; M_HIRER_INFO hirer = _context.M_HIRER_INFOS.FirstOrDefault(x => x.USER_ID == id); entity.userId = hirer.USER_ID; entity.score = hirer.SCORE; entity.likeNum = hirer.LIKE_NUM; return(Ok(new Result { Status = 200, Message = string.Empty, Data = entity })); }
/// <summary> /// JSONにフォーマットされたトークンを返す /// </summary> /// <param name="user"></param> /// <param name="expires"></param> /// <returns>JSON型のトークン</returns> public static string GenerateToken(M_USER user, DateTime expires) { var handler = new JwtSecurityTokenHandler(); // ClaimsIdentityは識別情報を格納 ClaimsIdentity identity = new ClaimsIdentity( new[] { new Claim("UserID", user.USER_ID.ToString()), new Claim("UserPhone", user.PHONE_NUMBER), new Claim("UserName", user.NAME), } ); var securityToken = handler.CreateToken(new SecurityTokenDescriptor { Issuer = TokenAuthOption.Issuer, Audience = TokenAuthOption.Audience, SigningCredentials = TokenAuthOption.SigningCredentials, Subject = identity, Expires = expires }); return(handler.WriteToken(securityToken)); }
public ActionResult GetEstimationByPartner([FromRoute] decimal id) { DefineEntity define = Utility.GetDefineValue(Constant.COMMENT_NUMBER_MAX); List <ReviewEntity> entityList = new List <ReviewEntity>(); M_USER user = _context.M_USERS.FirstOrDefault(x => x.USER_ID == id); List <D_REVIEW> estimationList = new List <D_REVIEW>(); var query = from d in _context.D_REVIEWS join c in _context.V_CONTACT_INFOS on d.CONTACT_ID equals c.CONTACT_ID where c.WORKER_ID == id && d.REVIEW_MODE_USER == (int)Mode.Hirer orderby d.REVIEW_DATE descending select d; if (!query.Any()) { return(Ok(new Result { Status = 200, Message = string.Empty, Data = null })); } estimationList = query.ToList(); foreach (D_REVIEW estimation in estimationList) { ReviewEntity entity = new ReviewEntity(); entity.reviewId = estimation.REVIEW_ID; entity.contactId = estimation.CONTACT_ID; entity.reviewUserId = estimation.REVIEW_USER_ID; entity.reviewModeUser = estimation.REVIEW_MODE_USER; entity.reviewDate = estimation.REVIEW_DATE; entity.score = estimation.SCORE; entity.comment = estimation.COMMENT; var queryName = from d in _context.M_USERS where d.USER_ID == estimation.REVIEW_USER_ID select d.NAME; if (queryName.Any()) { entity.reviewUserName = queryName.Single(); } entityList.Add(entity); if (entityList.Count == int.Parse(define.value)) { break; } } return(Ok(new Result { Status = 200, Message = string.Empty, Data = entityList })); }
public ActionResult SignIn([FromBody] LoginEntity loginEntity) { IDbContextTransaction tran = _context.Database.BeginTransaction(); M_USER user = null; AuthorEntity author = new AuthorEntity(); author.phoneNumber = loginEntity.phoneNumber; author.token = loginEntity.token; if (!Utility.ValidatiTokenId(author)) { System.Web.Http.HttpError error = new System.Web.Http.HttpError("Error validati token id!"); return(Ok(new Result { Status = 404, Message = error.Message, Data = null })); } try { if (Utility.CheckPhoneExists(_context, loginEntity.phoneNumber)) { var query = from d in _context.M_USERS where d.PHONE_NUMBER == loginEntity.phoneNumber && d.DELETE_FLG == 0 select d; user = query.Single(); if (!string.IsNullOrEmpty(loginEntity.languageType)) { user.LANGUAGE_TYPE = loginEntity.languageType; } else { user.LANGUAGE_TYPE = Constant.LANGUAGE_VN; } user.SIGNIN_LAST = Utility.GetSysDateTime(); } else { user = new M_USER(); user.NAME = string.Empty; user.PHONE_NUMBER = loginEntity.phoneNumber; user.MODE_DEFAULT = (int)Mode.Partner; user.REG_DATETIME = Utility.GetSysDateTime(); user.MODE_USER = (int)Mode.Partner; user.SIGNIN_LAST = Utility.GetSysDateTime(); user.BLOCK_FLG = (int)BlockFlag.NotBlock; user.DELETE_FLG = (int)DeleteFlag.Using; if (!string.IsNullOrEmpty(loginEntity.languageType)) { user.LANGUAGE_TYPE = loginEntity.languageType; } else { user.LANGUAGE_TYPE = Constant.LANGUAGE_VN; } _context.M_USERS.Add(user); _context.SaveChanges(); var query = from d in _context.M_USERS where d.PHONE_NUMBER == loginEntity.phoneNumber && d.DELETE_FLG == 0 select d; M_PARTNER_INFO worker = new M_PARTNER_INFO(); worker.USER_ID = user.USER_ID; worker.SCORE = 0; worker.STATUS = (int)Status.Offline; worker.REG_DATETIME = Utility.GetSysDateTime(); _context.M_PARTNER_INFOS.Add(worker); _context.SaveChanges(); M_HIRER_INFO hirer = new M_HIRER_INFO(); hirer.USER_ID = user.USER_ID; hirer.SCORE = 0; hirer.STATUS = (int)Status.Offline; hirer.REG_DATETIME = Utility.GetSysDateTime(); _context.M_HIRER_INFOS.Add(hirer); _context.SaveChanges(); } _context.SaveChanges(); // Commit transaction. tran.Commit(); var queryUser = from d in _context.M_USERS where d.PHONE_NUMBER == loginEntity.phoneNumber && d.DELETE_FLG == 0 select d; user = queryUser.Single(); string token = Utility.GenerateToken(user, Utility.GetSysDateTime()); AuthRepository auth = new AuthRepository(); auth.UpdateToken(_context, user.USER_ID, token); if (loginEntity.modeUser == (int)Mode.Partner) { PartnerEntity partnerEntity = Utility.GetPartnerInfo(_context, user.USER_ID); partnerEntity.token = token; return(Ok(new Result { Status = 200, Message = string.Empty, Data = partnerEntity })); } else { UserEntity entity = new UserEntity(); entity.userId = user.USER_ID; entity.phoneNumber = user.PHONE_NUMBER; entity.modeDefault = user.MODE_DEFAULT; entity.modeUser = user.MODE_USER; entity.name = user.NAME; ImageInfoEntity avatar = new ImageInfoEntity(); avatar.path = user.AVATAR; entity.avatar = avatar; entity.token = token; M_HIRER_INFO hirer = _context.M_HIRER_INFOS.FirstOrDefault(x => x.USER_ID == entity.userId); entity.userId = hirer.USER_ID; entity.score = hirer.SCORE; entity.likeNum = hirer.LIKE_NUM; return(Ok(new Result { Status = 200, Message = string.Empty, Data = entity })); } } catch (Exception ex) { // Rollback transaction. tran.Rollback(); return(Ok(new Result { Status = 400, Message = ex.Data.ToString(), Data = null })); } }
public ActionResult UpdateUserInfo([FromBody] UserEntity userEntity) { IDbContextTransaction tran = _context.Database.BeginTransaction(); try { var query = from d in _context.M_USERS where d.USER_ID == userEntity.userId && d.DELETE_FLG == 0 && d.BLOCK_FLG == 0 select d; if (query.Any()) { M_USER user = query.Single(); user.NAME = userEntity.name; _context.SaveChanges(); var query1 = from d in _context.M_PARTNER_INFOS where d.USER_ID == userEntity.userId select d; if (userEntity.modeUser == (int)Mode.Partner) { M_PARTNER_INFO worker = query1.Single(); worker.USER_ID = query.FirstOrDefault().USER_ID; worker.SCORE = 0; worker.STATUS = (int)Status.Offline; worker.REG_DATETIME = Utility.GetSysDateTime(); _context.SaveChanges(); } else { var query2 = from d in _context.M_HIRER_INFOS where d.USER_ID == userEntity.userId select d; M_HIRER_INFO hirer = query2.Single(); hirer.USER_ID = query.FirstOrDefault().USER_ID; hirer.SCORE = 0; hirer.STATUS = (int)Status.Offline; hirer.REG_DATETIME = Utility.GetSysDateTime(); _context.SaveChanges(); } var queryUser = from d in _context.M_USERS where d.USER_ID == userEntity.userId && d.DELETE_FLG == 0 select d; user = queryUser.Single(); string token = Utility.GenerateToken(user, Utility.GetSysDateTime()); AuthRepository auth = new AuthRepository(); auth.UpdateToken(_context, user.USER_ID, token); if (user.MODE_USER == (int)Mode.Partner) { PartnerEntity partnerEntity = Utility.GetPartnerInfo(_context, user.USER_ID); partnerEntity.token = token; return(Ok(new Result { Status = 200, Message = string.Empty, Data = partnerEntity })); } else { UserEntity entity = new UserEntity(); entity.userId = user.USER_ID; entity.phoneNumber = user.PHONE_NUMBER; entity.modeDefault = user.MODE_DEFAULT; entity.modeUser = user.MODE_USER; entity.name = user.NAME; ImageInfoEntity avatar = new ImageInfoEntity(); avatar.path = user.AVATAR; entity.avatar = avatar; entity.token = token; M_HIRER_INFO hirer = _context.M_HIRER_INFOS.FirstOrDefault(x => x.USER_ID == entity.userId); entity.userId = hirer.USER_ID; entity.score = hirer.SCORE; entity.likeNum = hirer.LIKE_NUM; return(Ok(new Result { Status = 200, Message = string.Empty, Data = entity })); } } else { return(Ok(new Result { Status = 404, Message = string.Empty, Data = null })); } } catch (Exception ex) { // Rollback transaction. tran.Rollback(); return(Ok(new Result { Status = 404, Message = "Error system!", Data = null })); } }
/// <summary> /// Insert notify. /// </summary> /// <param name="db">PartTimeDataClassesDataContext</param> /// <param name="notifyType">Notify type</param> /// <param name="id">Object ID</param> /// <param name="userSendId">User send ID</param> /// <param name="userReceiveId">User receive ID</param> /// <param name="receiveModeUser">Receive mode user</param> /// <returns>Success: True; Fail: False</returns> public static bool InsertNotify(AloaiDataContext db, decimal notifyType, decimal id, decimal userSendId , decimal userReceiveId, decimal receiveModeUser) { try { string senderName = string.Empty; // Check User receive notify leaved company but job is exists. // If true is not receive notify. if (notifyType != (int)NotifyType.System) { var queryUser = from d in db.M_USERS where d.USER_ID == userReceiveId select d; if (!queryUser.Any()) { return(true); } var queryExchange = from d in db.V_CONTACT_INFOS where d.CONTACT_ID == id select d; if (!queryExchange.Any()) { return(true); } } D_NOTIFY notify = new D_NOTIFY(); notify.NOTIFY_TYPE = notifyType; notify.OBJECT_ID = id; notify.USER_SEND_ID = userSendId; notify.USER_RECIEVE_ID = userReceiveId; notify.RECEIVE_MODE_USER = receiveModeUser; notify.READED_FLG = (int)ReadedFlg.New; notify.REG_DATETIME = GetSysDateTime(); notify.NOTIFY_DATE = GetSysDateTime(); notify.CONTENT = string.Empty; var query = from d in db.M_USERS where d.USER_ID == userSendId select d; if (!query.Any()) { return(false); } M_USER user = query.Single(); notify.CONTENT = user.NAME; db.D_NOTIFYS.Add(notify); db.SaveChanges(); } catch { return(false); } return(true); }
public ActionResult Create(M_USER m_USER) { if (Session["Admin"] != null) { var sess = Session["Admin"].ToString(); M_PARTY m_PARTY = new M_PARTY(); //for alphanumeric PARTY_TYPE_CD var checks = db.M_PARTY.Where(x => x.PARTY_TYPE_CD.Contains("USER")).ToList(); m_PARTY.PARTY_TYPE_CD = checks.Max(x => x.PARTY_TYPE_CD); if (m_PARTY.PARTY_TYPE_CD == "0" || m_PARTY.PARTY_TYPE_CD == null) { m_PARTY.PARTY_TYPE_CD = "1-1USER"; } else { StringBuilder sb1 = new StringBuilder(); var res1 = Regex.Split(m_PARTY.PARTY_TYPE_CD, @"USER"); var chng1 = res1[0].ToString().Split('-'); var inc1 = ((Convert.ToInt32(chng1[1])) + 1).ToString(); sb1.Append("1-" + inc1 + "USER"); m_PARTY.PARTY_TYPE_CD = sb1.ToString(); } //for alphanumeric PARTY_UID var checks1 = db.M_PARTY.Where(x => x.PARTY_UID.Contains("G")).ToList(); m_PARTY.PARTY_UID = checks1.Max(x => x.PARTY_UID); if (m_PARTY.PARTY_UID == "0" || m_PARTY.PARTY_UID == null) { m_PARTY.PARTY_UID = "1-1G"; } else { StringBuilder sb2 = new StringBuilder(); var res2 = Regex.Split(m_PARTY.PARTY_UID, @"G"); var chng2 = res2[0].ToString().Split('-'); var inc2 = (Convert.ToInt32(chng2[1]) + 1).ToString(); sb2.Append("1-" + inc2 + "G"); m_PARTY.PARTY_UID = sb2.ToString(); } m_PARTY.TRANS_FLG = "1"; m_PARTY.CREATED_DT = System.DateTime.Now; m_PARTY.LAST_UPD_DT = System.DateTime.Now; m_PARTY.ACTIVE_FLG = "1"; m_USER.USER_ID = db.M_USER.Max(x => x.USER_ID); //for alphanumeric user id var res = Regex.Split(m_USER.USER_ID, @"\D+"); if (m_USER.USER_ID == "0" || m_USER.USER_ID == null) { m_USER.USER_ID = "1-1GUSER"; } else { StringBuilder sb = new StringBuilder("1-"); var chng = res[1].ToString(); var inc = (Convert.ToInt32(chng) + 1).ToString(); sb.Append(inc + "GUSER"); m_USER.USER_ID = sb.ToString(); } m_USER.CREATED_DT = System.DateTime.Now; m_USER.LAST_UPD_DT = System.DateTime.Now; m_USER.PW_LAST_UPD = System.DateTime.Now.ToString(); m_USER.CREATED_BY = sess; m_USER.LAST_UPD_BY = sess; m_USER.USER_FLG = "1"; m_USER.PAR_ROW_ID = m_PARTY.PARTY_TYPE_CD; db.M_PARTY.Add(m_PARTY); db.M_USER.Add(m_USER); db.SaveChanges(); return(RedirectToAction("Index2")); } return(RedirectToAction("Login2", "Home")); }
public static PartnerEntity GetPartnerInfo(AloaiDataContext db, decimal userId) { PartnerEntity partnerEntity = null; // User info. var user = from d in db.M_USERS where d.USER_ID == userId select d; if (user.Any()) { partnerEntity = new PartnerEntity(); M_USER userEntity = user.Single(); partnerEntity.phoneNumber = userEntity.PHONE_NUMBER; partnerEntity.name = userEntity.NAME; ImageInfoEntity avatar = new ImageInfoEntity(); avatar.path = userEntity.AVATAR; partnerEntity.avatar = avatar; // Hirer info. var hirerInfo = from d in db.M_PARTNER_INFOS where d.USER_ID == userId select d; if (hirerInfo.Any()) { M_PARTNER_INFO info = hirerInfo.Single(); partnerEntity.userId = info.USER_ID; partnerEntity.introduce = info.INTRODUCE; partnerEntity.fixLocationFlg = info.FIX_LOCATION_FLG == 1 ? true : false; Location location = new Location(); location.longitude = info.LONGITUDE; location.latitude = info.LATITUDE; location.address = info.ADDRESS; partnerEntity.location = location; partnerEntity.verifyFlg = info.VERIFY_FLG == 1 ? true : false; partnerEntity.likeNum = info.LIKE_NUM; partnerEntity.score = info.SCORE; } var catalogUnit = from d in db.V_PARTNERS where d.USER_ID == userId select d; if (catalogUnit.Any()) { partnerEntity.partnerCatalog = new PartnerCatalogEntity(); foreach (V_PARTNER catalog in catalogUnit.ToList()) { partnerEntity.partnerCatalog.userId = catalog.USER_ID; Catalog cal = new Catalog(); cal.catalogCd = catalog.CATALOG_CD; Unit unit = new Unit(); unit.unitCd = catalog.UNIT_CD; string languageType = user.Single().LANGUAGE_TYPE; if (string.IsNullOrEmpty(languageType) || languageType.Equals(Constant.LANGUAGE_VN)) { cal.catalogName = catalog.CATALOG_NAME; unit.unitName = catalog.UNIT_NAME; } else { cal.catalogName = catalog.CATALOG_NAME_EN; unit.unitName = catalog.UNIT_NAME_EN; } partnerEntity.partnerCatalog.catalog = cal; partnerEntity.partnerCatalog.unit = unit; partnerEntity.partnerCatalog.cost = catalog.COST; break; } } partnerEntity.imageInfoList = GetImageList(db, partnerEntity.userId, ImageType.Profile); } return(partnerEntity); }
/// <summary> /// Update user/ company infomation. /// </summary> /// <param name="db">DataContext.</param> /// <param name="userEntity">User entity</param> /// <returns>Ok: true, Fail: false</returns> public static bool UpdatePartner(AloaiDataContext db, PartnerEntity partnerEntity) { var query = from d in db.M_USERS where d.USER_ID == partnerEntity.userId select d; M_USER user = query.Single(); //user.PHONE_NUMBER = partnerEntity.PhoneNumber; user.NAME = partnerEntity.name; if (partnerEntity.avatar != null && !string.IsNullOrEmpty(partnerEntity.avatar.path)) { string avartaPath; if (Utility.UploadAvatar(db, partnerEntity.userId, partnerEntity.avatar, partnerEntity.avatar.path, out avartaPath)) { user.AVATAR = avartaPath; } } user.UPD_DATETIME = Utility.GetSysDateTime(); db.SaveChanges(); var queryPartner = from d in db.M_PARTNER_INFOS where d.USER_ID == partnerEntity.userId select d; if (queryPartner.Any()) { M_PARTNER_INFO partner = queryPartner.Single(); partner.INTRODUCE = partnerEntity.introduce; partner.FIX_LOCATION_FLG = partnerEntity.fixLocationFlg ? 1 : 0; if (partnerEntity.fixLocationFlg) { partner.LONGITUDE = partnerEntity.location.longitude; partner.LATITUDE = partnerEntity.location.latitude; partner.ADDRESS = partnerEntity.location.address; } else { partner.LONGITUDE = string.Empty; partner.LATITUDE = string.Empty; partner.ADDRESS = string.Empty; } partner.UPD_DATETIME = Utility.GetSysDateTime(); db.SaveChanges(); } var queryDel = from d in db.T_PARTNER_CATALOG_UNITS where d.USER_ID == partnerEntity.userId select d; if (queryDel.Any()) { db.T_PARTNER_CATALOG_UNITS.RemoveRange(queryDel.ToList()); db.SaveChanges(); } if (partnerEntity.partnerCatalog != null) { T_PARTNER_CATALOG_UNIT worker = new T_PARTNER_CATALOG_UNIT(); worker.USER_ID = partnerEntity.userId; worker.CATALOG_CD = partnerEntity.partnerCatalog.catalog.catalogCd; worker.COST = partnerEntity.partnerCatalog.cost; worker.UNIT_CD = partnerEntity.partnerCatalog.unit.unitCd; worker.REG_DATETIME = Utility.GetSysDateTime(); db.T_PARTNER_CATALOG_UNITS.Add(worker); db.SaveChanges(); } UploadImage(db, partnerEntity.userId, ImageType.Profile, partnerEntity.imageInfoList); return(true); }