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); } }