private void UpdateData(UserRight userRight) { using (SqlConnection connection = new SqlConnection(this._connString)) { string updateSql = @"UPDATE dbo.posTbUserRight SET Name = @URGName, Rights = @URGRights, Status = @URGStatus WHERE IdUserRight = @URGIdUserRight;"; SqlCommand command = new SqlCommand(updateSql, connection); command.Parameters.Add("@URGIdUserRight", SqlDbType.Char).Value = userRight.Id; command.Parameters.Add("@URGName", SqlDbType.VarChar).Value = userRight.Name; command.Parameters.Add("@URGRights", SqlDbType.VarChar).Value = RightsHelper.ToVarchar(userRight.Rights); command.Parameters.Add("@URGStatus", SqlDbType.Bit).Value = userRight.Status; connection.Open(); command.ExecuteNonQuery(); } }
private void InsertData(UserRight userRight) { using (SqlConnection connection = new SqlConnection(this._connString)) { string insertIntoSql = @"INSERT INTO dbo.posTbUserRight (IdUserRight, Name, Rights, Status) VALUES (@URGIdUserRight, @URGName, @URGRights, @URGStatus);"; SqlCommand command = new SqlCommand(insertIntoSql, connection); command.Parameters.Add("@URGIdUserRight", SqlDbType.Char).Value = userRight.Id; command.Parameters.Add("@URGName", SqlDbType.VarChar).Value = userRight.Name; command.Parameters.Add("@URGRights", SqlDbType.VarChar).Value = RightsHelper.ToVarchar(userRight.Rights); command.Parameters.Add("@URGStatus", SqlDbType.Bit).Value = userRight.Status; connection.Open(); command.ExecuteNonQuery(); } }