protected void Delete_Click(object sender, EventArgs e) { ArrayList list = WebUtils.SelectedRepeaterItemToBaseObjectList(db, Repeater, "ItemSelect"); EUser activeUser = WebUtils.GetCurUser(Session); if (activeUser != null) { foreach (EUser user in list) { if (EUser.db.select(dbConn, user)) { bool isAllowDelete = true; if (isAllowDelete) { //WebUtils.StartFunction(Session, FUNCTION_CODE); user.UserAccountStatus = "D"; db.update(dbConn, user); //WebUtils.EndFunction(dbConn); } } } } loadData(info, db, Repeater); }
public void TestLogin() { string usuario = "45785421"; string password = "******"; string tipo = "1"; string URLAuth = "http://localhost:15000/ServiceBares.svc/User?username="******"&password="******"&type=" + tipo; HttpWebRequest req = (HttpWebRequest)WebRequest.Create(URLAuth); req.Method = "GET"; //req.KeepAlive = false; EUser registros = null; try { HttpWebResponse res = (HttpWebResponse)req.GetResponse(); StreamReader reader = new StreamReader(res.GetResponseStream()); string stringJson = reader.ReadToEnd(); JavaScriptSerializer JsonConvert = new JavaScriptSerializer(); registros = JsonConvert.Deserialize <EUser>(stringJson); Assert.IsNotNull(registros); } catch (WebException e) { HttpStatusCode code = ((HttpWebResponse)e.Response).StatusCode; string message = ((HttpWebResponse)e.Response).StatusDescription; StreamReader reader = new StreamReader(e.Response.GetResponseStream()); string error = reader.ReadToEnd(); JavaScriptSerializer js = new JavaScriptSerializer(); string mensaje = js.Deserialize <string>(error); Assert.AreEqual("", mensaje); } }
public EUser InsertarUsuario(EUser oUser) { if (oUser == null) { throw new WebFaultException <string>("Entidad no valida", HttpStatusCode.InternalServerError); } if (String.IsNullOrEmpty(oUser.lastName) || String.IsNullOrEmpty(oUser.firstName)) { throw new WebFaultException <string>("Debe ingresar apellidos y nombres", HttpStatusCode.InternalServerError); } if (String.IsNullOrEmpty(oUser.documentNumber)) { throw new WebFaultException <string>("Debe ingresar el numero de documento", HttpStatusCode.InternalServerError); } if (String.IsNullOrEmpty(oUser.email)) { throw new WebFaultException <string>("Debe ingresar email válido", HttpStatusCode.InternalServerError); } try { EUser usuarioRegistrado; usuarioRegistrado = daoUsuario.Insertar(oUser); return(usuarioRegistrado); } catch (WebException ex) { throw new WebFaultException <string>(ex.ToString(), HttpStatusCode.InternalServerError); } }
public void Delete(EUser user) { DaCommand command = new DaCommand("UserDelete"); command.AddInParameter("@CodeUser", DbType.String, user.CodeUser); ExecuteNonQuery(command); }
public void UpdatePassword(EUser eu) { using (SqlConnection conn = new SqlConnection(ConnectionDB.conString)) { conn.Open(); } }
public MyResult Create(string par0, string par1) { Assembly asmb = Assembly.GetAssembly(typeof(ServiceReturn)); Type type = asmb.GetType(par0); object obj = JsonConvert.DeserializeObject(par1, type); object newObj = DBBase.Create(obj); if (type == typeof(ETask)) { ETask task = (ETask)obj; if (MySession.UserID != task.ExecutorID && task.ExecutorID != 0) { EUser myuser = DBBase.Get <EUser>(MySession.UserID); EUser excuteuser = DBBase.Get <EUser>(task.ExecutorID); List <string> ulist = new List <string>(); ulist.Add(excuteuser.PushClientID); PushMessageToList.PushToList(task.Title, "指派人" + myuser.Name, ulist, true); } } else if (type == typeof(EPlan)) { EPlan plan = (EPlan)obj; EProject project = DBBase.Get <EProject>(plan.ProjectID); EUserSearch userSearch = new EUserSearch() { IsDefault = false, Name = project.Name + "-" + plan.Name, UserID = MySession.UserID, ProjectID = plan.ProjectID, PlanID = plan.ID }; DBBase.Create(userSearch); } return(ServiceResult(newObj)); }
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { if (ddt_curso.SelectedValue == "0") { L_ErrorUsuario.Text = "Debe Elegir un Curso"; } else { DaoUser datos = new DaoUser(); EUser enc = new EUser(); enc.Documento = GridView1.SelectedRow.Cells[0].Text; DataTable reg = datos.obtenerUsuarioMod(enc); enc.Id_estudiante = reg.Rows[0]["id_usua"].ToString(); enc.Curso = ddt_curso.SelectedValue; datos.insertarEstudianteCurso(enc); DataTable materias = datos.obtener_MatCur(enc); int n = materias.DefaultView.Count; for (int i = 0; i < n; i++) { enc.Materia = materias.Rows[i]["id_materia"].ToString(); datos.insertarNotaMateria(enc); } GridView1.DataBind(); L_ErrorUsuario.Text = ""; } }
protected void B_Enviar_Click(object sender, EventArgs e) { String nombres = TB_Nombres.Text; String apellidos = TB_Apellidos.Text; String correo_l = TB_Correo.Text; String telefono = TB_Telefono.Text; String mensaje = TB_Mensaje.Text; string destinatario = "*****@*****.**"; string asunto = "**¡¡CONTACTENOS!!**"; //CORREO******************************* EUser encapsular = new EUser(); DaoUser datos = new DaoUser(); encapsular.Correo = destinatario.ToString(); DataTable resultado = datos.verificarCorreo(encapsular); if (resultado.Rows.Count > 0) { DaoUser dao = new DaoUser(); mensaje = mensaje + "<br><br>Atentamente: " + nombres + "<br>" + apellidos + "<br>Correo para responder: " + correo_l + "<br>Telefono: " + telefono + ""; string cadena = mensaje; CorreoEnviar correo = new CorreoEnviar(); correo.enviarCorreoEnviar(destinatario, asunto, mensaje); this.RegisterStartupScript("mensaje", "<script type='text/javascript'>alert('Su Mensaje ha sido Enviado.');window.location=\"InicioContactenos.aspx\"</script>"); } else { this.RegisterStartupScript("mensaje", "<script type='text/javascript'>alert('Ha ocurrido un problema.');window.location=\"InicioContactenos.aspx\"</script>"); } }
//Registrar Usuario public DataTable registrarUsuario(EUser user) { DataTable Usuario = new DataTable(); NpgsqlConnection conectar = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["Postgres"].ConnectionString); try { NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("usuarios.f_insertar_usuario", conectar); dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure; dataAdapter.SelectCommand.Parameters.Add("_documento", NpgsqlDbType.Varchar).Value = user.Documento; dataAdapter.SelectCommand.Parameters.Add("_nombres", NpgsqlDbType.Varchar).Value = user.Nombres; dataAdapter.SelectCommand.Parameters.Add("_apellidos", NpgsqlDbType.Varchar).Value = user.Apellidos; dataAdapter.SelectCommand.Parameters.Add("_usuario", NpgsqlDbType.Varchar).Value = user.Usuario; dataAdapter.SelectCommand.Parameters.Add("_clave", NpgsqlDbType.Varchar).Value = user.Clave; conectar.Open(); dataAdapter.Fill(Usuario); } catch (Exception e) { throw e; } finally { if (conectar != null) { conectar.Close(); } } return(Usuario); }
/// <summary> /// 添加用户 /// </summary> public bool AddUser(EUser user, out string msg) { msg = string.Empty; try { if (DACFacade.Movo.UserDAC.SelectByName(user.UserName) != null) { msg = "用户名重复,请重新输入"; return false; } //加载当前完整的用户信息 EUser currentUser = DACFacade.Movo.UserDAC.Select(user.UserCode); if (currentUser == null) { msg = "系统异常 没有找到当前用户"; return false; } user.UserCode = DACFacade.Movo.IdentityNoDAC.GetUserSerialNo(); user.UserGroupID = currentUser.UserGroupID; user.TenantCode = currentUser.TenantCode; user.CreateTime = DateTime.Now; return DACFacade.Movo.UserDAC.Insert(null, user) > 0 ? true : false; } catch (Exception ex) { msg = ex.Message; return false; } }
protected void btnEntrar_Click(object sender, EventArgs e) { if (txtDocumento.Text == "" && txtNombre.Text == "" && txtApellido.Text == "" && txtUserName.Text == "" && txtClave.Text == "") { lblMensaje.Text = "Hay Campos Vacios!"; } else { EUser user = new EUser(); DAOUsersInsertar daoUserInsertar = new DAOUsersInsertar(); DAOUsersConsultar daoUserConsultar = new DAOUsersConsultar(); user.Documento = txtDocumento.Text; DataTable consulta = daoUserConsultar.consultarUsuario(user); if (consulta.Rows.Count > 0) { lblMensaje.Text = "El Usuario " + txtNombre.Text + " " + txtApellido.Text + " ya se encuentra Registrado"; } else { user.Documento = txtDocumento.Text; user.Nombres = txtNombre.Text; user.Apellidos = txtApellido.Text; user.Usuario = txtUserName.Text; user.Clave = txtClave.Text; daoUserInsertar.registrarUsuario(user); Response.Redirect("login.aspx"); } } }
public UserOutputDto Register(UserInputDto input) { // create user record var record = new EUser { Gender = Gender.Male, Occupation = input.User.Occupation, UserName = input.User.Username, Password = input.User.Password, IsActive = true, Name = input.User.Name, // set role to USER role ERole = _roleRepository.GetOne(2) }; // create record var user = _userRepository.CreateEntity(record); if (user != null) { return(new UserOutputDto { UserId = user.Id, Name = user.Name, Gender = Enum.GetName(typeof(Gender), user.Gender), Occupation = user.Occupation, LastLoginDate = user.CreatedDateTime, Role = user.ERole.Name }); } return(null); }
protected void btn_AcudienteAceptar_Click(object sender, EventArgs e) { EUser usua = new EUser(); DaoUser dat = new DaoUser(); usua.Documento = tb_AcudienteId.Text; DataTable registros = dat.obtenerUsuarioMod(usua); if (registros.Rows.Count > 0) { tb_AcudienteNombre.Text = Convert.ToString(registros.Rows[0]["nombre_usua"].ToString()); tb_AcudienteApellido.Text = Convert.ToString(registros.Rows[0]["apellido_usua"].ToString()); tb_AcudienteCorreo.Text = Convert.ToString(registros.Rows[0]["correo"].ToString()); tb_AcudienteDireccion.Text = Convert.ToString(registros.Rows[0]["direccion"].ToString()); tb_AcudienteTelefono.Text = Convert.ToString(registros.Rows[0]["telefono"].ToString()); tb_AcudienteUsuario.Text = Convert.ToString(registros.Rows[0]["user_name"].ToString()); tb_AcudienteContrasenia.Text = Convert.ToString(registros.Rows[0]["clave"].ToString()); fechanac.Text = Convert.ToString(registros.Rows[0]["fecha_nac"].ToString()); //this.Page.Response.Write("<script language='JavaScript'>window.alert('<<Listo men>>');</script>"); if (Convert.ToString(registros.Rows[0]["estado"].ToString()) == "True") { DDL_Estado.SelectedValue = "Activo"; } else { DDL_Estado.SelectedValue = "Inactivo"; } ddt_lugarnacimDep.SelectedValue = Convert.ToString(registros.Rows[0]["dep_nacimiento"].ToString()); DDT_Ciudad.DataBind(); DDT_Ciudad.SelectedValue = Convert.ToString(registros.Rows[0]["ciu_nacimiento"].ToString()); tb_AcudienteId.ReadOnly = true; tb_AcudienteNombre.ReadOnly = false; tb_AcudienteApellido.ReadOnly = false; tb_AcudienteCorreo.ReadOnly = false; tb_AcudienteDireccion.ReadOnly = false; tb_AcudienteTelefono.ReadOnly = false; tb_AcudienteUsuario.ReadOnly = false; tb_AcudienteContrasenia.ReadOnly = false; fechanac.ReadOnly = false; L_ErrorAdmin.Text = ""; btn_AcudienteEditar.Visible = true; btn_AcudienteNuevo.Visible = true; btn_AcudienteAceptar.Visible = false; } else { L_ErrorAdmin.Text = "Sin Registros"; } }
public FrmLogin() { InitializeComponent(); eu = new EUser(); ea = new EAccount(); ubol = new UserBOL(); }
public void Select() { bool result = false; BUser bUser = new BUser(); EUser eUser = new EUser(); EUser selectedUser = null; TransactionScope ts = new TransactionScope(TransactionScopeOption.RequiresNew); eUser.CodeUser = Aleatory.GetString(8); eUser.Name = Aleatory.GetString(8); eUser.Password = Aleatory.GetString(8); eUser.Email = Aleatory.GetString(15); eUser.State = Aleatory.GetShort(); eUser.Audit.UserRegister = Aleatory.GetString(8); selectedUser = bUser.Select(eUser); if (selectedUser == null) { bUser.Insert(eUser); selectedUser = bUser.Select(eUser); } if (selectedUser != null && selectedUser.CodeUser == eUser.CodeUser && selectedUser.Name == eUser.Name && selectedUser.State == eUser.State) { result = true; } Assert.AreEqual(result, true); }
protected void Repeater_ItemDataBound(object sender, RepeaterItemEventArgs e) { DataRowView row = (DataRowView)e.Item.DataItem; CheckBox cb = (CheckBox)e.Item.FindControl("ItemSelect"); EUser obj = new EUser(); db.toObject(((DataRowView)e.Item.DataItem).Row, obj); EUser user = WebUtils.GetCurUser(Session); if (obj.UserID.Equals(1)) { cb.Visible = false; } else if (user != null) { if (obj.UserID.Equals(user.UserID)) { cb.Visible = false; } } WebFormUtils.LoadKeys(db, row, cb); }
//Registrar Comentarios public DataTable registrarComentario(EUser user) { DataTable comentario = new DataTable(); NpgsqlConnection conectar = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["Postgres"].ConnectionString); try { NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("comentarios.f_insertar_comentario", conectar); dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure; dataAdapter.SelectCommand.Parameters.Add("_comentario", NpgsqlDbType.Text).Value = user.Comentario; dataAdapter.SelectCommand.Parameters.Add("_id_foto", NpgsqlDbType.Bigint).Value = user.IdFoto; dataAdapter.SelectCommand.Parameters.Add("_fecha", NpgsqlDbType.Timestamp).Value = user.Fecha; dataAdapter.SelectCommand.Parameters.Add("_usuario", NpgsqlDbType.Varchar).Value = user.Documento; conectar.Open(); dataAdapter.Fill(comentario); } catch (Exception e) { throw e; } finally { if (conectar != null) { conectar.Close(); } } return(comentario); }
protected void btn_validar_Click(object sender, EventArgs e) { EUser usua = new EUser(); DaoUser dat = new DaoUser(); usua.UserName = tb_AdministradorUsuario.Text; usua.Documento = (Convert.ToInt64(tb_AministradorAdministradorId.Text)).ToString(); DataTable registros = dat.validar_usuarioadmin(usua); if (registros.Rows.Count > 0) { tb_Vusuario.Text = Convert.ToString(registros.Rows[0]["user_name"].ToString()); tb_Vdocumento.Text = Convert.ToString(registros.Rows[0]["num_documento"].ToString()); L_ErrorUsuario.Text = "El Usuario ya existe"; } else { L_ErrorUsuario.Text = ""; L_OkUsuario.Text = "Usuario Disponible"; btn_AdministradorAceptar.Visible = true; btn_EstudianteNuevo.Visible = true; btn_validar.Visible = false; tb_AdministradorUsuario.ReadOnly = true; tb_AministradorAdministradorId.ReadOnly = true; tb_AdministradorFoto.Enabled = true; btnigm_calendar.Visible = true; } }
//protected void Page_Init(object sender, EventArgs e) //{ // EUser defaultUser = (HROne.Lib.Entities.EUser)Session["User"]; // if (defaultUser != null) // { // EUser user = new EUser(); // user.UserID = defaultUser.UserID; // user.UserLanguage = cboLanguage.SelectedValue; // WebUtils.SetSessionLanguage(Session, user); // HROne.Common.WebUtility.initLanguage(Session); // } //} protected void Page_Load(object sender, EventArgs e) { if (!WebUtils.CheckAccess(Response, Session)) { return; } reminderBinding = new SearchBinding(dbConn, EReminderType.db); EUser user = WebUtils.GetCurUser(this.Session); if (user != null) { CurID = user.UserID; } string selectedLanguage = cboLanguage.SelectedValue; cboLanguage.Items.Clear(); cboLanguage.Items.Add(new ListItem("System Default", "")); WebUtils.AddLanguageOptionstoDropDownList(cboLanguage); cboLanguage.SelectedIndex = cboLanguage.Items.IndexOf(cboLanguage.Items.FindByValue(selectedLanguage)); reminderInfo = ListFooter.ListInfo; productLicense = WebUtils.productLicense(Session); if (productLicense.ProductType != HROne.ProductLicense.ProductLicenseType.HROne) { UserIsKeepConnectedRow.Visible = false; } }
public MyResult TaskProcess(int par0, int par1, int par2, string par3) { ETask task = DBBase.Get <ETask>(par0); task.ExecutorID = par1; task.State = par2; ETaskTransfer taskTransfer = new ETaskTransfer() { TaskID = task.ID, AppointPersonID = MySession.UserID, AssignedPersonID = par1, CreateTime = System.DateTime.Now, ToState = task.State, Note = par3 }; DBBase.Change(task); DBBase.Create(taskTransfer); if (MySession.UserID != task.ExecutorID && task.ExecutorID != 0) { EUser myuser = DBBase.Get <EUser>(MySession.UserID); EUser excuteuser = DBBase.Get <EUser>(task.ExecutorID); List <string> ulist = new List <string>(); ulist.Add(excuteuser.PushClientID); PushMessageToList.PushToList(task.Title, "指派人" + myuser.Name, ulist, true); } return(ServiceResult(task.ID)); }
protected bool loadObject() { EUser user = new EUser(); user.UserID = CurID; if (EUser.db.select(dbConn, user)) { cboLanguage.SelectedValue = user.UserLanguage; UserIsKeepConnected.Checked = user.UserIsKeepConnected; } else { return(false); } //ETaxPayment obj = new ETaxPayment(); //bool isNew = WebFormWorkers.loadKeys(ETaxPayment.db, obj, DecryptedRequest); //if (!ETaxPayment.db.select(dbConn, obj)) // return false; //Hashtable values = new Hashtable(); //db.populate(obj, values); //binding.toControl(values); //if (obj.TaxPayCode.Length == 2) // a.k.a k1,k2,k3 with nature // TaxPayNature.Visible = true; //else // TaxPayNature.Visible = false; return(true); }
protected void btn_Subirnota_Click(object sender, EventArgs e) { if (ddl_alumno.SelectedValue == "0" || ddl_materia.SelectedValue == "0" || ddt_curso.SelectedValue == "0") { L_Error.Text = "Falta seleccionar"; } else { DaoUser datos = new DaoUser(); EUser enc = new EUser(); enc.Id_estudiante = ddl_alumno.SelectedValue; enc.Materia = ddl_materia.SelectedValue; enc.Curso = ddt_curso.SelectedValue; DataTable registros = datos.obtenerNota(enc); enc.IdNota = registros.Rows[0]["id_nota"].ToString(); Double n1 = Convert.ToDouble(tb_nt.Text); Double n2 = Convert.ToDouble(tb_nt2.Text); Double n3 = Convert.ToDouble(tb_nt3.Text); Double nd = (n1 + n2 + n3) / 3.0; enc.Nota1 = n1.ToString(); enc.Nota2 = n2.ToString(); enc.Nota3 = n3.ToString(); enc.Notadef = nd.ToString(); tb_denifitiva.Text = nd.ToString(); datos.insertarNota(enc); ButtonVerNota.Visible = false; btn_Subirnota.Visible = true; } }
public EUser Select(string emp_cd) { EUser EU = null; using (SqlCommand cmd = new SqlCommand("Select * FROM m_employee WHERE emp_cd = @emp_cd", con, trn)) { cmd.Parameters.Add(new SqlParameter("@emp_cd", SqlDbType.Char)).Value = emp_cd; using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { EU = new EUser(); EU.emp_cd = emp_cd; EU.last_nm = reader["last_nm"].ToString(); EU.first_nm = reader["first_nm"].ToString(); EU.last_nm_kana = reader["last_nm_kana"].ToString(); EU.first_nm_kana = reader["first_nm_kana"].ToString(); EU.gender_cd = int.Parse(reader["gender_cd"].ToString()); EU.section_cd = reader["section_cd"].ToString(); reader.Close(); } } } return(EU); }
public void UpdateCompanies(UserModel userModel) { var userCompanyBussines = new BUserCompany(); var userEntity = new EUser() { CodeUser = userModel.CodeUser }; var Companies = new List <string>(); if (!string.IsNullOrEmpty(userModel.CompaniesSplit)) { Companies = userModel.CompaniesSplit.Split( separator: new char[] { ',' }, options: StringSplitOptions.RemoveEmptyEntries).ToList(); } if (Companies.Count == 0) { if (userModel.CompaniesModel.Count > 0) { foreach (var item in userModel.CompaniesModel) { Companies.Add(item.CodeCompany); } } } userEntity.Companies = Companies; userCompanyBussines.UpdateByUser(userEntity); }
public async Task <IActionResult> Create(CreateUserViewModel model) { if (ModelState.IsValid) { EUser user = new EUser { Email = model.Email, UserName = model.Email, FIO = model.FIO }; var result = await userManager.CreateAsync(user, model.Password); if (result.Succeeded) { await RegistrationAlertAsync(user, model.Password); return(RedirectToAction("Index")); } else { foreach (var error in result.Errors) { ModelState.AddModelError(string.Empty, error.Description); } } } return(View(model)); }
public EAccount Login(EUser eu) { using (SqlConnection conn = new SqlConnection(ConnectionDB.conString)) { conn.Open(); EAccount ea = new EAccount(); string PasswordDB = ""; string sql = "SELECT account_users.id, account_users.id_user, account_users.account, users.id, " + "users.email, users.password FROM account_users INNER JOIN users ON " + "users.email = @email AND account_users.id_user = users.id;"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@email", eu.Email); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { ea.Id = reader.GetInt32(0); ea.IdUser = reader.GetInt32(1); ea.Account = reader.GetString(2); PasswordDB = reader.GetString(5); } if (!BCrypt.Net.BCrypt.Verify(eu.Password, PasswordDB)) { throw new Exception("El correo o contraseña son incorrectos."); } return(ea); } }
public async Task <IActionResult> Edit(EditUserViewModel model) { if (ModelState.IsValid) { EUser user = await userManager.FindByIdAsync(model.Id); if (user != null) { user.Email = model.Email; user.UserName = model.Email; user.FIO = model.FIO;//потом можно разделить var result = await userManager.UpdateAsync(user); if (result.Succeeded) { return(RedirectToAction("Index")); } else { foreach (var error in result.Errors) { ModelState.AddModelError(string.Empty, error.Description); } } } } return(View(model)); }
protected void Page_Load(object sender, EventArgs e) { Response.Cache.SetNoStore(); if (Session["userId"] != null) { DaoUser datos = new DaoUser(); EUser enc = new EUser(); DateTime fecha = DateTime.Now; string año = (fecha.Year).ToString(); año = año + "-01-01"; DataTable re = datos.obtenerAniodeCurso(año); enc.Año = re.Rows[0]["id_anio"].ToString(); enc.Id_estudiante = DDT_estudiante.SelectedValue; DataTable registros = datos.obtenerCursoEst(enc); if (registros.Rows.Count > 0) { Session["anio"] = registros.Rows[0]["id_ancu"].ToString(); Session["est"] = DDT_estudiante.SelectedValue; } else { Session["anio"] = "0"; Session["est"] = DDT_estudiante.SelectedValue; } } else { Response.Redirect("AccesoDenegado.aspx"); } }
protected void Delete_Click(object sender, EventArgs e) { EUser activeUser = WebUtils.GetCurUser(Session); EUser c = new EUser(); c.UserID = CurID; if (EUser.db.select(dbConn, c)) { bool isAllowDelete = true; if (isAllowDelete) { //WebUtils.StartFunction(Session, FUNCTION_CODE); c.UserAccountStatus = "D"; db.update(dbConn, c); //WebUtils.EndFunction(dbConn); } else { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); errors.addError("Invalid Permission"); return; } } HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "User_List.aspx"); }
public DataRow Select(EUser user) { DaCommand command = new DaCommand("UserSelect"); command.AddInParameter("@CodeUser", DbType.String, user.CodeUser); return(ExecuteDataRow(command)); }
public void Validar(object sender, EventArgs e) { String login = TxtLogin.Text; String pass = TxtPass.Text; EUser ouser = new EUser { Login = login, CLave = pass }; Acceso = dUser.ValidarUsuario(ouser); if (Acceso != 0) { Mensaje.Text = ""; Session["Usuario"] = Acceso; Habilitar(); ListarApli(Acceso); } else { Session["Usuario"] = 0; Mensaje.Text = "Usuario no encontrado :("; } }
/// <summary> /// 修改用户 /// </summary> public bool UpdateUser(EUser user, out string msg) { msg = string.Empty; try { return DACFacade.Movo.UserDAC.Update(null, user) > 0 ? true : false; } catch (Exception ex) { msg = ex.Message; return false; } }
/// <summary> /// 增加子用户 /// </summary> /// <param name="userName"></param> /// <param name="passWord"></param> /// <param name="op">操作类型</param> /// <returns></returns> public JsonResult ChildUserAddOrModify(string userName, string userCode, string tenantCode, string passWord, string op) { passWord = MD5Core.Encrypt(passWord); bool isSuccess = false; string msg = string.Empty; EUser user = new EUser(); if (op == "Add" || op == "")//用于新增子用户 { user.UserName = userName; user.PassWord = passWord; user.UserCode = Passport.UserCode; user.TenantCode = Passport.TenantCode; isSuccess = ModelFacade.Platform.UserModel.AddUser(user, out msg); } else { user.UserName = userName; user.UserCode = userCode; user.PassWord = passWord; user.TenantCode = Passport.TenantCode; isSuccess = ModelFacade.Platform.UserModel.UpdateUser(user, out msg); } JsonResult json = new JsonResult(); if (isSuccess) { json.Data = new { res = true }; } else { json.Data = new { res = false, message = msg }; } return json; }
/// <summary> /// 判断权限,一个用户对应唯一机构,且机构许可具备手机客服权限判断 /// </summary> /// <param name="user"></param> /// <returns></returns> private AndroidData<RUserInfo> IsInstallPermission(EUser user) { AndroidData<RUserInfo> data = new AndroidData<RUserInfo>(); if (user == null) { data.ResultCode = ResultCodeEnum.Fail; data.Message = "用户名或密码错误"; return data; } int count = user.TenantList != null ? user.TenantList.Count : 0; if (count == 0 || count>1) { data.ResultCode = ResultCodeEnum.Fail; if (count == 0) { data.Message = "请联系客服人员,尚未成为客户"; } else { data.Message = "请联系客服人员,确定帐号是否属于唯一机构"; } return data; } string TenantCode = user.TenantList[0].TenantCode; string ProductCode = "BOSS"; IList<LicenseEntity> lsLicense = GuanacoServiceFacade.Permission.GetLicenseByTenant(TenantCode); if (lsLicense == null || lsLicense.Count == 0) { data.ResultCode = ResultCodeEnum.Fail; data.Message = "请联系客服人员,机构尚未许可"; return data; } LicenseEntity entity = lsLicense.SingleOrDefault(o => o.RDProductCode == ProductCode); if (entity == null) { data.ResultCode = ResultCodeEnum.Fail; data.Message = "请联系客服人员,机构没有分配许可"; return data; } if (entity.HasPermissionLimit.HasValue && entity.HasPermissionLimit.Value) { IList<PermissionEntity> lsPermission = PermissionDALFacade.PermissionDAL.SelectByLicenseTypeId(entity.LicenseTypeID); if (lsPermission == null || lsPermission.Count == 0) { data.ResultCode = ResultCodeEnum.Fail; data.Message = "请联系客服人员,机构许可没有分配权限"; return data; } bool Flag = lsPermission.Any(p => p.PermissionCode == InstallPermissionCode); if (!Flag) { data.ResultCode = ResultCodeEnum.Fail; data.Message = "请联系客服人员,机构许可没有分配手机客服权限"; return data; } } data.ResultData = CovnertToUserInfo(user); data.Ticket = EncryptHelper.Encrypt<Ticket>(new Ticket() { UserCode = user.UserCode, UserName = user.UserName, Password = user.PassWord }); data.ResultCode = ResultCodeEnum.Success; return data; }
/// <summary> /// 新增客户 /// </summary> public void AddCustomer(SessionContext passport, string userName, string password, string tenantName, string phoneNumber, string email) { var selected = this.GetSelectedTenant(passport); var parentMerchant = DACFacade.Movo.TenantDAC.Select(selected.TenantCode); if (parentMerchant == null) throw new BusinessException("父级运营商不存在!"); //if (parentMerchant.OperatorLevel + 1 > 5) throw new BusinessException("新增失败,子运营商不能多于5级!"); var existUser = DACFacade.Movo.UserDAC.SelectByName(userName); if (existUser != null) { throw new BusinessException("用户名" + userName + "已经存在,请重新输入!"); } var existTenant = DACFacade.Movo.TenantDAC.SelectByName(tenantName); if (existTenant != null) { throw new BusinessException("公司名称" + tenantName + "已经存在,请重新输入!"); } // 构建Tenant var tenant = new ETenant(); tenant.TenantCode = DACFacade.Movo.IdentityNoDAC.GetTenantSerialNo(); tenant.TenantName = tenantName; tenant.SuperTenantID = parentMerchant.TenantCode; tenant.CreateTime = DateTime.Now; tenant.ExpireTime = null; tenant.ContactName = string.Empty; tenant.PhoneNumber = phoneNumber; tenant.TenantType = EnumTenantType.EndCustomer; tenant.IsFreeze = false; tenant.QQ = string.Empty; tenant.Email = email; tenant.RegisterUserCode = DACFacade.Movo.IdentityNoDAC.GetUserSerialNo(); tenant.RegisterUserName = userName; tenant.OperatorLevel = null; tenant.LogoUrl = null; // 构建UserGroup var userGroup = new EUserGroup() { UserGroupID = DACFacade.Movo.IdentityNoDAC.GetUserGroupID(), UserGroupName = "管理员", TenantCode = tenant.TenantCode, IsAdminGroup = true, }; // 构建User var user = new EUser(); user.UserCode = tenant.RegisterUserCode; user.UserName = userName; user.UserGroupID = userGroup.UserGroupID; user.TenantCode = tenant.TenantCode; if (!string.IsNullOrEmpty(password)) user.PassWord = password; user.RealName = userName; user.Mobile = string.Empty; user.IsRegisterUser = true; user.LastLoginTime = null; user.CreateTime = DateTime.Now; // 构建VehicleGroup var vehGroup = new EVehicleGroup() { GroupID = DACFacade.Movo.IdentityNoDAC.GetVehicleGroupID(), GroupName = userName, TenantCode = tenant.TenantCode, }; using (var trans = DACFacade.Movo.TenantDAC.BeginTransaction()) { try { DACFacade.Movo.UserDAC.Insert(trans, user); DACFacade.Movo.UserGroupDAC.Insert(trans, userGroup); DACFacade.Movo.VehicleGroupDAC.Insert(trans, vehGroup); DACFacade.Movo.TenantDAC.Insert(trans, tenant); DACFacade.Movo.TenantDAC.CommitTransaction(trans); } catch { DACFacade.Movo.TenantDAC.RollbackTransaction(trans); throw; } } }
/// <summary> /// 添加运营商 /// </summary> public bool AddMerchant(VMerchant merchant, out string msg) { msg = string.Empty; //检查是否存在注册用户 if (DACFacade.Movo.UserDAC.SelectByName(merchant.UserName) != null) { msg = "用户名重复,请重新输入"; return false; } //检查是否存在运营商 if (DACFacade.Movo.TenantDAC.SelectByName(merchant.TenantName) != null) { msg = "公司名称重复,请重新输入"; return false; } //创建运营商tenant ETenant tenant = new ETenant(); tenant.ContactName = merchant.ContactName; tenant.ExpireTime = merchant.ExpireTime.Equals(DateTime.MaxValue) ? null : (DateTime?)merchant.ExpireTime; tenant.TenantName = merchant.TenantName; tenant.TenantCode = DACFacade.Movo.IdentityNoDAC.GetTenantSerialNo(); tenant.SuperTenantID = merchant.SuperTenantID; tenant.Email = merchant.Email; tenant.QQ = merchant.QQ; tenant.PhoneNumber = merchant.PhoneNumber; tenant.LogoUrl = UploadImageHelper.GetImgName(merchant.TenantLogoImgURl); tenant.TenantType = EnumTenantType.OperatingMerchant; tenant.OperatorLevel = merchant.OperatorLevel; tenant.CreateTime = DateTime.Now; tenant.IsFreeze = false; tenant.RegisterUserName = merchant.UserName; tenant.IsEnableAddDevice = merchant.IsEnableAddDevice; //创建用户组userGroup EUserGroup userGroup = new EUserGroup(); userGroup.IsAdminGroup = true; userGroup.TenantCode = tenant.TenantCode; userGroup.UserGroupID = DACFacade.Movo.IdentityNoDAC.GetUserGroupID(); userGroup.UserGroupName = merchant.UserName; //创建注册用户User EUser user = new EUser(); user.PassWord = merchant.Password; user.UserCode = DACFacade.Movo.IdentityNoDAC.GetUserSerialNo(); user.UserName = merchant.UserName; user.CreateTime = DateTime.Now; user.IsRegisterUser = true; user.UserGroupID = userGroup.UserGroupID; user.TenantCode = tenant.TenantCode; tenant.RegisterUserCode = user.UserCode; using (var trans = DACFacade.Movo.TenantDAC.BeginTransaction()) { try { int addtenant = DACFacade.Movo.TenantDAC.Insert(trans, tenant); int addusergroup = DACFacade.Movo.UserGroupDAC.Insert(trans, userGroup); int adduser = DACFacade.Movo.UserDAC.Insert(trans, user); if (addtenant >= 1 && addusergroup >= 1 && adduser >= 1) { trans.Commit(); return true; } else { trans.Rollback(); msg = "添加运营商数据异常(addtenant:" + addtenant.ToString() + "addusergroup:" + addusergroup.ToString() + "adduser:"******")"; Logger.Error(msg); return false; } } catch (Exception ex) { msg = ex.Message; trans.Rollback(); Logger.Error(ex.Message, ex); } } return false; }