public int update(SysUserVo sysUser) { try { this.QUERY = new StringBuilder(fromDatabase); this.addInQuery("UPDATE SigaUsers"); this.addInQuery(" SET idUserGroup = " + sysUser.IDUSERGROUP + ""); this.addInQuery(" , username = '******'"); this.addInQuery(" , [password] = '" + sysUser.PASSWORD + "'"); this.addInQuery(" , [name] = '" + sysUser.NAME + "'"); this.addInQuery(" , fullname = '" + sysUser.FULLNAME + "'"); this.addInQuery(" , MailServer = '" + sysUser.MAILSERVER + "'"); this.addInQuery(" , MailDoor = '" + sysUser.MAILDOOR + "'"); this.addInQuery(" , MailUser = '******'"); this.addInQuery(" , MailPasswd = '" + sysUser.MAILPASSWD + "'"); this.addInQuery(" , MailAddress = '" + sysUser.MAILADDRESS + "'"); this.addInQuery(" WHERE id = " + sysUser.ID); return(getData().DefaultView.Count); } catch (Exception e) { throw new Exception(Carralero.ExceptionControler.getFullException(e).ToString()); } }
public int insert(SysUserVo sysUser) { try { this.QUERY = new StringBuilder(fromDatabase); this.addInQuery("INSERT INTO SigaUsers (idUserGroup, [name], fullname, username, [password], MailServer, MailDoor, MailUser, MailPasswd, MailAddress)"); this.QUERY.Append("VALUES ("); this.QUERY.Append("" + sysUser.IDUSERGROUP + ","); this.QUERY.Append("'" + sysUser.NAME + "',"); this.QUERY.Append("'" + sysUser.FULLNAME + "',"); this.QUERY.Append("'" + sysUser.USERNAME + "',"); this.QUERY.Append("'" + sysUser.PASSWORD + "',"); this.QUERY.Append("'" + sysUser.MAILSERVER + "',"); this.QUERY.Append("'" + sysUser.MAILDOOR + "',"); this.QUERY.Append("'" + sysUser.MAILUSER + "',"); this.QUERY.Append("'" + sysUser.MAILPASSWD + "',"); this.QUERY.Append("'" + sysUser.MAILADDRESS + "'"); this.addInQuery(")"); return(getData().DefaultView.Count); } catch (Exception e) { throw new Exception(Carralero.ExceptionControler.getFullException(e).ToString()); } }
public void load(List <SysUserVo> users, int idUserGroup) { DataTable table = select(idUserGroup); for (int i = 0; i < table.DefaultView.Count; i++) { SysUserVo user = new SysUserVo(); user.USERNAME = (string)table.DefaultView[i]["username"]; load(user, user.USERNAME); users.Add(user); } }
public int save(SysUserVo sysUser) { int iRet = 0; if (sysUser.ID == 0) { iRet = insert(sysUser); load(sysUser, sysUser.USERNAME); } else { iRet = update(sysUser); } return(iRet); }
public void load(SysUserVo user, int idUserGroup, string filtro) { DataTable table = select(idUserGroup, filtro, true); if (table.DefaultView.Count > 0) { user.ID = (int)table.DefaultView[0]["id"]; user.IDUSERGROUP = (int)table.DefaultView[0]["idUserGroup"]; user.NAME = (string)table.DefaultView[0]["name"]; user.FULLNAME = (string)table.DefaultView[0]["fullname"]; user.PASSWORD = (string)table.DefaultView[0]["password"]; user.USERNAME = (string)table.DefaultView[0]["username"]; user.MAILSERVER = (string)table.DefaultView[0]["MailServer"]; user.MAILUSER = (string)table.DefaultView[0]["MailUser"]; user.MAILPASSWD = (string)table.DefaultView[0]["MailPasswd"]; user.MAILADDRESS = table.DefaultView[0]["MailAddress"].ToString(); user.MAILDOOR = (int)table.DefaultView[0]["MailDoor"]; } }
public void load(SysUserVo user, string username, string password) { string filter = "username = '******' AND [password] = '" + password + "'"; load(user, 0, filter); }
public void load(SysUserVo user, string username) { string filtro = " username = '******'"; load(user, 0, filtro); }
public int delete(SysUserVo sysUser) { return(delete(sysUser.IDUSERGROUP, "username = '******'")); }