public int UpdatePassword(string userId, string oldPassword, string newPassword)
{
using (Sbw.DbClinet.DbClinet Client = new Sbw.DbClinet.DbClinet())
{
return(Client.ExecuteNonQuery(new UP_UpdateUserPassword(userId, oldPassword, newPassword)));
}
}
public bool Delete(int id)
{
UP_Simple up = new UP_Simple("UP_DeleteUser");
up.InputParams.Add("id", id);
using (Sbw.DbClinet.DbClinet Client = new Sbw.DbClinet.DbClinet())
{
return(Client.ExecuteNonQuery(up) > 0);
}
}
public int EditUserRecordPermission(string userId, string exts, string agents)
{
UP_Simple up = new UP_Simple("UP_RecordPermission");
up.InputParams.Add("userId", userId);
up.InputParams.Add("exts", exts);
up.InputParams.Add("agents", agents);
using (Sbw.DbClinet.DbClinet Client = new Sbw.DbClinet.DbClinet())
{
return(Client.ExecuteNonQuery(up));
}
}
public int AddUser(int?id, string userId, string passowrd, string userName, string agentId, int permId, string permission)
{
UP_AddUser up = new UP_AddUser();
up.Id = id;
up.AgentId = agentId;
up.Passowrd = passowrd;
up.UserName = userName;
up.UserId = userId;
up.PermId = permId;
up.Permission = permission;
using (Sbw.DbClinet.DbClinet Client = new Sbw.DbClinet.DbClinet())
{
return(Client.ExecuteNonQuery(up));
}
}
public Model.Table.User Login(string userId, string password, string ip)
{
using (Sbw.DbClinet.DbClinet Client = new Sbw.DbClinet.DbClinet())
{
UP_UserLogin up = new UP_UserLogin(userId, password, ip);
Esunnet.Model.Table.User user = Client.Select <Esunnet.Model.Table.User>(up).FirstOrDefault();
if (user == null)
{
user = new Esunnet.Model.Table.User();
user.State = up.Return;
}
else
{
user.State = 1;
}
return(user);
}
}
