public bool EditAdmin(string userName, string loginPassword, string actionPassword, AdminGroupType groupType, string mac) { var myconn = MyDBHelper.Instance.CreateConnection(); MySqlCommand mycmd = null; try { myconn.Open(); mycmd = myconn.CreateCommand(); string cmdTextA = "update admininfo set `UserName` = @UserName, `LoginPassword` = @LoginPassword, `GroupType` = @GroupType, `Mac` = @Mac where `UserName` = @UserName "; mycmd.CommandText = cmdTextA; mycmd.Parameters.AddWithValue("@UserName", DESEncrypt.EncryptDES(userName)); mycmd.Parameters.AddWithValue("@LoginPassword", DESEncrypt.EncryptDES(loginPassword)); mycmd.Parameters.AddWithValue("@ActionPassword", DESEncrypt.EncryptDES(actionPassword)); mycmd.Parameters.AddWithValue("@GroupType", (int)groupType); mycmd.Parameters.AddWithValue("@Mac", mac); mycmd.ExecuteNonQuery(); return(true); } finally { MyDBHelper.Instance.DisposeConnection(myconn); if (mycmd != null) { mycmd.Dispose(); } } }
public bool AddAdmin(string adminUserName, string loginPassword, string actionPassword, AdminGroupType groupType, string mac) { try { bool isOK = DBProvider.AdminDBProvider.AddAdmin(adminUserName, loginPassword, actionPassword, groupType, mac); if (isOK) { this.ListAdmin.Add(new AdminUIModel(new MetaData.User.AdminInfo() { UserName = adminUserName, LoginPassword = loginPassword, ActionPassword = actionPassword, GroupType = groupType, Macs = new string[] { mac } })); } return(isOK); } catch (Exception exc) { LogHelper.Instance.AddErrorLog("Add Admin Exception", exc); return(false); } }