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 = '******'"));
}
